I see requests for this in the SharePoint forums a lot and I always figured it was pretty easy to do with a few lines of code. Sometimes users want to display a list of documents that the worked on throughout the farm. The CoreResultsWebPart...
SharePoint 2010 Enterprise Search has great wildcard search support built in now. However, it requires the use to add an asterisk to their query every time they want a wildcard search. This is a great step compared to what we had in MOSS 2007...