I have searched for a word on my site.
I know the word exists in several places (as normal text in a text module, in a link, and as a header).

This word does not appear within the search results - yet apart from this - to my knowledge the search is working ok for other words.

Is there a way I can check a dnn page/module to see if it is listing its content in the search area?

thanks,

so if I was searching for the word mypension and my database was called GORDON, 
the sql script would look like this..?

 Select * from GORDON.SearchItem where SearchItemID in (
  select SearchItemID from  GORDON.SearchItemWord where SearchWordsID in (
    select SearchWordsID from GORDON.SearchWord where Word = 'mypension'
    )
)
Execute Run as Script
 

- I did the above and got this:

The Query completed successfully!

I'm not sure what is supposed to happen next?
 

Just run the Below Script and Unchecked the Run as Script checkbox it will display the result.

Select * from SearchItem where SearchItemID in (
  select SearchItemID from  SearchItemWord where SearchWordsID in (
    select SearchWordsID from SearchWord where Word = 'mypension'
    )
)