LEVENSHTEIN
Measures the edit distance (Levenshtein distance) between two text strings
Description
The LEVENSHTEIN() function is used to calculate the Levenshtein distance between two text strings. Levenshtein distance is a metric that quantifies the number of single-character edits (insertions, deletions, substitutions) needed to transform one text into another. It's useful for tasks like fuzzy string matching and spell-checking
Syntax
LEVENSHTEIN(text1, text2)
text1: The first text string for comparison.text2: The second text string for comparison.
Example
Table
ID
Text1
Text2
1
Hello
Hallo
2
Example
Sample
3
Kitten
Sitting
Function
LEVENSHTEIN(`Text1`, `Text2`)Results
LEVENSHTEIN (number)
1
2
3
Last updated