SQL - Query to find if a string contains part of the value in Column

I am trying to write a Query to find if a string contains part of the value in Column (Not to confuse with the query to find if a column contains part of a string). Say for example I have a column in a table with values ABC,XYZ. If I give search string ABCDEFG then I want the row with ABC to be displayed. If my search string is XYZDSDS then the row with value XYZ should be displayed