Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “misspell” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
misspell124430(None) 
misspells1343761misspells
misspelt1247271misspelt
missel85216522miss_e_l
missels94614812miss_els
misspeak1643492misspeak
misspelled1543502misspelled
misspend1345242misspend
misspent1259172misspent
ainsell796393ains_ell
bonspell1243163bonspell
dispel9310323di_spe_l
dispels10310503di_spels
hisself1335913hiss_elf
micell1098193mi__cell
minipill1244353minipill
misapply1742883misapply
misbill1137033mi_sbill
miscall1139653mi_scall
misdeal1037663mi_sdeal
misfield14265913misfield
mispen10312173mi_spe_n
mispens11311073mi_spens
mispled12310463mi_spled
misrely12319613mi_srely
missable12311533missable
missal84314903miss__al
missals93914433miss_als
misseat93617243miss_eat
missed94423603miss_e_d
missend104411373miss_end
missent94318713miss_ent
misses85130873miss_e_s
misset85028153miss_e_t
missets94516573miss_ets
missies93423983missie_s
missile92815403miss_ile
missiles103015083missiles
misspace1446523misspace
misspeaks1743063misspeaks
misspelling1643753misspelling
misspends1443853misspends
misspoke1645413misspoke
missteer1037223missteer
misstep11158463misste_p
missteps12156143missteps
misstyle1345273misstyle
mussel83412903muss_e_l
mussels9419843muss_els
outspell10125453outspell
respell947023_respell
spell75020303___spell

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.406440125.6
2DLD Change Limit146162527.57619292.8
3Display Results52520.0331575.8
 (SQL Overall)178691528.01522294.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.