Databases
StackOverflow2013
Postsdbo
POHow to implement a SIMPLE "You typed ACB, did you mean ABC?"
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to implement a SIMPLE "You typed ACB, did you mean ABC?"
    primarykey
    data
    text
    <p><em>I know this is not a straight up question, so if you need me to provide more information about the scope of it, let me know. There are a bunch of questions that address almost the same issue (they are linked here), but never the exact same one with the same kind of scope and objective - at least as far as I know.</em> </p> <p><strong>Context:</strong> </p> <ul> <li>I have a MP3 file with ID3 tags for artist name and song title.</li> <li>I have two tables Artists and Songs</li> <li>The ID3 tags might be slightly off (e.g. Mikaell Jacksonne)</li> <li>I'm using ASP.NET + C# and a MSSQL database</li> </ul> <p>I need to synchronize the MP3s with the database. Meaning:</p> <ol> <li>The user launches a script</li> <li>The script browses through all the MP3s</li> <li>The script says "<em>Is 'Mikaell Jacksonne' 'Michael Jackson' YES/NO</em>"</li> <li>The user pick and we start over</li> </ol> <p>Examples of what the system could find:</p> <p><em>In the database...</em></p> <pre><code>SONGS = {"This is a great song title", "This is a song title"} ARTISTS = {"Michael Jackson"} </code></pre> <p><em>Outputs...</em></p> <pre><code>"This is a grt song title" did you mean "This is a great song title" ? "This is song title" did you mean "This is a song title" ? "This si a song title" did you mean "This is a song title" ? "This si song a title" did you mean "This is a song title" ? "Jackson, Michael" did you mean "Michael Jackson" ? "JacksonMichael" did you mean "Michael Jackson" ? "Michael Jacksno" did you mean "Michael Jackson" ? </code></pre> <p><em>etc.</em></p> <p>I read some documentation from this <a href="https://stackoverflow.com/questions/41424/how-do-you-implement-a-did-you-mean">/how-do-you-implement-a-did-you-mean</a> and this is not exactly what I need since I don't want to check an entire dictionary. I also can't really use a web service since it's depending a lot on what I already have in my database. If possible I'd also like to avoid dealing with <a href="http://en.wikipedia.org/wiki/Edit_distance" rel="nofollow noreferrer">distances</a> and other <a href="http://rads.stackoverflow.com/amzn/click/0262133601" rel="nofollow noreferrer">complicated things</a>.</p> <hr> <p>I could use the <a href="http://code.google.com/apis/soapsearch/reference.html#1_3" rel="nofollow noreferrer">google api</a> (or something similar) to do this, meaning that the script will try spell checking and test it with the database, but I feel there could be a better solution since my database might end up being really specific with weird songs and artists, making spell checking useless.</p> <p>I could also try something like what has been explained <a href="https://stackoverflow.com/questions/39240/similar-posts-like-functionality-using-ms-sql-server">on this post</a>, using <a href="http://en.wikipedia.org/wiki/Soundex" rel="nofollow noreferrer">Soundex</a> <a href="http://www.csharphelp.com/archives2/archive394.html" rel="nofollow noreferrer">for c#</a>.</p> <p>Using a regular spell checker won't work because I won't be using words but names and 'titles'. </p> <hr> <p>So my question is: is there a <em>relatively</em> simple way of doing this, and if so, what is it?</p> <p>Any kind of help would be appreciated.</p> <p>Thanks!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USmarcgg
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to implement a SIMPLE "You typed ACB, did you mean ABC?"
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to implement a SIMPLE "You typed ACB, did you mean ABC?"
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to implement a SIMPLE "You typed ACB, did you mean ABC?"
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou're looking for a simple answer to a complicated problem. Given the constraints you've listed, I doubt you'll find an answer.
      singulars
      1. POHow to implement a SIMPLE "You typed ACB, did you mean ABC?"
      1. USMark Ransom
    2. COI doubt too, but who knows...
      singulars
      1. POHow to implement a SIMPLE "You typed ACB, did you mean ABC?"
      1. USmarcgg
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload