Skip to main content

Looking for guidance on How To - Programmatically identify what is a potential match/duplicate for customers and accounts (Michael Smith/Mike Smith or Maitland Rd, Maitland Road)

  1. Same address but Name at address created for Nick name and full name
  2. Same address -Look for close spellings already in the records, Krehling and Krehiling 
  3. Same address and Same name but spaces added: (D & J Locksmithing, D&J Locksmithing)
  4. Same address and Same name but corporate designations like LLC or Inc added. The Shanahan Group, The Shanahan Group LLC
  5. Same address and same name with a middle initial (Terrence P. Riordan and Terrence Riordan)
  6. Same account name but address abbreviation different (91 Kansas Street vs 91 Kansas St)

Hello,

This link contains strategies for finding duplicate mailing addresses using programming code.

(Disclaimer: I’m not a developer. The post seems to contain lots of ideas, from a layman’s perspective.)

 

Laura


Reply