Introduction
Computes the edit distance (also known as Levenshtein distance) between two strings. Use it to see how similar or dissimilar the string values in two columns are, such as when evaluating the quality of a company name match.
| FORMULA | EDITDISTANCE |
| EXAMPLE FORMULA | EDITDISTANCE(Column A, Column B) |
| EXAMPLE INPUT | EDITDISTANCE(company, dbcompany) |
| EXAMPLE OUTPUT | 2 |
Sample Usage
| Valid Examples | Invalid Examples |
| EDITDISTANCE(text_col, text_col_2) | EDITDISTANCE(num_col, num_col) |
Notes
- Only "string" data types can be used with this formula
- Counts the difference between each string "letter"
- Cannot compute the distance between dates
See Also
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article