OK --- here is where the actual change is:
AND (sw.Word like '%' + @Word + '%')
AND (t.IsDeleted = 0)
AND (t.DisableLink = 0)
AND (m.IsDeleted = 0)
AND (t.PortalID = @PortalID)
OR (m.ModuleTitle like '%' + @Word + '%')
-----------
The bolded lines are the changes
first line is how the search term is matched. instead of exact, it does a like. we found that a lot of clients would complain that searching "map", for instance, would not return pages which had the word "maps" on them. or "auto" won't give you "automobile"
second is the disablelink line, we had the problem of hidden pages showing up in results but realised sometmes we WANT hidden pages to show up, but sometimes we hide pages cos they're not ready to be published. so i decided that if i "disable" the page then i definitely don't want it to come up in the results, but I might want to keep it for later (we aren't much for deleting pages around here)
third is the OR m.ModuleTitle like '%' + @Word + '%' part --- now this is kind of a subjective one. i have a web site right now for a client that sells insurance. home insurance, life insurance, and car insurance. when i searched "car" i didn't get the car insurance page at all, even though the page was titled car insurance and the module was titled car insurance.... the content copy used the word "automobile" because this particular client is very traditional and was picky about that wording. so i added the "OR" line because if we put the search term in the title, it's most likely relevant. we know module titles are what show up as the links on the SRP and so we make sure those titles are always relevant and helpful for the user.
BUT -- we would like to see page name or page title as an option in the settings for how the text displays. we couldn't figure out how to modify the core to do that.
ok that is all i hope this has been informational