We’ve just released an update to Steam Workshop to change how the search function works. Previously, it would sort search results by the filter you had selected on the right-hand side of the page (Most Popular, Top Rated, Most Recent). This was originally done to allow you to find, say the top-rated Skyrim mod that involves “dragons”. Turns out this didn’t really meet everyone’s expectations for how Search should work.
So, now search will return results sorted by relevancy of the term you searched for. So if you search for an exact name, you should see that first. If you search for a generic term like “Dragon” you will get results that weight it based on how the term “Dragon” appears in each item (in title, in description, etc.)