I have 2 tables with company names. The list of company names is input by seperate (unrelated) entities in each table. I need to compare the company name in each table and 1) automatically select the closest match and 2) present a list of other name sorted by matchness.
The data will be close each time and will have different spacing and spelling, etc. - i.e.
Table 1 Name Table 2 Name
Betfair 123 Betfair 123
Bet fair 123
Betfair123
123BetFair
BetFare 123
and so on....
I need the system to match table 1 against an entry of these in table 2
Any help greatly appreciated.
The data will be close each time and will have different spacing and spelling, etc. - i.e.
Table 1 Name Table 2 Name
Betfair 123 Betfair 123
Bet fair 123
Betfair123
123BetFair
BetFare 123
and so on....
I need the system to match table 1 against an entry of these in table 2
Any help greatly appreciated.