Search bar algorithm not perfect

Hi Community.

The Search Bar algorithm in the list block is not perfect. It will find patterns of multiple strings if they are coming in perfectly “as is” from the selected Airtable columns. However, it won’t find partial strings (chopped by words), strings mixed in sequence, strings with commas in between, or added words in between (like “in” or “at”) etc…

Let’s say I have an Airtable of people (person’s name, business name, address)
Typical use cases:
Find me a person’s name at business name
Find me a person’s name, business name
Find me a business name, person’s name
Find me a person’s name, address
Find me a business name, address
Find me a person’s name at address
Find me a business name at address
Find me … etc, etc, etc…

It just won’t do that.

In other words, this isn’t your Google search :slight_smile:
Ideally, Softr should update their search algorithm. Short of that, I’ve decided to create common permutations of search patterns as formula columns in Airtable with CONCATENATE() function, and add all of those columns in the Softr list block search bar’s “search by” field.

I’ve got about 100 or so search pattern permutations. So, 100 fields.
Question: how many Airtable fields can I add to the list block search bar’s “search by” field before it starts crippling performance? How well does it scale?

Thank you
Boris