Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11g XE - Fuzzy Matching

SDCraigSep 10 2014 — edited Sep 12 2014

Hello:

Could I get some clarification on the differences between the fuzzy matching phrase "contains(field, '?searchterm') > 0 versus the phrase "contains('fuzzy(field, searchterm, 60, 100)' > 0"? Can I assume that since the "?" phrase doesn't include similarity score or number of terms that it defaults to 60, 100? If so, then both phrases as typed will provide similar results?

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2014

Added on Sep 10 2014

#database-key-features, #text

4 comments

1,880 views