Some fields (such as weapon type) require an exact match (magical-wand rather than wand) for instance. Alternatively, you may use % as a wildcard in all searches; for instance, search for %wand%. This may be a good idea if you're having problems and not sure why.
Spell on item currently searches pills, potions, wands, and staves. Requires searches the name of the requirement (such as a requirement on the vitality attribute) rather than the required value (such as 4). Area accepts none as a keyword for uncategorised items.