Tracks with similar names

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Galaxian
Posts: 62
Joined: Thu Apr 05, 2007 7:29 am
Contact:

Tracks with similar names

Post by Galaxian »

Hi,

Is there a script that will find similar track names. I'm looking for inconsistencies. The tagging inconsistencies script does not appear to look at tracks in this way.

TIA
Galaxian
Posts: 62
Joined: Thu Apr 05, 2007 7:29 am
Contact:

Re: Tracks with similar names

Post by Galaxian »

Anyone?
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Tracks with similar names

Post by nynaevelan »

The closet thing out there is the Find More from Same feature of Bex's Advanced Duplicate Find & Fix script.
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
Galaxian
Posts: 62
Joined: Thu Apr 05, 2007 7:29 am
Contact:

Re: Tracks with similar names

Post by Galaxian »

Thanks I'll give it a try.
Aff
Posts: 306
Joined: Sun Oct 05, 2008 4:46 pm
Location: Switzerland
Contact:

Re: Tracks with similar names

Post by Aff »

You can create a Magic Node using the soundex function to show all tracks that have several similar sounding titles.
Here's the mask:

Code: Select all

<Group|Name:Tracks...>\Tracks with similar titles (SOUNDEX)|Filter:Songs.ID IN (SELECT ID FROM Songs WHERE SongTitle <> '' AND SOUNDEX(SongTitle) In (SELECT SOUNDEX(SongTitle) AS SoEx FROM Songs AS D GROUP BY SoEx HAVING COUNT(*)>1))\<Title>
To show only tracks that have similar sounding titles AND artists:

Code: Select all

<Group|Name:Tracks...>\Tracks with similar title and artist (SOUNDEX)|Filter:Songs.ID IN (SELECT ID FROM Songs WHERE  Songs.SongTitle <> '' AND SOUNDEX(SongTitle) || SOUNDEX(Artist) In ( SELECT SoEx || SoExA FROM ( SELECT SOUNDEX(SongTitle) AS SoEx, SOUNDEX(Artist) AS SoExA FROM Songs AS D GROUP BY SoEx, SoExA HAVING COUNT(*)>1 )))|Statistic:Count(Tracks)\<Title>
To show artists with similar sounding names:

Code: Select all

<Group|Name:Artists...>\Artists with similar names (SOUNDEX)|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs, ArtistsSongs, Artists WHERE Songs.ID = ArtistsSongs.IDSong AND ArtistsSongs.IDArtist = Artists.ID AND Artists.Artist <> '' AND SOUNDEX(Artists.Artist) IN ( SELECT SOUNDEX(Artist) AS SoEx FROM Artists AS D GROUP BY SoEx HAVING COUNT(*)>1 ))|Statistic:Count(Artist)\<Artist|Statistic:Count(Tracks)>
To get the results sorted by soundex I use SQL-Viewer, then copy the result into Excel and apply conditional formatting with a formula to clearly see groups of same soundex.
Galaxian
Posts: 62
Joined: Thu Apr 05, 2007 7:29 am
Contact:

Re: Tracks with similar names

Post by Galaxian »

Cool thanks.
Post Reply