Hello,

some weeks ago I asked for a fuzzy string search. Someone posted an
example using Oracle Text.

Now I'm interested in a similar, but technically different thing:
Instead of searching fuzzy, I would like to strictly search for the
words given, but optionally present similar items.

I guess everyone has seen this before at google.com: Try a search for
"oskar wilde" and google will respond with:

"Did you mean: oscar wilde"

How can I do this with Oracle Text (any anyway else without having to
invent the logic behind it completey from scratch)?

Regards
Marten

On Feb 11, 8:10 pm, Marten Lehmann <lehmannmap... (AT) cnm (DOT) de> wrote:
Similar results: that would be fuzzy after all...
Guess you have to compare the number of exact matches to
the number of fuzzy matches. If fuzzy matching deliveres
a magnitude larger results than exact, it might be a good
idea to question the input and offer the fuzzy match as
alternative.

On Feb 11, 8:10 pm, Marten Lehmann <lehmannmap... (AT) cnm (DOT) de> wrote:
Similar results: that would be fuzzy after all...
Guess you have to compare the number of exact matches to
the number of fuzzy matches. If fuzzy matching deliveres
a magnitude larger results than exact, it might be a good
idea to question the input and offer the fuzzy match as
alternative.

On Feb 11, 8:10 pm, Marten Lehmann <lehmannmap... (AT) cnm (DOT) de> wrote:
Similar results: that would be fuzzy after all...
Guess you have to compare the number of exact matches to
the number of fuzzy matches. If fuzzy matching deliveres
a magnitude larger results than exact, it might be a good
idea to question the input and offer the fuzzy match as
alternative.

On Feb 11, 8:10 pm, Marten Lehmann <lehmannmap... (AT) cnm (DOT) de> wrote:
Similar results: that would be fuzzy after all...
Guess you have to compare the number of exact matches to
the number of fuzzy matches. If fuzzy matching deliveres
a magnitude larger results than exact, it might be a good
idea to question the input and offer the fuzzy match as
alternative.

Well, but how do I find out the fuzzy matches? How do I know that there
is "oscar" which is similar to "oskar"?

Regards
Marten

Well, but how do I find out the fuzzy matches? How do I know that there
is "oscar" which is similar to "oskar"?

Regards
Marten

Well, but how do I find out the fuzzy matches? How do I know that there
is "oscar" which is similar to "oskar"?

Regards
Marten

Well, but how do I find out the fuzzy matches? How do I know that there
is "oscar" which is similar to "oskar"?

Regards
Marten

Marten Lehmann wrote:
where ... contains versus where instr(..) >0?

Or whatever fuzzy method you use... Bottom line is, you
would have to do it twice (or inspect the indexes for
near hits): once for exact matches, once for the fuzzy.

Guess it's time for OracleText internals... What does
Thomas Kyte have to say about it - did you check om
asktom.oracle.com?
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up