Faster search help needed backward elimination proccess

[Ohad1997]

I have a dynamic search function in my excel sheet that returns only the strings containing the value im searching, but it fails to one major thing, i have 980 options to search, if i type: "ab" and be left with 40 options it will still search all 980 of the possible options when i type "abc" making calculation much slower when i type a fast sequence of letters(for example, if i type "banana chocolate" it will search 980 options 16 types) how can i tackle this problem?

 

[Aladin Akyurek]

Care to post a small sample along with your working formula?

 

[Rick Rothstein]

I have a dynamic search function in my excel sheet that returns only the strings containing the value im searching...

Can you show us the function?

 

[Ohad1997]

Can you show us the function?

Sadly im not next to the computer but basically
https://youtu.be/tCahRfEGj1g