Word comparison functions

The word comparison functions are useful for “fuzzy” comparisons: finding records in a database that approximately match a search key, phonetically or lexically.

For those functions that operate only on ASCII characters, you can transliterate the strings to convert any accented characters to their ASCII unaccented versions.

If you want to ignore case for those functions that consider case when evaluating strings, you can use Netezza Performance Server functions such as upper() and lower() to change the letter casing of strings before the comparison. For information about these functions, see the IBM Netezza Database User's Guide.