Just suppose I have table columns like this

1 Application

2 Application's

3 Foreign Application

4 Application's effect

So, if I am running query SELECT * FROM table_name WHERE CONTAINS(*, ' "Application''s" ')

I am putting " " for exact match. Double ' ' (Single quote) after application is used for representing ' inside " ".

So result of the above query should be,

2 Application's

4 Application's effect

Please let me know if you need any other explanations