Measuring string similarity in BigQuery using SQL

Use Levenshtein distance to discover similar or duplicated values, clean your data, and more

Photo by Suraj Kardile on Unsplash

Using the Levenshtein distance method

This method can be used among others (Soundex, LIKE statement, Regexp) to perform string similarity or string matching in order to…