Skip to content
v1.35.9
Install

DIFFERENCE

DIFFERENCE(string1, string2)

Section titled “DIFFERENCE(string1, string2)”
  • string1: The first string to compare.
  • string2: The second string to compare.

Example

Section titled “Example”
SELECT DIFFERENCE('test', 'tost')

Output

Section titled “Output”
2

Explanation

Section titled “Explanation”

The DIFFERENCE function returns an integer that represents the difference between the SOUNDEX values of two strings. In the example, the difference between ‘test’ and ‘tost’ is 2, indicating a moderate match according to the SOUNDEX system. This function is useful for comparing the similarity of words based on their phonetic sounds.