---
title: "Discussion on \"Match Names with Typos in Google Sheets (Fuzzy Name Matching)\" | Hashnode"
description: "Discussion on \"Match Names with Typos in Google Sheets (Fuzzy Name Matching)\". Names that should match but do not are a daily Sheets problem: \"Smith, John\" against \"John Smith\", \"Jon\" against \"John\", \"Dr. J. Smith\" against \"John Smith\". Standard lookups need an exact match. This"
url: "https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Match Names with Typos in Google Sheets (Fuzzy Name Matching)](https://snakbacks.hashnode.dev/match-names-with-typos-in-google-sheets-fuzzy-name-matching?utm_source=hashnode&utm_medium=feed)

Names that should match but do not are a daily Sheets problem: "Smith, John" against "John Smith", "Jon" against "John", "Dr. J. Smith" against "John Smith". Standard lookups need an exact match. This

6h ago · 5 min read · snakbacks.hashnode.dev  
Read the article

-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)

## Written by

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

@snakbacks

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

Google Sheets how-tos: fuzzy matching, duplicates and lookups. Tested formulas you can copy.

Snakbacks builds small, fast Google Sheets tools and writes tested how-to guides at https://www.snakbacks.com

## Responses 2

Markdown supported · ⌘↵ to post

[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.
