Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to do a "fuzzy" or approximate matching of strings in a SQL where clause
You can look into Warehouse Builder OWB_MATCH_MERGE package, that allows
to do couple of fuzzy matches. Fuctions are Similarity, Jaro_Winkler,
JW_SIMILARITY, DOUBLE_METAPHONE, EDIT_DISTANCE.
I suppose that purchase of 1 license of OWB is required to legally use
this package on all databases in your enterprise.
goyald_at_gmail.com wrote:
> Hello
> My input data consists of a string field. I need to find rows where
> this string field is matching "approximately"!! i.e. I need some kind
> of a fuzzy match.
>
> Is there any such inbuilt facilitty/function in SQLServer or Oracle?
>
> Thanks and regards
>
Received on Mon Aug 08 2005 - 13:55:41 CDT