SearchBox Not Showing All Similar Values

Hi everyone,

So basically my searchbox isn’t giving me the correct list of answers when searching for something. The example of what is happening is, it’s searching for categories of products. One of the categories is ‘Coffee’ and the other is ‘Coffee Machine’. When I search ‘coffee’ only ‘coffee machine’ pops up, and when i change the sorting method from descending to ascending, it shows ‘coffee’ correctly but not ‘coffee machine’ until I add a space. The screenshots are below:

Figure 1. Normal search of categories (text) data field:

Figure 2. Search results based off settings for figure 1:

Figure 3. New search settings with descending as ‘no’ for category:

Figure 4. Search results based off figure 3. However, when I put a space after coffee here finally coffee machines shows up:

Ideally would like both coffee and coffee machines to show up. The data field for category is text and no other settings are changed between figures 1 and 3 besides the sorting of the data which is what actually makes it change between them.

If anyone knows how to make them both pop up, especially when just typing ‘coffee’ would be much great help.

Thanks,

Sarrie