I'm trying to group the popularity of various topics and categories on my website by looking at what my users are searching for. Working with a spreadsheet has proven extremely difficult. For example, users may search for:
- build house
- how to build a house
- home building
- build hous (misspelling)
and so on.
This is actually a two-part question:
- Can you point me to any methods, algorithms, etc. that will help in grouping search phrases together?
- Is there any free or inexpensive data visualization software that I can use to draw conclusions from the data? Preferably, I'd like to find something that can also be used by non-programmer types (so let's count R out)...