I was hoping to find out how to show the Page Name vs. the Module Title in the Search Results. I have a very large site and some Modules did not get titled. Therefore some of my search results look like

Text/HTML
The Endow Partnership, a program of Endow San Diego, was developed to support and encourage nonprof...
http://www.sdfoundation.org/CivicLead... - 6/26/2010 8:29:35 PM

When I want them to look like

Endow Partnership Program
The Endow Partnership, a program of Endow San Diego, was developed to support and encourage nonprof...
http://www.sdfoundation.org/CivicLead... - 6/26/2010 8:29:35 PM

I can not go through the entire site and name all my modules as it is too big. I was able to remove the Relevance code from SearchResults.aspx and I think I see the area where I should replace module title with page title but I need assistance on the exact code to find and replace. Thank you in advance for any advice.

If you want more control, you either need DNN professional or you could try Avatar Search Boost (not free).
The core search in CE is quite limited, there are not a lot of settings to control it's behaviour.

---

I'm a bit blown away by the response to this question. I was trying to use the search results feature until I also realized, what I consider, a bad idea of using the module title instead of the page title on results. However, I then noticed that if you have two HTML Modules on a page, it returns that page twice! This seemed like a bad idea, as well. Kind of ruined the point of the relevancy, I would think.

Anyway, while looking into it, I found this view in the database: vw_SearchItems

This view seems to be part of what DNN uses to feed their search results. I didn't go into too much depth in figuring out the ins and outs of this view or what it gets its data (it seems a lot of it has to do with some kind of stored procedures). 

At first, I thought about altering the view to just pull in a Tab-Name, but I'm not sure if updating DNN would overwrite my change. So, I decided to just make my own custom module for search results using their Search Items table. I'm not sure if this is an amazing idea or not, but it seems to be working for now. 

This query should work just find if you have SQL 2008;

SELECT     TabName, TabID, TabPath,
Text = Stuff((SELECT '' + [Description]
FROM         vw_SearchItems WHERE vw_SearchItems.TabID = Tabs.TabID FOR XML PATH('')),1,0,'') 
FROM         Tabs WHERE (Stuff((SELECT '' + [Description]
FROM         vw_SearchItems WHERE vw_SearchItems.TabID = Tabs.TabID FOR XML PATH('')),1,0,'')) IS not null
AND IsDeleted = 0 AND IsVisible = 1 AND IsSecure = 0 AND EndDate >= GETDATE() AND StartDate <= GETDATE()
AND PortalID = 0

PortalID can, of course, be changed. Also, this was done with DNN7.

If anyone has any other input on this query or another way to approach this, I'd love to hear it.