June 17, 2008 at 3:53 pm
I have a project where I need to try to match and address file to a master address file and create a list of possible matches. I can create a list using the weighting feature of the ContainsTable function to match on different pieces of a company name, but how would I check for possible versions of personal names like Bill and William? Also where are there good examples of different "real life" situations that have use this?
Thanks in advance
Kelly
June 26, 2008 at 11:05 am
That is not really a funtion of full text search. You need either software to propose alternate possibilities or build it yourself. For me I have to compare the address of two systems often and it meant I had to create a table for alternate spellings like so.
Table: Address_Alternate_Spellings
From_Value varchar(100) not null
To_Value varchar(100) not null
Examples:
StStreet
StreetStreet
St.Street
CirCircle
CircleCircle
Cir.Circle
DrDrive
DriveDrive
Dr.Drive
Etc
Then in my query I parse the data into individual words and substitute the To_Value for the From_Value on both sides and determine equality.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply