Text & patterns Scalar

levenshtein()

The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Characters of different cases (e.g., a and A) are considered different.

Arguments & returns

`levenshtein(s1, s2)`

Scalar

Overload link	`s1`	`s2`	Returns
#01	`VARCHAR`	`VARCHAR`	`BIGINT`

Example

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

BigQuery`edit_distance()`

EDIT_DISTANCE(a, b)

In DuckDB

LEVENSHTEIN(a, b)

SQLGlot example ↗

Exasol`edit_distance()`

EDIT_DISTANCE(col1, col2)

In DuckDB

LEVENSHTEIN(col1, col2)

SQLGlot example ↗

Snowflake`editdistance()`

EDITDISTANCE(col1, col2)

In DuckDB

LEVENSHTEIN(col1, col2)

SQLGlot example ↗

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3

Arguments & returns

levenshtein(s1, s2)

Example

In other engines

BigQueryedit_distance()

Exasoledit_distance()

Snowflakeeditdistance()

`levenshtein(s1, s2)`

BigQuery`edit_distance()`

Exasol`edit_distance()`

Snowflake`editdistance()`