In a similar vein to modifying the product search to search for SKU as well as name the other place where this is useful is in the related/upsell/required products helper in th e product admin pop up.
This is run from an xml package and is a quick fix. In your admin/xmlpackages directory find the ajax.CSVHelper.xml.config file. At the top of the file change the products search sql to the following:
It Works For Me. I also edited it to return more than 5 products (but not in the above code) so i can keep a wide search.
declare @searchlength int
set @searchlength = len(@SearchTerm)
select top 5 ProductID as ID, Name, Deleted, Published, 0 as InList
(@searchlength > 2 and (@SearchTerm != '' and (name like '%' + @SearchTerm + '%') or (sku like '%' + @SearchTerm + '%') and deleted = 0 and published = 1))
and not(@CSVList like '%,'+convert(nvarchar(10),ProductID)+',%')
order by name
Instant productivity boost!