sql server - using REPLACE in WHERE clause to check spelling permutations - MS SQL - Stack Overflow

@Stephanie: Not really. As @Philip Kelley pointed in his answer, the 2008 REPLACE() version has some enhanced capability for searching (a small subset of Regular expression). But using any of the proposed solutions (extra precomputed field, indexed view)

stackoverflow.com