Skip to Content
0
Jun 13 at 08:15 AM

Select Score Fuzzy Search

84 Views

HI:

This is what documentation says:

You can request the score in the SELECT statement by using the SCORE() function. (…). If a fuzzy search of multiple columns is used in a SELECT statement, the score is returned as an average of the scores of all columns used.

Sounds cool, but:

When I perform select with SCORE() >= 0,3 I get score 0,97

When I perform select with SCORE() >= 0,98 I get score 1,00

Why? How it works?

Thank You