Fuzzy search and score values in CDS view in HANA and not in SQL

Hi Team,

I need to make the Fuzzy search on a particular field in CDS view field.

i tried in blog but i could not able to get it and it was related to SQL and not in CDS.

scenario is -

1. There is a Customer Name field in the table where i need to make the fuzzy search for it.

2. I need to display the score value along with the existing field using cds with revenue field as priority one.

Can anyone suggest an idea on this .

Regards,

Karthik S