Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: String comparisons

Re: String comparisons

From: rsenn <rsenn_at_capaccess.org>
Date: 1997/12/29
Message-ID: <34A87922.25B3E6A0@capaccess.org>#1/1

Rushika Pandya wrote:

> Can anyone think of a good way to compare two strings and rate how
> close
> they are to each other. For example:
> Ericsson Systems
> &
> Ericsosn Cystem
>
> You could give these two a rating of 5/16. The 5 indicates that they
> differ
> by 5 characters (s & o reversed (2), S & C (2), and missing s (1)) and
> the
> 16 is the length of the strings (average=16.5).

   You might try the SOUNDEX features. Received on Mon Dec 29 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US