优化以通配符开头的LIKE表达式

I have a table in a SQL Server database with an address field (ex. 1 Farnham Road, Guildford, Surrey, GU2XFF) which I want to search with a wildcard before and after the search string.I have a table in a SQL Server database with an