How to create a table search engine based on a question?

Hi Dom,

After I read this an idea jumped into my head so I figured I’d give it a shot. There’s a some complexity to it, but overall it’s not too bad.

The idea is to score the search results based on the number of words in common with the search phrase. To do that, we split all text at the spaces, then replace a few things like punctuation, then we have two lists we can compare. We can also use Lower() to make sure that results are not case sensitive.

Check it out and give the accuracy slider a try to see how you can limit search to only very accurate results!

3 Likes