Functions/Text & patterns/levenshtein
Text & patterns Scalar

levenshtein()

The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Different case is considered different

Arguments & returns

levenshtein(str1, str2)

Scalar
Overload link str1str2 Returns
#01 VARCHARVARCHAR BIGINT

Example

levenshtein example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  levenshtein('duck', 'db');

In other engines

BigQueryedit_distance()

EDIT_DISTANCE(a, b)
In DuckDB
LEVENSHTEIN(a, b)

SQLGlot example ↗

Exasoledit_distance()

EDIT_DISTANCE(col1, col2)
In DuckDB
LEVENSHTEIN(col1, col2)

SQLGlot example ↗

Snowflakeeditdistance()

EDITDISTANCE(col1, col2)
In DuckDB
LEVENSHTEIN(col1, col2)

SQLGlot example ↗