How many ways to spell 'Guns N Roses'?
Over at last.fm, they are making a big push to clean up the
world of music metadata. A substantial fraction of the ID3 tags
embedded in MP3 files are missing, inconsistent, or flat-out
wrong. last.fm has released a fingerprinter that they can use to
resolve any track to a unique ID based upon the audio content of the
track. RJ, one of the founders of last.fm, indicates
that in the end they may actually be able to find out how many ways
there are to spell "Guns N’ Roses – Knockin’ on Heaven’s Door".
Just to give you an idea of how much fun this can be, here are the top
12 ways to misspell 'Guns N' Roses', according to MusicBrainz.
Update: Check out the comments section, RJ has posted over 400 variants of GNR collected by the lastfm fingerprinter so far.
| Guns N Roses |
| Guns and Roses |
| guns 'n' roses |
| Guns 'N Roses |
| Guns & Roses |
| Guns'N'Roses |
| Guns N'Roses |
| Guns'N Roses |
| Guns´n Roses |
| Guns N´ Roses |
| Guns -N- Roses |
| GNR |
Guns N' Roses is pretty easy compared to Tchaikovsky. MusicBrainz shows 86 aliases for the russian composer:
| Tchaikovsky |
| Peter Ilyich Tchaikovsky |
| Peter Tchaikovsky |
| Tschaikowsky |
| Peter Tschaikowsky |
| Piotr Ilyich Tchaikovsky |
| Piotr Tchaikovsky |
| Peter Iljitsch Tschaikowsky |
| Tchaikovsky, Peter Ilyich |
| Peter Ilyitch Tchaikovsky |
| Pjotr Ilyich Tchaikovsky |
| Peter I. Tschaikowsky |
| Pyotr Tchaikovsky |
| P. I. Tchaikovsky |
| Peter Ilich Tchaikovsky |
| Tsjaikovski |
| Tchaikovsky, P.I. |
| Tchaikovsky, Pyotr Ilyich |
| Piotr Ilyitch Tchaikovsky |
| Tjajkovskij |
| Tsjajkovskij |
| Peter Ilyich Tchaikovski |
| Peter I. Tchaikovsky |
| Tchaikowsky |
| Tchaikovsky, Peter I. |
| Peter Ilyich Tschaikowsky |
| Pyotr Il'Yich Tchaikovsky |
| Peter Iljitsch Tschaikowski |
| Tchiakovsky, Pyotr Ilich (1840-1893) |
| Tchaikovsky, Peter Ilyich (1840-93) |
| Tchaikovsky, Peter Ilyitch |
| Tsaikovski |
| Pyotr Ilyitch Tchaikovsky |
| Pytor Ilyich Tchaikovsky |
| Pyotr Ilyich Tchaikovsky |
| Piotr Ilitch Tchaïkovski |
| Chaikovsky, P. I. |
| Pyotr Ilyich Tchaikovsly |
| Peter Ilyich Tchaikovshy |
| Tchaikovsky, Piotr Ilich (1840-1893) |
| Pjotr Iljitsch Tschaikowsky |
| Ciaikosvsky |
| Tchaikovsky 1841-1893 |
| Pyotr Illyich Tchaikovsky |
| Tchaïkovki |
| Piotr Ilych Chaikovsky |
| Piotr Ilic Ciaikovsky |
| Pjotr Iljitsj Tsjaikovski |
| Pyotor Ilyich Tschaikovsky |
| Peter Iljitsj Tsjaikovski |
| P. I. Tchaikovskij |
| Piotr Ilich Tchaikovsky |
| Peter Iljitsch Tchaikovsky |
| Tchaikovisky |
| Tchaikovsy |
| Tchailovisky |
| Tchaikovskyes |
| Tchaikovskys |
| Tchaikoskvy |
| Piotr Il'yich Tchaikovsky |
| Tchaikowski |
| Piotr Illitch Tchaïkovsky |
| Tchaikovsky, Pjotr Ilyich (1840 - 1893) |
| Tchaikovsky, Peter Il'yich |
| Piotr Iljič Čajkovskij |
| Петр Ильич Чайковский |
| Tchaikivsky |
| Tchaikovsky, PI |
| Чайковский, Пётр Ильич |
| Pyotor Tchaikovsky |
| Чайковский, Петр Ильич |
| Tchaikovsky - Philharmonic Orchestra |
| Pytor Tchaikovsky |
| Pyotr II'yich Tchaikovsky |
| Piotr Ilyich Tchaikowsky |
| Peter Ilych Tschaikowsky |
| Peter Llyich Tchaikovsky |
| Peter Tschaikovsky |
| Peter Illyich Tchaiskovsky |
| Peter Iljitsch Tschaikowsky (1840 - 1893) |
| Tchaikovsky, Pyotr |
| Tsjaikovsky |
| Èajkovskij |
| Peter Tjajkovskij |
| P. Czajkowski |
| P. Tchaikovsky |
| Tchaikovsky Petr |
| Pyotor Ilitsch Tchaikovsky |
| Pytor Il'Yich Tchaikovsky |
| Peter Ilych Tchaikovsk |
|
Here you go Paul, 413 so far :)
"Guns N' Roses"
(coolrunner.de) guns n roses
(Guns N' Roses)
*Guns and Roses
001 Guns N' Roses
0010. [1992] Guns N' Roses
002 Guns n' Roses
005 Guns 'n roses
006 - Guns N' Roses
006 Guns N' Roses
01 Guns and Roses
01 Guns n roses
01 Guns N' Roses
011 Guns&Roses
02 GUNS 'N ROSES
02 Guns n roses
02 Guns n' Roses
02. Guns ´n Roses
02.guns n roses
021 Guns and Roses
021 Guns 'n Roses
023 Guns n roses
027 Guns'n Roses
03 Guns N' Roses
037 Guns N' Roses
04 Guns n Roses
04 Guns n roses
04 Guns N' Roses
04 guns n'roses
04. Guns ´n Roses
042 Guns'n Roses
05 guns and roses
05 Guns n roses
05 Guns N' Roses
05. Guns ´n Roses
050 Guns N' Roses
051 Guns'n Roses
051- Guns N' Roses
056. Guns n%27 Roses
056. Guns n' Roses
06 Guns n roses
06 Guns N' Roses
06.guns n' roses
065 guns n roses studio demos(88
07 Guns n roses
07 Guns N' Roses
07 Guns n'Roses
075 guns n roses studio demos(88
07Guns'N'Roses Use Your Illusion II
08 Guns N Roses
08 Guns N' Roses
08.guns n' roses
086 Guns 'n' Roses
09 Guns N' Roses
09.guns n' roses
10 Guns n roses
10 Guns N' Roses
11 Guns n roses
11 Guns N' Roses
118 GUNS 'N ROSES
12 Guns N' Roses
12.guns n roses
13 Guns N' Roses
13.guns n' roses
14 - Guns n' Roses
14 Guns n Roses
14 Guns N' Roses
14.guns n' roses
16 Guns N' Roses
175 Guns 'n Roses
234 Guns 'n' Roses
345 Guns n' roses
6. Guns N Roses
6.GUNS'N'ROSES
671 Guns 'n Roses
7. Guns N Roses
80's Guns and roses
80s soft rock-guns n roses
834 GUNS 'N ROSES
A: Guns n´ Roses
AlbumWrap - Guns n' Roses
Copy of Guns and Roses
G N' R
G'n'R
G'nR
Gans N Roses
Ginz 'N Rozes
GN'R
GNR - Live Vegas 2001
GTA San Andreas - Guns 'n' Roses
Gun & Roses
Gun 'N Roses
Gun 'n' Roses
Gun And Rose
GUN AND ROSES
Gun N 'Roses
Gun N Roses
GUN N ROSES - USE YOUR ILLUSI
Gun n' Rose
Gun n' Roses
Gun N'Roses
gun'n roses
Gun's & Roses
Gun's 'N Rose's
Gun's 'n Roses
Gun's 'N' Roses
Gun's amd Roses'
Gun's and Rose's
Gun's and Roses
Gun's N Rose's
Gun's N Roses
Gun's N' Rose's
Gun's N' Roses
Gun's Roses
Gun's'n Roses
gUN'SN'rOSES
Gund and Roses
Gund N' Roses
Gunns N Roses
guns
Guns Roses
GUNS AND ROSE
Guns n Roses
Guns N' Roses
Guns "N" Roses
Guns %27N Roses
Guns %27N%27 Roses
Guns & Roses
Guns & Roses -
Guns & Roses live Rio 2001 Mr.
Guns & Roses live Rio 2001 Sos
Guns & Roses.
Guns & Roses
Guns 'N Roses
Guns 'N' Roses
Guns &Roses
Guns ' N ' Roses
Guns ' N' Roses
Guns 'N Roses
Guns 'n 'Roses
Guns 'N f*ckin' Roses
Guns 'n Rose
Guns 'N Roses
Guns 'n Roses -
Guns 'n Roses - Appetite For Destruction
Guns 'N Runs
Guns 'N' Roses
Guns 'n' Rose
Guns 'N' Roses
Guns 'N' Roses - 01
Guns 'N' Roses - 02
Guns 'N' Roses - 03
Guns 'N' Roses - 06
Guns 'N' Roses - Best Ballads - 01
Guns 'N' Roses - Best Ballads - 04
Guns 'N' Roses - Best Ballads - 05
Guns 'N' Roses - Best Ballads - 07
Guns 'N' Roses - Best Ballads - 09
Guns 'N' Roses - Best Ballads - 10
Guns 'N' Roses - Best Rock - 01
Guns 'N' Roses - Best Rock - 02
Guns 'N' Roses - Best Rock - 03
Guns 'N' Roses - Best Rock - 04
Guns 'N' Roses - Live Era '87 '93 (1) - 04. Welcome To The Jungle (Live)
Guns 'N' Roses - Live Era '87 '93 (1) - 10. It's Alright (Live)
GUNS 'N' ROSES - USE YOUR ILLUSION I
GUNS 'N' ROSES - USE YOUR ILLUSION III
Guns 'n' Roses - [EMG]
Guns 'N' Roses0)
Guns 'n'roses
Guns 'NRoses
Guns 's Roses
Guns - N - Roses
Guns -N- Roses
Guns . N . Roses
Guns and roses
Guns and N' Roses
Guns and Rose's
Guns and Roses
Guns and Roses -
Guns And Roses - Greatest Hits
Guns And Roses - Slash
Guns and Roses E:
Guns and roses feat. Slash
Guns andamp; Roses Roses
Guns andapos;N Roses
Guns andRoses
Guns ans Roses
Guns In Roses
Guns N And Roses
Guns n Roses
Guns N 'Roses
Guns N Rose
Guns N Rose's
Guns N Roses
Guns N Roses (Duff)
Guns N Roses (Greatest Hits)
Guns n roses (live in rio III)
Guns N Roses -
Guns N Roses - 02
Guns N Roses - 04
Guns N Roses - 09
Guns N Roses - Oh My God
Guns N Roses - Slash
Guns N Roses - Use Your Illusion II
Guns N Roses Guns N' Roses
Guns N Roses s;N Roses
guns n roses studio demos(88
Guns N Roses Unplugged
Guns N Roses {Appetite for DestructionAnything Goes
Guns N Roses {Appetite for DestructionIt's So Easy
Guns N Roses {Appetite for DestructionMr. Brownstone
Guns N Roses {Appetite for DestructionMy Michelle
Guns N Roses {Appetite for DestructionNightrain
Guns N Roses {Appetite for DestructionOut Ta Get Me
Guns N Roses {Appetite for DestructionParadise City
Guns N Roses {Appetite for DestructionRocket Queen
Guns N Roses {Appetite for DestructionSweet Child O' Mine
Guns N Roses {Appetite for DestructionThink About You
Guns N Roses {Appetite for DestructionWelcome to the Jungle
Guns N Roses {Appetite for DestructionYour're Crazy
Guns N Roses {Appetite for Destruction} 08
Guns N Roses {Appetite for Destruction} 12
Guns N Roses++++++++++++++++++++++++++++++
Guns N Roses-
Guns n Roses10
Guns n Roses12
Guns n Roses2
Guns n Roses4
Guns n Roses5
Guns n Roses6
Guns n Roses8
Guns N Rosess
Guns N Roses_
Guns N Roses_November Rain
Guns N Roses_Sweet Child O` Mine (Killer Techno Remix)
Guns N%27 Roses
Guns n%27Roses
Guns N%r0Roses
Guns n' Roses
Guns N' Roses
Guns N' Roses
Guns N'roses
Guns N' Roses
Guns N' And Roses
Guns N' Fucking Roses
Guns n' Rose
Guns N' Roses (Appetite For Destruction)
Guns N' Roses (Bootlegs/Unoffi
Guns N' Roses (Bootlegs/Unofficial)
Guns N' Roses (Bootlegs/Unreleased)
Guns N' Roses (Chinese Democracy)
Guns N' Roses (from "USE YOUR ILLUSION I [91]")
Guns N' Roses (live Era)
Guns N' Roses (Slash)
Guns N' Roses (The Spaghetti Incident 08)
Guns N' Roses -
Guns N' Roses - (Appetite For Destruction) - 06
Guns N' Roses - (Appetite For Destruction) - 09
Guns N' Roses - (Use Your Illusion I) - 04
Guns N' Roses - (Use Your Illusion I) - 10
Guns N' Roses - (Use Your Illusion I) - 13
Guns N' Roses - (Use Your Illusion I) - 15
Guns N' Roses - AFD - 02
Guns N' Roses - AFD - 03
Guns N' Roses - AFD - 04
Guns N' Roses - AFD - 07
Guns N' Roses - AFD - 12
GUNS N' ROSES - AFD 01
Guns N' Roses - Appetite For Destruction
Guns N' Roses - Best Ballads - 01
Guns N' Roses - Best Ballads - 02
Guns N' Roses - Best Ballads - 03
Guns N' Roses - Best Ballads - 04
Guns N' Roses - Best Of Guns N Roses
Guns n' Roses - Buenos Aires - 1992
Guns N' Roses - G'N'R Lies
Guns N' Roses - Greatest Hits
Guns N' Roses - Greatest Hits - 01
Guns N' Roses - Greatest Hits - 02
Guns N' Roses - Greatest Hits - 04
Guns N' Roses - Greatest Hits 2004
Guns N' Roses - Helsinki 14.08.1991
Guns N' Roses - Live & Let Die
Guns N' Roses - Live Era
Guns N' Roses - Live Era '87-'93
Guns N' Roses - Make My Day Rare Tracks
Guns n' Roses - Rio De Janeiro - 2001
Guns N' Roses - Slash
Guns N' Roses - Spaghetti Incident?
Guns N' Roses - The Spaghetti Incident?
Guns N' Roses - Use Your Illusion I
Guns N' Roses - Use Your Illusion II
Guns N' Roses - Use your Illusions I 13
Guns N' Roses -01
Guns N' Roses -04
Guns N' Roses -05
Guns N' Roses -13
Guns N' Roses Chinese Democracy
Guns N' Roses live
Guns N' Roses [04]
Guns N' Roses [13]
Guns N' Roses [16]
Guns N' Roses [Axl Rose]
Guns N' Roses [Slash]
Guns N' Roses [Tacoma 11.8.02]
Guns N' Roses [Use Your Illusion 1] 05
Guns N' Roses {Appetite For Destruction} 05
Guns N' Roses {G N' R Lies} 04
Guns N' Roses(-1)
Guns N' Roses(0)
Guns N' Roses(2)
Guns N' Roses-
Guns N' Rosesdtrack
Guns N' Rosess
Guns N' Rosests
Guns N' Roses`
Guns N'' Roses
Guns N'Roses
Guns N'roses - 03
Guns N'Rosses
guns n* roses
Guns N; Roses
Guns nAnd Roses
Guns Nandapos; Roses
Guns Nroses
Guns Nroses -[EMB]-
Guns N_ Roses
Guns N` Roses
Guns n`Roses
GUNS N`ROSES-½Ì±Û
Guns N´ Roses
Guns N´ Roses - TSI
Guns N´Roses
Guns n´ roses
Guns NÿRoses
Guns n’ Roses
Guns `n Roses
Guns `N Roses
Guns `N' Roses
Guns `NRoses
Guns `n` Roses
Guns ´n Roses
Guns ´N` Roses
Guns ´n´ roses
Guns ´n´Roses
Guns ‘N’ Roses
Guns ’n Roses
Guns%20N'%20Roses
Guns%26Roses
Guns%27n Roses
Guns'N'Roses
Guns&Roses
Guns' n Roses
Guns' N' Roses
Guns' N'Roses
Guns'N and roses
Guns'n Roses
Guns'n Roses - Use Your Illusion II
Guns'N' Roses
Guns'n'Rose
Guns'N'Roses
Guns'N'Rosses
guns'nroses
guns-and-roses
Guns-n-Roses
Guns-n-Roses - Tantrum 1997
GUNSANDROSE
GunsandRoses
Gunsd and Roses
Gunsn Roses
GunsN' Roses
gunsn'roses
GunsnRoses
Guns_and_Roses
Guns_and_Roses_
Guns_N'_Roses
guns_n'_roses-so_fine
Guns_N'_Roses_
Guns_N_Roses
Guns_n_RosesCDLIVE
Guns_N´_Roses
Guns`n Roses
Guns`n Roses - [Apetite for Destruction]
Guns`N`Roses
Guns´n Roses
Guns´n`roses
Guns´n´ Roses
Guns´n´Roses
Guns��n Roses
Gunz N Roses
Gunz n' Roses
Gun`s N Roses
Gun´s & Roses
Gun´s & Rose´s
Gun´s and Roses
Gun´s and Rose´s
Gus and Roses
Gusn and Roses
G`n`R
Misfits Cover Guns N' Roses
Rock-Guns 'n Roses
T-5377462-Guns And Roses
T-8568581-Guns N' Roses
The Best Of Guns & Roses Live
Use Your Illusion II
ZZ - Guns N' Roses
[eMyz.ru]Guns N Roses
[Guns 'n Roses]
[Guns 'n' Roses]
[Guns and Roses
[Guns N Roses]
[Guns N' Roses]
Posted by RJ on September 11, 2007 at 08:33 AM EDT #
This kind of duplication and inconsistency is exactly why AMG does everything in-house. It is laborious and time consuming (and expensive) to have human beings entering and linking all of this stuff, but in the end we have one Guns N' Roses linked to a single performer ID [P 4416] which makes for a much cleaner and manageable data set.
</cheerleader>
Posted by Zac on September 11, 2007 at 12:09 PM EDT #
I think you're missing the point, Zac.
Suppose, for example, that you want to compile statistics by sampling what folks play in an application like Winamp--perhaps using that data to divvy up royalties for artists or composers. In that case, you're not so much interested in what is the "correct" way to spell an artist's name (assuming the artist can stick to one spelling in the first place!) as in all the ways that users of Winamp can misspell the artist's name. In that case, a handcrafted, "correct" spelling of the artist's name as determined by an editor is completely beside the point!
For that matter, suppose we want Winamp to link to the appropriate artist's page at AMG automagically while playing their songs. If you only match a handful of acceptable variants as determined by human editors, you'll miss lots and lots of chances to drive traffic to AMG's site...
Posted by Rob Szarka on September 16, 2007 at 04:34 PM EDT #
I agree wholeheartedly. As an amateur meddler in web APIs and trying to find and aggregate music myself, the non-standardization of tag data out there is infuriating.
In the end though, you want all of these different "interpretations" to funnel down to a single reference point (as opposed to having 120 different Guns 'N' Roses pages/entries/destinations.
Some kind of a one-to-many mapping of all possible G'n'Rs to a single unique entity would be very valuable. Fuzzy text matching can only get you so far.
Posted by Zac on September 18, 2007 at 03:28 PM EDT #
me gustaria ke algun dia me contestaran
Posted by adriana mirella ruiz perez on October 15, 2007 at 08:16 PM EDT #