Sybase difference function

Code	Output
select difference( 'See', 'Sea' )	4
select difference( 'there', 'their' )	4
select difference( 'Roger', 'ROGER' )	4
select difference( 0x526F676552, 'ROGER' )	4
select difference( 'asdr', 'asdf' )	3
select difference( 'aser', 'asdf' )	2
select difference( 'Sea', 'Karina' )	2
select difference( 'awer', 'asdf' )	1
select difference( 'qwer', 'asdf' )	0
select difference( 'Roger', NULL )	NULL
select difference( NULL, 'Roger' )	NULL
select difference( 'Roger', 1 )	Error
select difference( 1, 'Roger' )	Error

Difference compares the soundex value of the two parameters and returns a value from 0 to 4.