Brendan Tierney gets comparing:
When comparing text strings we have a number of functions on Oracle Database to help us. These include SOUNDEX, PHONIC_ENCODE and FUZZY_MATCH. Let’s have a look at what each of these can do.
These are some classic word comparison techniques, but they work pretty well in specific circumstances.