Skip to Main Content

Help with fuzzy search (doesn't work if change order of certain 2 letters)

647225Mar 3 2010 — edited Mar 6 2010
Hi,

need some help with fuzzy search. It's pretty simple - we use fuzzy search on varchar2 columns that contain first name and last_name. The problem is that i don't really understand why it can't find name in some cases.

Say i want to search for 'Taekpaul'. Then

where CONTAINS(first_name,'fuzzy(TAEKPAUL)',1) > 0 - works
where CONTAINS(first_name,'fuzzy(TAEKPALU)',1) > 0 - works (changed order of the 2 last letters)
where CONTAINS(first_name,'fuzzy(TEAKPAUL)',1) > 0 - doesn't work, finds 'Tejpaul' that is completely unrelated (changed 2nd, 3rd order)

How can i make it find 'Taekpaul' even if i search for TEAKPAUL? Is it related to index? Like Text index should be created with some different parameters?

Thanks!

Edited by: Maitreya2 on Mar 3, 2010 2:08 PM
Comments
Post Details
Added on Mar 3 2010
5 comments
2,500 views