CTXSYS fuzzy searching [message #615972] |
Wed, 11 June 2014 07:31 |
|
JamesAlcroft
Messages: 2 Registered: June 2014
|
Junior Member |
|
|
Been suggested to post this here.
Could someone explain the following and whether we have done something wrong please.
Have a table, dict_prod, with a column (among other) of fuzzy_brand. We have the following index on this column:
create index IDX_TXT_DICT_BRAND
on DICT_PROD(FUZZY_BRAND)
indextype is ctxsys.context
parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE');
We are using the following SQL:
select fuzzy_brand from dict_prod WHERE CONTAINS(fuzzy_brand,'fuzzy({xxx},,,weight)', 1) > 20;
We get the following results (replacing xxx with the text below), which doesn't make much sense to me:
D-WORM doesn't fuzzy match
but
1-WORM and DW-WORM does
D%WORM doesn't fuzzy match
but
1%WORM does
D WORM doesn't fuzzy match
but
5 WORM and DW WORM does
Any advice/suggestion appreciated.
James
|
|
|