When you do a general search for anything (word or phrase), all the metadata in your files is looked at. The word "and" could be in 1 or more categories, such as the artist tag, album tag, title tag or some other tag. As you see, a short word could be contained in a larger word. Also, depending on the view you're using to search in, the results returned may or may not show the metadata tag that the word (or larger word) was found in.
You can use the Query Language features to make a custom search query to filter stuff in or out of the search. This is easier said than done. The documentation for the Query Language can be found in the dialog used to edit a Local Library smart view. Select 1 of these views (on the left-hand side of the ML window) and press the "F2" function key, then look near the bottom right-hand side of the edit dialog window that appears for the "Query Help..." button.
After closing the Query Language documentation window, be sure to cancel the smart view edit window to keep from making any accidental changes to the view.
