Re: text fuzzy seach on sentences

philippe mercier <pmercier_at_telelingua.com> wrote:
>
>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?

Look at Oracle Text - it's included with 9i, not a separate product:

<http://technet.oracle.com/products/text/content.html>

(I haven't used it myself, but it looks like the sort of thing you want.)

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/