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 “misspend” 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.

92 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
misspend134524(None) 
missend104411371miss_end
misspends1443851misspends
misspent1259171misspent
dispend11289412di_spend
mispen10312172mi_spen_
mispens11311072mi_spens
missed94423602miss_e_d
missends11368232miss_ends
missent94318712miss_ent
missound1145112missound
misspeak1643492misspeak
misspell1244302misspell
misspelt1247272misspelt
mistend103812522mi_stend
airspeed1143603airspeed
dispends12308533di_spends
dissed85220183diss_e_d
dissent84018683diss_ent
distend93312073di_stend
fishpond1773223fishpond
fissiped1444153fissipe_d
hissed104114453hiss_e_d
impend11478793_i_mpend
issued746723_issue_d
kissed114412853kiss_e_d
lisped94113423li_spe_d
massed94421323mass_e_d
messed95018183mess_e_d
messmen1137393messmen_
millpond1344143millpond
minuend1035383mi_nuend
misagent11410723misagent
misbind1258273mi_sbind
misbound1344933misbound
misbrand1346413misbrand
miscued1239293miscue_d
misdeed113211053mi_sdeed
misevent1349223misevent
misfed124113023mi_sfe_d
misfeed13389683mi_sfeed
misfield14265913misfield
mislead10419973mi_slead
misled94719313mi_sle_d
mispenned1445413mi_spenned
misplead1345023misplead
mispled12310463mi_spled
misread10339723mi_sread
missaid10310303miss_aid
misseat93617243miss_eat
missel85216523miss_e_l
missels94614813miss_els
missense1037963miss_ense
misses85130873miss_e_s
misset85028153miss_e_t
missets94516573miss_ets
misshaped1744753misshape_d
misshapen1643783misshapen_
misshod1335873miss_hod
missies93423983missie_s
missing103619073miss_ing
mission9312743mission_
missioned1248603missioned
missions10311903missions
missounds1243533missounds
misspace1446523misspace
misspaced1645353misspaced
misspeaks1743063misspeaks
misspelled1543503misspelled
misspells1343763misspells
misspending1743653misspending
misspoke1645413misspoke
misspoken1743263misspoken_
missteer1037223missteer
misstep11158463misste_p
missteps12156143missteps
misted93625823mi_ste_d
mistends11419593mi_stends
mistuned1157723mistuned
mistyped1685173mistype_d
misused104111283misuse_d
mossed94818893moss_e_d
mussed94418903muss_e_d
outspend11126203outspend
pissed94816933piss_e_d
resuspend1242293resuspend
spend85619333___spend
suspend1036013_suspend
tissued835583tissue_d
vilipend1442523vilipend
wisped123411893wi_spe_d
wissed104114643wiss_e_d

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.423422437.4
2DLD Change Limit146162927.67019056.3
3Display Results92920.0303066.7
 (SQL Overall)178691928.12321998.2
 
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.