DIFFERENCE

Returns an Integer value from 0 to 4 representing the difference between the sounds of two strings based on applying the SOUNDEX function to the strings. Value of 4 is the best possible match. Arguments can be strings, but not BLOBS.

Example:

Assume the following statement:

  SELECT DIFFERENCE('CONSTRAINT','CONSTANT'),
         SOUNDEX('CONSTRAINT'),
         SOUNDEX('CONSTANT')
    FROM QSYS2.QSQPTABL

Returns 4, C523, and C523. Since the two strings return the same SOUNDEX value, the difference is 4 (the highest value possible).