replace doesn't search for the entire word before replacing

I have a code below that matches each individual word in the title in column A with words in sheet 2 column E and then replacing those words with the words in column F array. However I have encountered a difficultly, when there are similar words, the matching works by matching the shorter word instead of the full longer word. For example the array contains Small:SM and Smaller:SM however my title of A smaller cow will be replaced to A SMer cow. How do I get the code to match the entire word smaller instead of just small?




Please find attached a sample file with the code.

Replace (in your code)

Please Login or Register  to view this content.

By

Please Login or Register  to view this content.

Reordering the replacement table does help. However, if i wanna replace - with a space it doesn't work . Do I have to edit the code?