Fuzzy match of two table fields
Posted on 2012-08-29
I've got two tables, one that holds a company id, the name, and address, and another table that holds a company name and plant id.
The IDs are two different IDs and I need to write an update to the table to fill in the plant id to the main table.
The problem is, I really only have an address, phone number, and company name to work with.
I was able to match about 260 records by using the address and phone fields, but that leaves me with 3,000 records unmatched.
An example follows:
In one table, the company name is Weleetka Power Station
In the other table, the company is Weleetka Generating Station.
That is a pretty simple example
Then I run into an example where it's not always the first set of words that doesnt match.
APCOMPOWER AT COMANCH is stored in one table, and Comanche Power Station.
Any help in the right direction is greatly appreciated.