The SQL LIKE condition is pretty basic: it doesn't support regular expressions without managed code (which is it's own can of worms).
All you get are character ('[' followed by a character list then ']'), not a character ('[^' followed by a character list then ']'), match any character ('_') and match any number of characters ('%')
You want to match optional double spaces and so forth, you need to either invest time in learning
SQL managed code[
^], change how you store data, or do the work in your presentation language instead of SQL.