How is the criteria set in the Data Assist Search wizard?
Try setting comparison to includes and the Filter type to Keyword, set the OR separator to be a space " ", and set the AND separator t be a comma+space ", "
this way the search term "Forest Lake" becomes:
WHERE column LIKE "%Forest%" OR column LIKE "%Lake%"
or if you search for "Forest, Lake" it becomes:
WHERE column LIKE "%Forest%" AND column LIKE "%Lake%"