You could probably use full text indexing to make this work. Otherwise you’ll need to specify every column that you want to match to.
No matter what technique you use, this won’t be a very efficient query to run.
REGISTER or login:
where Field2 like '%'+Field1+'%' OR Field1 like '%'+Field2+'%'