What it does
Fuzzy Match finds rows that mean the same thing but are not spelled the same, such as "ACME, Inc." and "Acme Incorporated", or "Jon Smith" and "Smith, John".
- Match two lists. For every row in one list, it finds the best match in another list and writes the match, its score and, if you want, a value from a return column into new columns. Long lists run in parts, so they stay inside Google's time limits.
- Find similar duplicates. Pick a range and choose how strict to be. Fuzzy Match adds "Duplicate group" and "Similarity" columns and colours each group. Nothing is deleted, so you decide what to merge.
- FUZZYLOOKUP formula.
=FUZZYLOOKUP(A2, Customers!A:A)works like a lookup that tolerates typos, word order and punctuation. It can return a value from another column and the similarity score. - FUZZYSCORE formula.
=FUZZYSCORE(A2, B2)gives the similarity of two values, or two columns, from 0 to 100.
You can ignore case, extra spaces, punctuation and accents, and switch each of those off.
Free and Pro
| Feature | Free | Pro |
|---|---|---|
| FUZZYLOOKUP and FUZZYSCORE formulas | Yes | Yes |
| Find similar duplicates | Up to 500 rows per run | No row limit |
| Match two lists | Up to 500 rows, lookup list up to 1,000 rows | No row limit |
| Matching methods | Token set, Jaro-Winkler, Levenshtein | Also Token sort, Partial, Dice and Best-of |
| Repeat last run | No | Yes |
Pro costs $7 per month or $49 per year. You can use the free plan without a key. A Pro key works on up to 3 devices. Paddle handles the payment as merchant of record and shows any tax before you pay.
Your data
The add-on can open only the spreadsheet you use it in. Matching runs inside Google Apps Script, so your cell contents are never sent to BLZN Works. It contacts blznworks.com only for anonymous usage counts and to check a Pro license. The privacy policy lists exactly what is sent and stored.
Availability
Fuzzy Match is not on the Google Workspace Marketplace yet. We will add the install link here when it is. For questions, use the contact form.