Today I stuck a CD in my G5 to get some fonts off it - Dingbats and Webdings. These fonts were cunningly hidden deep inside the folder hierarchy of the disc, so I thought the easiest way to get them would be to make use of a little Spotlight from the Finder.
I opened up the CD and entered 'dings' into the search field at the top right, but Spotlight only found Dingbats. Strange, I thought, I know Webdings is also on there. I entered a new search string: 'web', and lo and behold Spotlight digs up Webdings! Curious, I initiated a Cmd-F search on the CD using 'name contains' and search string 'dings' and it returned both Webdings and Dingbats.
So, it seems that searches from the Finder search field only turn up words that begin with your search string (borked behaviour), rather than any items containing the search string (expected/previous behaviour).
This is something of a pain because it means in order to get the expected results from a search I need to execute one extra keystroke and seven extra mouse clicks!
I have submitted this as a bug to Apple, hopefully they'll be able to fix it up real good, just wanted to warn you not to trust Finder searches anymore, at least, not like in the old days (10.3).