Re: fuzzy matching with ORACLE

For text strings, you can use the SOUNDEX function. This will perform some fuzzy matching. Unless someone else has writtern other fuzzy matching routines, you'll have to create them on your own.

HTH,
Brian

Martin Buhl wrote:
>
> Hey Everybody
>
> I need to do some fuzzy matching of new data and the data allready in
> the db, before updating the db.
> I wonder if I can find any PL SQL fuzzy match functions written by
> other programmers that I could use.
> What is the easiest way to implement fuzzymatching with ORACL ?
>
> My only other choice (as I see it) is to select all data form the db
> and bring it to the client and then run it through a fuzzy match
> function that I write my self in C++.
> I would really like to avoid this practice.
>
> So if anybody knows what the easiest way to do server side fuzzy
> matching with oracle is, your help will be appreciated.
>
> //Martin
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================