• Sorry for the late response guys

    Yes I have repeated the execution of the query more than 10+ times with the same % on the new database server.

    in terms of the migration to the new server, yes it was a simple backup and restore, I have rebuilt the index several times and also rebuilt the full text index's not that they come into the picture here... Just not getting anywhere with this.