---
title: "Comment by Hayrullah Kar on \"Match Names with Typos in Google Sheets (Fuzzy Name Matching)\" | Hashnode"
description: "Cleaning first and only reaching for edit distance for what is left is a sensible order, and the warning that first initial plus last word gives false positives"
url: "https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f/comment/6afe965948c32b1a248e4233"
---

[Discussion](https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f)

Comment [Match Names with Typos in Google Sheets (Fuzzy Name Matching)](https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f)

[Hayrullah Kar](https://hashnode.com/@magesheet)

[4h ago](https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f/comment/6afe965948c32b1a248e4233)

Cleaning first and only reaching for edit distance for what is left is a sensible order, and the warning that first initial plus last word gives false positives is honest. One thing about the 0.85 cut-off: NAMESCORE divides by the longer length, so short names cross it easily. 'Ann Lee' against 'Ann Lea' is one edit over 7 characters, about 0.86, and 'Jon Smith' against 'Jan Smith' is about 0.89. Both pairs are different people. For names I would make the cut-off depend on length, or send anything short that scores below 1 to a 'check by eye' column instead of accepting it. It also helps to feed the sorted key from Step 1 into NAMESCORE rather than the raw cell. Otherwise 'Smith, John' against 'John Smith' scores very low, even though the cleaning step already knows they are the same name.

[Snakbacks](https://hashnode.com/@snakbacks)

[4h ago](https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f/comment/6afe965948c32b1a248e4233#reply-6afe9afc263bcc3dff1982f3)

Thanks, both points are right, and I checked your numbers: "Ann Lee"/"Ann Lea" scores 0.857 and "Jon Smith"/"Jan Smith" 0.889 with NAMESCORE, so a flat 0.85 lets short different names through. Scoring the raw "Smith, John" against "John Smith" gives just 0.09, while the sorted key gives 1. I've updated the guide to recommend a stricter cut-off (or a "check by eye" column) for short names, and to score the cleaned key rather than the raw cell. Appreciate the careful read.
