A website that has more than a dozen pages can benefit by adding site search capabilities. You will notice at the top right of this site, there is a box to fill in any text and a search button to look within the site for the text you filled in.
by making use of a technology called "Full Text Indexing" in a SQL Server database.