We solved this problem by creating a persisted computed column that contains no punctuation and no spaces. When the user types something to search for, we also strip that of punctuation and spaces and then do the compare. Makes for very nice SARGable predicates.
--Jeff Moden
Change is inevitable... Change for the better is not.