Re: find a 80% text match

you have to create a soundex algorithm. These are pretty complex(Ive never made one).
Soundex is similiar to 'sounds like'. Its an ANSI SQL function. You will want to check the documentation on OTN for the basics and then do a search on the web for 'hopefully' some code that you can use.

If you find some... could you please email it to me.. could be useful down the line. :)

"philippe mercier" <pmercier_at_telelingua.com> wrote in message news:c77d3e62.0206070812.26de2697_at_posting.google.com...
> Hi
>
> I have a database with tables that contain sentences.
>
> if I have for example a record with the text "the house is white" in a
> table
>
> I want to know if i can locate this record by typing for example "the
> house is blue" ? if yes, how.
>
> So in fact, I want the system to look for records that match 80% of my
> words (or another percentage).
>
> I could also type "the appartment is white" and I want the system to
> find "the house is white" record since there is only one word
> difference. Or "the appartment is blue" should also find and tell me
> that there is a 60% match for example...
>
> can this be done with oracle, how?
>
> thanks
> philippe
Received on Sun Jun 09 2002 - 23:49:58 CEST