If the match only has to occur in one column, then use ChemistB's approach.

1) Insert a blank row at the top

2) Put this formula in G2:
=IF(ISNUMBER(SEARCH("car", D2)), 1, "")

3) Copy that cell down the whole dataset

4) Use the autofilter as described