I couldn’t find a solution for this, and the only article that referenced this was from 2 years ago and said it’s not possible. After messing around with this, I figured out a solution. I was searching for an Account by the (partial) name. In the WHERE field, put:
Name LIKE '%yoursearchstring%'
“yoursearchstring” can be a field pulled from another action. Note that the single quotes and the percent signs are required for this to work.