Post reply

New to Full text search and need some pointers.

  • June 17, 2008 at 3:53 pm

    #208468

    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

    #834857

    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:

    St Street

    Street Street

    St. Street

    Cir Circle

    Circle Circle

    Cir. Circle

    Dr Drive

    Drive Drive

    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