Help Center/Data Lake Insight/Spark SQL Syntax Reference/Built-In Functions/String Functions/levenshtein
Updated on 2023-10-25 GMT+08:00
View PDF

levenshtein

This function is used to returns the Levenshtein distance between two strings, for example, levenshtein('kitten','sitting') =3.

Levenshtein distance is a type of edit distance. It indicates the minimum number of edit operations required to convert one string into another.

Syntax

levenshtein(string A, string B)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

A, B

Yes

STRING

String to be entered for calculating the Levenshtein distance

Return Values

The return value is of the INT type.

Example Code

The value 3 is returned.

SELECT levenshtein('kitten','sitting');
Parent topic:String Functions