Detecting duplicate tags
I have a site which allows users to openly tag their items before submitting, similar to what delicious.com does:

> ...users can tag each of their bookmarks
> with freely chosen index terms...

I want to detect spelling mistakes and tags that are similar, or may belong to the same group. 

For example, if someone tags something as Arsenal Football Club, this is the same as Arsenal FC, Arsenal, the Gooners, and/or the Gunners. I want to see which tag is used the most and then change it to that/ or create a group that encompasses all these tags, something like just Arsenal FC.

I have thouht about using the http://www.freebase.com/ API, or http://www.elasticsearch.org/ but these seem like overkill. I also know of something called [http://en.wikipedia.org/wiki/Collective_intelligence][1]. 

Oh, and I'm using PHP and MySQL.

My table structure is as follows:

    Item, Item_Tags, Tag

Basically being the lazy programmer that I am, has someone already done something like this, that I can <strike>just copy</strike> modify for my code?

What are your suggestions SO?


  [1]: http://collective%20intelligence
Detecting duplicate tags
===

I have a site which allows users to openly tag their items before submitting, similar to what delicious.com does:

> ...users can tag each of their bookmarks
> with freely chosen index terms...

I want to detect spelling mistakes and tags that are similar, or may belong to the same group. 

For example, if someone tags something as Arsenal Football Club, this is the same as Arsenal FC, Arsenal, the Gooners, and/or the Gunners. I want to see which tag is used the most and then change it to that/ or create a group that encompasses all these tags, something like just Arsenal FC.

I have thouht about using the http://www.freebase.com/ API, or http://www.elasticsearch.org/ but these seem like overkill. I also know of something called [http://en.wikipedia.org/wiki/Collective_intelligence][1]. 

Oh, and I'm using PHP and MySQL.

My table structure is as follows:

    Item, Item_Tags, Tag

Basically being the lazy programmer that I am, has someone already done something like this, that I can <strike>just copy</strike> modify for my code?

What are your suggestions SO?


  [1]: http://collective%20intelligence