Fuzziness not working as expected

I have a query where I search for a string in a field of a document that should be a book or a film. The word must be present in one of the properties of a nested object called 'translations' or in another nested objecte called translations of a nested object called myproperty. It should be published in a certain range of dates. Moreover, it must match the locale 'en'.

With fuzziness auto I have strange results. If I look for "leade" I get 3 results. All of them get the word "leader". However, if I look for "leader" I get 5 results because now I get the word "leaders" too.

How is it possible? Is Elastic looking only for the next letter after the string I search? Is there a way to tell him to show "leader", "leaders" or even "leadership" if I search for "leade"?

I'm kind of new to more complicated Elastic queries and maybe I misunderstood something. Thanks :wink:

{ "query": { "filtered": { "query": { "bool": { "should": [ { "match": { "_type": "books" } }, { "match": { "_type": "films" } } ], "minimum_should_match": 1, "must": [ { "range": { "publishAt": { "gte": "2011-01-01T00:00:00+00:00", "lte": "2011-12-31T23:59:59+00:00" } } } ] } }, "filter": { "bool": { "should": [ { "nested": { "path": "translations", "query": { "bool": { "must": [ { "match": { "translations.locale": "en" } }, { "multi_match": { "query": "leader", "fields": [ "translations.*" ], "fuzziness": "AUTO" } } ] } }, "inner_hits": { "highlight": { "fields": { "translations.*": {} } } } } } ], { "nested": { "path": "myproperty.translations", "query": { "bool": { "must": [ { "match": { "myproperty.translations.locale": "en" } }, { "multi_match": { "query": "leader", "fields": [ "myproperty.translations.*" ] } } ] } }, "inner_hits": { "highlight": { "fields": { "myproperty.translations.*": {} } } } } } } } } }, "aggs": { "content_type": { "terms": { "field": "_type" } } } }

I just realised I was using the wrong feature. I need wildcard to achieve this result. I was able to make it work. However, wildcard and fuzziness doesn't work together. Is there a solution to have both in the same query?