Similarity Scoring
LEVENSHTEIN
Returns the Levenshtein edit distance between two values.
Syntax
=LEVENSHTEIN(left, right, [case_sensitive])Parameters
NameTypeDescription
Name
leftTypetext, number, date, or range
DescriptionFirst value or range to compare.
Name
rightTypetext, number, date, or range
DescriptionSecond value or range to compare.
Name
case_sensitive?Typeboolean
DescriptionTRUE preserves case. Defaults to FALSE.
Returns
The edit distance as a number. Matching ranges spill pairwise distances.
Example
=LEVENSHTEIN("kitten", "sitting")Result: 3
Notes
Lower scores mean fewer edits are needed.
Use SIMILARITY with method levenshtein when you want a normalized 0-1 score instead.