Fuzzy string search?

Hello,

in our application it would be very helpful, if the search wouldn't return only exact matches, but also similar items, e.g.

search for "models" returns also "model"
search for "exmaple" returns also "example"
search for "dl365" returns also "dl385"

How can I do this with Oracle? Is there any extension I have to install? Or is there a function like the function to match regular expressions?

Regards
Marten Received on Tue Jan 08 2008 - 08:13:24 CST