Pattern matches across 2 table columns

[ashley25]

I am trying to find company matches between 2 tables. The issue I have is that the spellings on table A differs from table B.

Some of the differences are minimal like "St. Annes" and "St Annes". And some really big "St. Annes" and "Annes, ST London"

Has anyone ever attempted to tackle such an issue and how would I tackle it?

 

[plog]

It's a pain and will likely come down to some sort of manual process. Basically, you identify each case that can occur that makes a match and work through them one by one.

First though, are you sure you don't have unexact duplicates within A or within B? For example "St. Annes" in A and "Saint Annes" in A as well? Also, how many records are in A and B?