You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

To use these functions, the Text Feature is required

Soundex(String)

Computes the Soundex value of the string. 

Example
SELECT soundex("Hello") FROM Stream
=> "H400"

ColognePhonetic(String)

Computes the Cologne Phonetic value of the string. 

Example
SELECT colognePhonetic("Hello") FROM Stream
=> "05"

Metaphone(String)

Computes the Metaphone value of the string. 

Example
SELECT metaphone("Hello") FROM Stream
=> "HL"

Levenstein(String, String)

Computes the Levenstein Distance of two strings. 

Example
SELECT levenstein("Hello", "Hallo") FROM Stream
=> 1

  • No labels