Tracks with similar names

[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]

Anyone?

[nynaevelan]

The closet thing out there is the Find More from Same feature of Bex's Advanced Duplicate Find & Fix script.

[Galaxian]

Thanks I'll give it a try.

[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]

Cool thanks.