Fuzzy score calculation HANA search

[Former Member]

I went though the HANA database guide for SQL function Fuzzy search. It is quite comprehensive document. But I was not able to sort out how the score was calculated for each select statement. For example : In page 16 of the document, score = 0.94 fora the selected record. Does anybody know how this value was arrived at?

[Former Member · Accepted solution]

[Former Member · Accepted solution]

I would like to thank everyone who tried to solve this issue. I got the answer from the same document.

Formula for score calculation:

score = bestMatchingTokenWeight x max(tokenScores) + (1-bestMatchingTokenWeight) x √(Σ(tokenScore²)/tokenCount)