You can use asterisks to fuzz-match, i.e. use "*z*" as your filter to show any row where that column contains a "z".

Note: The third column has the filter input disabled, but actually has a filter set in code that requires every company to have an 'a' in their name.