Step-by-step fixes with formulas you can copy, tested in a real Google Sheet.
FUZZYMATCH, FUZZYLOOKUP and FUZZYSCORE: a fuzzy VLOOKUP that tolerates typos, case, punctuation and word order. Paste once or copy a template sheet. No add-on install, so it works where add-ons are blocked. US$9: https://snakback.gumroad.com/l/fuzzy-formulas
A free Google Sheets template with a LEVENSHTEIN named function, a 0 to 1 similarity score and a best-match lookup, all pure formulas. Enter $0 to get it: https://snakback.gumroad.com/l/levenshtein-starter
Find near-duplicates that exact formulas miss (ACME Pty. Ltd = Acme Pty Ltd), plus ready-made tabs to merge and sum, keep the latest row, compare lists, split names and clean text. One template, no add-on. US$15: https://snakback.gumroad.com/l/data-cleanup-kit
Snakbacks is a small studio that builds and maintains add-ons for Google Sheets. We focus on tools that are fast, ask only for the permissions they need, and keep working.
Duplicate Remover and Fuzzy Match, our free add-ons for Google Sheets, are coming soon to the Google Workspace Marketplace.
We also take over and maintain popular add-ons whose original developers have moved on.
Contact: info@snakbacks.com