Wildcard search

Curious as to how folks have solved wildcard search when searching within data tables/lists.

Often, there may be keywords that have slight spelling variations that are not captured by the exact match of existing searches.

As an example, searching the following in a data table will yield different results:

  • Spider Man
  • Spider-Man
  • Spiderman

One idea I’m exploring is having a hidden field on the table that either (1) removes special characters of common search terms or (2) includes explicit spelling variations.