Database & utility
Scalar
damerau_levenshtein()
Extension of Levenshtein distance to also include transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one string to another. Different case is considered different
Arguments & returns
damerau_levenshtein(str1, str2)
Scalar
| Overload link | str1 | str2 |
Returns |
|---|---|---|---|
| #01 | VARCHAR | VARCHAR |
BIGINT |
Example
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
Catalog examples
SELECT
damerau_levenshtein('hello', 'world');