Fuzzy Matching

[dmilroy]

I have our customer database. I purchased a sales prospecting database. I need to match our records to the same ones in the purchased database. I want to "fuzzy match" my "company name" to the corresponding field in the purchased database. I know there are some algorithms to accomplish this, but I am new and can't seem to get them to work. Help would be greatly appreciated!!:banghead:

 

[Alansidman]

In your criteria for the field with the names, try entering this:

Like *Company Name*

 

[nanscombe]

Are you wanting a Soundex search? One which gives you a range of matching names, ie search for Smith results in Smith, Smithe, Smythe etc.

This allen Browne article might be worth a read if it is.

Soundex - Fuzzy matches