ORACLE Text - using wordlist to build a "Did you mean?.." search feature

unficyp

Hi,

using 19c Enterprise Edition and APEX 21.2.

We have some internal knowledge-database application which is searchable using Oracle Text, indexed column contains HTML text. People now voted for a "Did you mean? xyz" feature when they search for a word and the search has no result.

My idea was to use the wordlist generated by Oracle Text - to be precise the DR$xxx$I table and search that table using utl_match.edit_distance_similarity or jaro_winkler_similarity and return the best matching row (1 row only) to the user.

Problem: the text index contains the words for more than one "client" and the user is only allowed to see specific articles/clients. So i have to put the token_text from DR$xxx$I in some relationship to restrict access to words that are in other client-articles which the user has no access to.

• Does Oracle Text support adding custom values to the wordlist when creating the wordlist ?
• Does Oracle Text already have any similar feature?

thanks & regards

User_H3J7U

Oracle Text features: fuzzy, stemming, thesaurus.

The Fuzzy match is similar to the utl_match.xxx_similarity.

User_H3J7U

Be careful with utl_match. It compares the bytes, two-byte characters may be a half-similar.

BluShadow

https://community.oracle.com/tech/developers/discussion/4492592/oracle-text-using-wordlist-to-build-a-did-you-mean-search-feature

I wouldn't limit yourself just just 1 row as you may have multiple matches with the same "score".