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 “mistaking” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

169 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
mistaking169969(None) 
mismaking18118021mismaking
misdating131010662misdating
miseating121215432miseating
mislaying1557912mislaying
misliking1637112misliking
mismarking1955862mismarking
mismating141211822mismating
misnaming1447422misnaming
mispaging1537802mispaging
misrating121014852misrating
missaying1537632missaying
misstating13129312misstating
mistaken14147832mistaken_
mistiming1438912mistiming
misting103623382mist__ing
mistracing1569602mistracing
mistuning1237672mistuning
mistyping1744722mistyping
misyoking1944922misyoking
staking123919802__staking
betaking153010153_betaking
dictating1338883dictating
discasing1339433discasing
diseasing11310833diseasing
disking134615493dis__king
disliking1537313disliking
dismaying1656823dismaying
disrating11714553disrating
dissaving1436953dissaving
distain8313783dista_in_
distaining1248903distaining
distains9413603dista_ins
distancing1447083distancing
distasting1248023distasting
disyoking1844993disyoking
estating92614993_estating
fisting113818123fist__ing
gestating11229983gestating
histamin1387043histamin_
histamine1476903histamine
histamins1476723histamins
histing113720373hist__ing
imitating1238763imitating
instating10812213instating
listening10128953listening
listing84020593list__ing
making134823853m___aking
mapmaking2044623mapmaking
masking145116613mas__king
massaging1346353massaging
mastering122315303mastering
masting104325823mast__ing
messaging1345343messaging
metaling111613723m_etaling
migrating13910533migrating
miking134218463mi___king
militating1348823militating
milking143712763mi__lking
milting103619123milt__ing
mimicking2043873mimicking
minting103020813mint__ing
misacting1439083misacting
misadding14115833misadding
misaiming1437873misaiming
misalign1146433mis_align
misatoning1346443misatoning
misbiasing1545203misbiasing
miscalling1547863miscalling
miscasting1557073miscasting
misciting1439673misciting
miscoding1538183miscoding
miscooking1945003miscooking
miscuing1338733mis_cuing
misdealing1457363misdealing
misdialing1446263misdialing
misdoing1238803mis_doing
misdrawing1745803misdrawing
misfiling1537223misfiling
misfiring1536973misfiring
misframing1846233misframing
misgauging1543903misgauging
misgiving1645593misgiving
misgrading1546823misgrading
mishearing1647883mishearing
miskicking1844243miskicking
mislain9311243misla_in_
misleading1446833misleading
misliving1546983misliving
mislying1437843mis_lying
mismoving1745783mismoving
mispaint121111893mispa_int
misparsing1546613misparsing
misparting1538083misparting
misplacing1745913misplacing
misplaying1845553misplaying
misraising1348123misraising
misreading1448263misreading
misruling1237493misruling
misseating131310943misseating
misshaping1844393misshaping
missing103619073mis__sing
misspacing1784983misspacing
misspeaking2043713misspeaking
misstamping1842993misstamping
misstarting14125203misstarting
misstriking1843933misstriking
misstyling1643833misstyling
mistake131312623mistak__e
mistakenly1961513mistakenly
mistaker14109333mistak_er
mistakers15117083mistakers
mistakes141213413mistak_es
misteaching1944533misteaching
mistending1447953mistending
misterming1538603misterming
misthink1745433mist_hink
misthinking2143423misthinking
mistitling1346223mistitling
mistrain10311943mistrain_
mistraining1446503mistraining
mistrains11511353mistrains
mistreating1449283mistreating
misusing1138893mis_using
misvaluing1684603misvaluing
mitering113015403mi_tering
mitring103514143mi_t_ring
moistening1346233moistening
montaging1346543montaging
mortaring1237943mortaring
musicking1844513musicking
mustang10267933musta__ng
mustering122212333mustering
musting103221073must__ing
mutating112211753m_utating
nictating1237573nictating
painstaking1852853painstaking
partaking1698673partaking
pistoling1268493pistoling
resoaking1439373resoaking
restacking1737183restacking
restaging112410853restaging
restating102319413restating
restoking1438193restoking
retaking133114283_retaking
risking123914243ris__king
shaking153317253__shaking
sistering101213753sistering
slaking123717473__slaking
snaking123915303__snaking
soaking123116613__soaking
stacking154215083__stacking
staging93818373__staging
staling83925423__staling
stalking133512223__stalking
staning83922243__staning
staring84527053__staring
stating83725163__stating
staving113915703__staving
staying114017323__staying
stoking123615593__stoking
taking114725953___taking
tictacking19113313tictacking
unstacking1744993unstacking
unstating10711213unstating
upstaging1344113upstaging
upstaring1235963upstaring
visaing11279333vis_a_ing
wisting113519743wist__ing

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411696.28323657.6
3Display Results1691690.0762223.7
 (SQL Overall)1786911696.78226347.8
 
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.