SQL Query用于搜索单个列中名字和姓氏的任何变体

I have a list of 1,700 names. I need to search on those names within one column of a database and search on any variation and order of that name. For example, if the name I'm searching on is John Smith, I need to search the column for any occurrence including 'John Smith', 'Smith John', 'Smith, John' etc. I've tried many different variations on LIKE and IN, and wildcards in different spots, but am not getting the proper results.I have a list of 1,700 names. I need to search