cancel
Showing results for 
Search instead for 
Did you mean: 

Fuzzy score calculation HANA search

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
Former Member
0 Kudos

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)

Answers (0)