Fuzzy Search for alphanumeric content

[former_member213759]

Hi Experts,

I have implemented fuzzy search in HANA on the material short and long description texts. There is a scenario where if we search alphanumeric content it splits the entered search text and then searches individually for those.

Eg: I search for 25MM but it fetches 25 separately and MM separately instead of searching for 25MM as a single word.

Please suggest how can I resolve this issue.

Regards,

Sakshi

[pfefferf · Accepted solution]

Hello Sakshi,

do you do a phrase search using double quotes? Check the help here - paragraph "Reserved Words and Special Characters in the Search String": The CONTAINS() Predicate - SAP HANA Fuzzy Search Reference - SAP Library

Best Regards,

Florian

[Former Member]

Hi Sakshi,

Try using different variants of similar calculation mode

eg: CONTAINS(column_name, 'search_string', FUZZY(0.8,'similarCalculationMode=compare')) 

other modes are similarCalculationMode=search, similarCalculationMode=substringsearch to achieve results based on your use case.

Regards

Anil