The additional clauses between the brackets are trying to ignore partial matches. e.g. if you were searching for customer then it wouldn't return customerid. In most cases you...

This script didn't work if a tab was used before the tablename. I modified the like clause like this and it seemed to pick them up

ON c.Text LIKE '%[...