Human names searching - how to improve results

Elastic Stack Elasticsearch
7

Hi @dadoonet,

We are trying to optimize our search in human names, but we cannot figure out what exact settings we should apply to accomplish that.

Let me give you another example to make it clearer. Here is the insert query :

POST /watchlistentries/_bulk
{ "index" : { } }
{ "name": { "fullName": "Sylvester Stallone" } }
{ "index" : { } }
{ "name": { "fullName": "Sylvester Enzio Stallone"} }
{ "index" : { } }
{ "name": { "fullName": "Stallone Sylvester"} }
{ "index" : { } }
{ "name": { "fullName": "Sylvester Stallone Enzio"} }
{ "index" : { } }
{ "name": { "fullName": "Stallone Sylvester Enzio"} }
{ "index" : { } }
{ "name": { "fullName": "Sylvester Enzio" } }
{ "index" : { } }
{ "name": { "fullName": "Sylvester John Stallone" } }
{ "index" : { } }
{ "name": { "fullName": "Sylvester Stallone John" } }
{ "index" : { } }
{ "name": { "fullName": "John Sylvester Stallone"} }
{ "index" : { } }
{ "name": { "fullName": "Stallone Sylvester John" } }

And then the search query:

POST /watchlistentries/_search?typed_keys=true
{ "query": { "match": { "name.fullName": { "analyzer": "standard", "auto_generate_synonyms_phrase_query": true, "fuzziness": 3.0, "fuzzy_transpositions": true, "max_expansions": 100, "minimum_should_match": "2<75%", "operator": "or", "query": "Sylvester Stallone", "_name": "SearchQuery" } } }, "size": 100 }

We made a basic console .Net application for listing the results, they are the same as the results you will receive in Kibana :

Capture34
Capture34975×339 7.13 KB

As you can see the "_score" is the same regardless the place of the matching phrase. We thought that the score is showing how relative the matching is.

For example if we search for "Sylvester Stallone" we expect "Sylvester Stallone Enzio" to have better score than "Stallone Sylvester John". And then we want to be able to filter the results for score greater than some number.

So here are our questions :

  1. Is there a way we could achieve that without using any additional paid plugins for human names search (changing the search settings for example) ?

  2. If the answer of 1) is "No", could you recommend any cheaper plugin we could use?

  3. If the answer of 1) is "Yes", could you recommend some settings or special queries, which are working good with human names?

  4. The trial version does not permit using plugins. How could we try if any works for us.

Thanks!

Best Regards!