1 / 6

Error Tolerance vs. Soundex

Error Tolerance vs. Soundex. If you don’t happen to live in a Perfect World!. RCP Consulting Limited Suite B, 15 th Floor, Casey Building, 38, Lok Ku Road, Sheung Wan, Hong Kong Tel: 2815 9911 Fax : 2815 0611 E : Datactics@rcp.com.hk. File of Surnames with Duplicates.

gaetan
Download Presentation

Error Tolerance vs. Soundex

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Error Tolerance vs. Soundex If you don’t happen to live in a Perfect World! RCP Consulting Limited Suite B, 15th Floor, Casey Building, 38, Lok Ku Road, Sheung Wan, Hong Kong Tel: 2815 9911 Fax : 2815 0611 E : Datactics@rcp.com.hk

  2. File of Surnames with Duplicates • 31 candidate records • 10 individuals RCP Consulting Limited Suite B, 15th Floor, Casey Building, 38, Lok Ku Road, Sheung Wan, Hong Kong Tel: 2815 9911 Fax : 2815 0611 E : Datactics@rcp.com.hk

  3. Standard SQL Matching • Exact matching • 1 identity found - Walker (2 records) If only our data was perfect! RCP Consulting Limited Suite B, 15th Floor, Casey Building, 38, Lok Ku Road, Sheung Wan, Hong Kong Tel: 2815 9911 Fax : 2815 0611 E : Datactics@rcp.com.hk

  4. Soundex Matching • Converts name to a code, based on 1st letter followed by up to 3 digits. English pronunciation based. • 3 identities found • Walker (5 records) • Wilkinson (4 records) • Frankowa (2 records) What did we miss, though? RCP Consulting Limited Suite B, 15th Floor, Casey Building, 38, Lok Ku Road, Sheung Wan, Hong Kong Tel: 2815 9911 Fax : 2815 0611 E : Datactics@rcp.com.hk

  5. What Soundex missed and why? • Key consonant missing • First character missing • Silent characters • Additional consonant RCP Consulting Limited Suite B, 15th Floor, Casey Building, 38, Lok Ku Road, Sheung Wan, Hong Kong Tel: 2815 9911 Fax : 2815 0611 E : Datactics@rcp.com.hk

  6. Fuzzy Matching • All matches found • 10 identities RCP Consulting Limited Suite B, 15th Floor, Casey Building, 38, Lok Ku Road, Sheung Wan, Hong Kong Tel: 2815 9911 Fax : 2815 0611 E : Datactics@rcp.com.hk

More Related