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

247 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
mistakes14121341(None) 
mismakes16129881mismakes
mistake131312621mistake_
mistaken14147831mistaken
mistaker14109331mistaker
mistakers15117081mistakers
distaves12311402distaves
intakes11310942_intakes
mintages111110512mintages
misdates111113632misdates
miseases102614342miseases
mislikes143311832mislikes
mismake15139372mismake_
mismates121114562mismates
misnames12119882misnames
mispages13311182mispages
misrates101318242misrates
misstates11710632misstates
mistimes12612612mistimes
mistraces13312292mistraces
mistunes10311132mistunes
mistypes15116712mistypes
misyokes1735512misyokes
stakes103927292__stakes
betakes134212523_betakes
bistate9313823bistate_
bistres94017213bist_res
cistuses1038283cistuses
diastases1047073diastases
dictates11311383dictates
discases112014503discases
diseases92415813diseases
dislikes132810843dislikes
disrates91118153disrates
dissaves1239413dissaves
distaffs1565083distaffs
distains9413603distains
distances12311653distances
distastes1039633distastes
distomes11314163distomes
disyokes1656503disyokes
epistases1146323epistases
epistaxes1844453epistaxes
estates74520183_estates
gestates93213733gestates
histones11312803histones
hostages122311693hostages
imitates10310503imitates
instates81615833instates
intake10510863_intake_
istles62814983_ist_les
kishkes1334773kis_hkes
listees73416673list_ees
makes115336853m___akes
maltases1039693maltases
massages1159883massages
mastabas1246803mastabas
mastixes1738253mastixes
matsutakes1651783matsutakes
meltages1148243meltages
mesdames1346043mesdames
messages1138233messages
mestees94617753mest_ees
metages102714973m_etages
metates92720013m_etates
midspaces1643993midspaces
migrates111112853migrates
mikes115129893mi___kes
milages103114403mi_lages
mileages11249693mileages
militates11310883militates
milkshakes1851763milkshakes
millages113212903millages
millcakes1744683millcakes
ministates1246743ministates
minkes124618783mi__nkes
mintage101110123mintage_
mirages102213533mi_rages
misacts1139353mis_acts
misadds1136303mis_adds
misaims11310113mis_aims
misate81222693mis_ate_
misatones1148933misatones
misaver1249813mis_aver
misavers1348063mis_avers
misbiases1346253misbiases
miscalls1239003miscalls
miscasts1238343miscasts
miscites12313783miscites
miscodes13310423miscodes
miscues11312393mis_cues
misdate101413963misdate_
misdated121211123misdated
misdoes10312493mis_does
misease92713043misease_
miseaten10310773miseaten
miseats92815783misea_ts
miseries10320403miseries
mises74740563mis___es
misfiles133110983misfiles
misfires132210583misfires
misframes1646633misframes
misgauges1344313misgauges
misgave13298283misgave_
misgives14329293misgives
misgrades1347363misgrades
mishaps1438713misha_ps
miskals13369763miska_ls
mislabel1296173mislabel
mislabels13114313mislabels
mislayer1337503mislayer
mislayers1445943mislayers
mislays12349243misla_ys
mislies92922283mis_lies
mislike132914833mislike_
misliked15319513misliked
misliker14319573misliker
mislikers15317063mislikers
mislives132912153mislives
mismade12129353mismade_
mismarked1845243mismarked
mismarks1645893mismarks
mismate111415353mismate_
mismated131111333mismated
mismoves1537293mismoves
misname11119483misname_
misnamed13127593misnamed
mispage12310523mispage_
mispaged1438243mispaged
misparse1237733misparse
misparses1347653misparses
misparts12108173misparts
misplaces1537953misplaces
misraise10410523misraise
misraises1149933misraises
misrate91319143misrate_
misrated111315383misrated
misrules1039383misrules
missals93914423missa_ls
missays124010253missa_ys
misses85130873mis__ses
misshapes1645913misshapes
missies93423983mis_sies
missiles103015083missiles
missises103513693missises
missives133212843missives
misspaces1546513misspaces
misstamps1543373misstamps
misstarts1145833misstarts
misstate10711343misstate_
misstated1278973misstated
misstrikes1644363misstrikes
misstyles1445023misstyles
missuses10309683missuses
mistakenly1961513mistakenly
mistaking1699693mistaking
mistbows1543993mistbows
misteaches1744993misteaches
misted93625823mist__ed
mistends11419593mistends
mister84728563mist__er
misterms123711353misterms
misters93927513mist_ers
misthrew16124763misthrew
mistier93418713mist_ier
mistiest103018313mist_iest
mistime11312613mistime_
mistimed1339123mistimed
mistiness111911633mistiness
mistitles1147953mistitles
mistrace12312643mistrace_
mistraced1439453mistraced
mistrains11511353mistrains
mistrals101212623mistrals
mistress10310703mistress
mists76633903mist___s
mistune9310653mistune_
mistuned1157723mistuned
mistype14126523mistype_
mistyped1685173mistyped
misusages1244973misusages
misuses93216023mis_uses
misvalues1444683misvalues
misyoke1635823misyoke_
misyoked1834623misyoked
mites75141803mi_t__es
mitises9315543mi_tises
mitoses9312183mi_toses
mitres83922073mi_t_res
mixtures1735753mixtures
moistures1147323moistures
montages111412183montages
montanes101114523montanes
muspikes1635243muspikes
mustaches16166053mustaches
mustangs11255973mustangs
mustards11297883mustards
mustees94614923must_ees
mutases92012043m_utases
mutates92215793m_utates
nictates1039593nictates
outtakes12310033outtakes
partakes1449923partakes
pikakes1245823pi_kakes
pistaches1646673pistaches
pistes85325633pist__es
pistoles102514723pistoles
postages112815323postages
pristanes11410433pristanes
restages92815773restages
restates83423433restates
restokes125213043restokes
retakes113718863_retakes
sakes95540753__s_akes
shakes135024593__shakes
shiitakes1643013shiitakes
shitakes1546113shitakes
slakes104021883__slakes
snakes103919603__snakes
stades74626243__stades
stages75629493__stages
stake95927533__stake_
staked114621943__staked
stales65538293__stales
stanes64933403__stanes
stapes85028733__stapes
stares66038753__stares
stases64225563__stases
states64337083__states
staves94525193__staves
stokes104821793__stokes
strakes114218073__strakes
takes94437793___takes
testates83615453testates
tipstaves1443353tipstaves
tisanes7311853tis_anes
unstates81314993unstates
upstages11147373upstages
upstares10178583upstares
upstates10189643upstates
uptakes1336593_uptakes
vintages12118273vintages
visages1138693vis_ages
vistaed1138023vista_ed
vistaless1254573vistaless
vistas94513273vista__s
wastages12109753wastages

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622476.40622816.4
3Display Results2472470.0932655.9
 (SQL Overall)1786912476.65526850.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.