Marten Lehmann wrote:
Quote:
Guess you have to compare the number of exact matches to
the number of fuzzy matches.
Well, but how do I find out the fuzzy matches? How do I know that there
is "oscar" which is similar to "oskar"?
Regards
Marten |
You are probably referring to SOUNDEX
http://www.psoug.org/reference/string_func.html#sfsd
But also look at Oracle Text and the UTL_MATCH package:
http://www.psoug.org/reference/utl_match.html
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org