SQL Server Performance

Fuzzy lookup??

Discussion in 'SQL Server 2005 Integration Services' started by jarrodr, Feb 26, 2009.

  1. jarrodr New Member

    Hi all,
    I have 2 tables, a Persons table (alot of records, where the surnames could be enter incorrectly due to human error) and a Surname table (has 10 records with correct surnames that I am looking for in the Persons table).
    How do I use the Fuzzy lookup to lookup on surnames that look the same.Eg. Petersen could look like peteiren, peterson, pterson.
    NB. There could be more than one of the same surnames that appear in the Persons table.
  2. patel_mayur New Member

  3. jarrodr New Member

    Iv'e tried that, but it only returns exact matchs
  4. patel_mayur New Member

    Check with Mapping Type, It should be "Fuzzy" & not "Exact". ( Right Click on Mapping and then Edit Mapping under Columns Tab )
    Also check with Similarity Threshold on "Advanced" tab. ( try with any value between 0.2 to 0.5 ).
    Fuzzy lookup will return you "_Similarity" & "_Confidence" along with other columns that you have in transformation.
    For "peteiren" compare to actual value "Petersen", i am getting _Similarity value as 0.7381395

Share This Page