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

403 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
mistend10381252(None) 
distend93312071distend
missend104411371missend
misted93625821miste_d
mistends11419591mistends
cisted95217522ciste_d
dispend11289412dispend
distends10339822distends
distent84120852distent
fisted104218702fiste_d
histed104420242histe_d
intend72310372_intend
listed74322832liste_d
listen64816812listen_
listened9168812listened
listens74014132listens
masted94025802maste_d
milted93919942milte_d
minted94220582minte_d
minuend1035382minuend
misbind1258272misbind
misdeed113211052misdeed
misfed124113022misfe_d
misfeed13389682misfeed
mislead10419972mislead
misled94719312misle_d
mispen10312172mispen_
mispens11311072mispens
misread10339722misread
missed94423602misse_d
missends11368232missends
missent94318712missent
misspend1345242misspend
mistended13137332mistended
mister84728562miste_r
misterm114314512misterm
misters93927512misters
misteuk1335892misteuk
misting103623382misting
mistune9310652mistune
mistuned1157722mistuned
mitten83914092mitten_
mittened1136362mittened
mittens9349882mittens
moisten93110142moisten_
moistened1246002moistened
moistens10268772moistens
musted93321072muste_d
wisted104120272wiste_d
agisted938203agiste_d
airted74214503airte_d
aisled74516183aisle_d
ascend9429733_ascend
attend7258973_attend
bartend1038753bartend
basted95227233baste_d
bemisted1368383bemiste_d
bestead10389123bestead
bested94922763beste_d
bilsted1038033bilste_d
bister84922763biste_r
bistered112913333bistered
bisters93922613bisters
bistred103311853bistred
bitted94418483bitte_d
bitten84715123bitten_
busted95123153buste_d
cistern93310703cistern
cisterna10376363cisterna
cisterns10369573cisterns
cited84421953ci_te_d
contend103511893contend
costed95623113coste_d
descend11248153descend
dieted83115493diete_d
dinted84419843dinte_d
disband1138243disband
disced104914653disce_d
dished114318713dishe_d
disked125015763diske_d
dispends12308533dispends
dissed85220183disse_d
dissent84018683dissent
distant83519953distant
distended12157923distended
distender11167743distender
dusted83918373duste_d
emitted103010853emitte_d
existed1538473existe_d
existent1548263existent
extend14267523_extend
fasted105320953faste_d
fasten95114893fasten_
fastened12257853fastened
fastens105511753fastens
fiend95312983fi__end
fished134316313fishe_d
fisting113818123fisting
fitted104716663fitte_d
foisted113210603foiste_d
gasted84821583gaste_d
gifted114510703gifte_d
girted83912873girte_d
gitted84015053gitte_d
glisten8418083glisten_
glistened11174283glistened
glistens9366593glistens
gusted84316723guste_d
hasted105125283haste_d
hasten95718563hasten_
hastened12239103hastened
hastens106214813hastens
heisted113210653heiste_d
hilted104016043hilte_d
hinted104318323hinte_d
hissed104114453hisse_d
histing113720373histing
histoid1139823histoid
histone10312843histone
hoisted113411293hoiste_d
hosted105020343hoste_d
impend11478793_impend
instead836203instead
intends8239963_intends
intent63122773_intent
island738533_island
isled64615993_isle_d
jested144416503jeste_d
jilted144111353jilte_d
joisted15379173joiste_d
justed144215773juste_d
kilted113613833kilte_d
kissed114412853kisse_d
kited105120093ki_te_d
kitted115114833kitte_d
kitten104611483kitten_
kittened1334523kittened
kittens11347583kittens
lasted74323603laste_d
lifted104413523lifte_d
lilted73715373lilte_d
linted74021823linte_d
lisped94113423lispe_d
listee64223063liste_e
listees73416673listees
listel64214743liste_l
listels74212433listels
listener8158313listener
lister64527253liste_r
listers74026533listers
listing84020593listing
litten64014873litten_
lusted74319443luste_d
malted94819863malte_d
marted94425213marte_d
marten84518263marten_
martens93714953martens
mashed125325043mashe_d
masked134316523maske_d
masoned1039803masoned
massed94421323masse_d
master84831343maste_r
mastered112614003mastered
masters94628923masters
mastery124214323mastery
masthead1435883masthead
masting104325823masting
mastoid10711233mastoid
mated85537783m_ate_d
matted94521413matte_d
meated94222403meate_d
meister93114163meiste_r
meisters103313843meisters
melted94219063melte_d
mend75334033m___end
meshed124415933meshe_d
messed95018183messe_d
mestee84523883meste_e
mestees94617753mestees
mesteso937133mesteso
mestino9411643mestino
meted85424433m_ete_d
miched143913393miche_d
midden104112853midden_
middens11379383middens
midland1136613midland
midterm12316013midterm
mien65028363mi__en_
miens76118303mi__ens
miffed15398713miffe_d
miked125020453mi_ke_d
milded104416153milde_d
milden94113153milden_
mildened1235773mildened
mildens10339933mildens
milked134612573milke_d
milled94326173mille_d
milter84921233milte_r
milters93619093milters
milting103619123milting
mimed105622733mi_me_d
minced114114913mince_d
mind75434383mi___nd
minded103817833minde_d
mined85333353mi_ne_d
minster93914323minste_r
minsters103813923minsters
minter84425103minte_r
minters93822473minters
minting103020813minting
minuends1143893minuends
minuted10329503minute_d
miocene1147923miocene
mired85729223mi_re_d
misacted1338673misacte_d
misadd1037163mis_add
misagent11410723misagent
misate81222693misate__
misatone1049763misatone
misatoned1246693misatoned
misbinds1345163misbinds
misbound1344933misbound
misbrand1346413misbrand
miscited13310423miscite_d
miscued1239293miscued
misdated121211123misdate_d
misdeal1037663misdeal
misdeeds12276813misdeeds
misdeem12217873misdeem
misdid10510573mis_did
misdone10310863misdone
mise66043583mis_e__
miseat82925713mis_eat
miseaten10310773miseaten_
miser75430403mis_e_r
misers85025703mis_ers
misery114113543mis_ery
mises74740563mis_e_s
misevent1349223misevent
misfeeds14315623misfeeds
misfield14265913misfield
mishear1238393mishear
misheard1446253misheard
miskeep1536403miskeep
miskept1538923miskept
misknew1633883misknew
mislaid1039303mislaid
misleads11358543misleads
mismated131111333mismate_d
mismeet113215163mismeet
mismet103722373misme_t
mispenned1445413mispenned
misplead1345023misplead
mispled12310463mispled
misrated111315383misrate_d
misreads11268923misreads
misrely12319613misrely
misrender1286293misrender
missaid10310303missaid
misseat93617243misseat
missel85216523misse_l
missels94614813missels
missense1037963missense
misses85130873misse_s
misset85028153misse_t
missets94516573missets
misshod1335873misshod
missing103619073missing
missound1145113missound
misspends1443853misspends
misspent1259173misspent
missteer1037223missteer
misstep11158463misste_p
missteps12156143missteps
mist66154533mist___
mistake131312623mistake
mistaken14147833mistaken_
mistbow1443993mistbow
misteach1545443misteach
mistending1447953mistending
mistermed1438363mistermed
misterms123711353misterms
misthink1745433misthink
mistier93418713mistier
mistiest103018313mistiest
mistily122612343mistily
mistime11312613mistime
mistimed1339123mistimed
mistook1337153mistook
mistral91013643mistral
mistreat10313113mistreat
mistress10310703mistress
mists76633903mist__s
mistunes10311133mistunes
misty106120453mist__y
mistype14126523mistype
mistyped1685173mistyped
misused104111283misused
misword1338413misword
mite66249413mi_te__
miter75734793mi_te_r
mitered103213233mi_tered
miters84328783mi_ters
mites75141803mi_te_s
mitred94414343mi_tred
mixed155717253mi_xe_d
mizen164815273mi_zen_
mizens174610253mi_zens
mizzen16447953mizzen_
mizzens17366123mizzens
moated94819003moate_d
moistener1145843moistener
moister94015373moiste_r
moistest1038763moistest
molted94217473molte_d
molten83311813molten_
mooted94120373moote_d
moshed124517493moshe_d
mossed94818893mosse_d
moste75925083moste__
mostest9314793mostest
mused85524583mus_e_d
mushed124420843mushe_d
mussed94418903musse_d
mustang10267933mustang
mustard10359533mustard
mustee83922103muste_e
mustees94614923mustees
mustelid1144883mustelid
muster84724523muste_r
mustered112511503mustered
musters94522513musters
musting103221073musting
muted85023383m_ute_d
mystery15436523mystery
nested74720063neste_d
omitted10347893omitte_d
ousted73720583ouste_d
pasted94426903paste_d
pished124817063pishe_d
pissed94816933pisse_d
piste75824603piste__
pistes85325633piste_s
piston83515923piston_
pistons93016373pistons
pitted94319593pitte_d
portend103411193portend
posted93722493poste_d
pretend104011013pretend
protend104012793protend
resend75016773res_end
rested74430783reste_d
rifted104115313rifte_d
rioted73416373riote_d
risen54621883ris_en_
risked115514633riske_d
rusted75020923ruste_d
scend85516293__scend
send55237293__s_end
shend94719973__shend
sifted104313673sifte_d
silted74020013silte_d
sister64421583siste_r
sistered92612803sistered
sisters73721593sisters
sited65130743si_te_d
sitten64113823sitten_
smitten936693smitten_
spend85619333__spend
stand65923283__stand
stead65520273__stead
steed66024943__steed
steno54716863__steno
stent55634513__stent
subtend1037103subtend
suspend1036013suspend
tasted74123973taste_d
tend56433773___tend
tested74421523teste_d
tilted74616863tilte_d
tinted74419533tinte_d
twisted11277433twiste_d
upsend9356883ups_end
upstand1045343upstand
vested104217353veste_d
visaed104110503visae_d
vised95518763vis_e_d
viseed105310983vis_eed
visited1168773visite_d
vistaed1138023vistaed
waisted114210943waiste_d
wasted104423023waste_d
whisted144010013whiste_d
wilted103915713wilte_d
wised95123343wis_e_d
wisent93516343wis_ent
wished134417513wishe_d
wisped123411893wispe_d
wissed104114643wisse_d
wisting113519743wisting
wited94727143wi_te_d
witted104216813witte_d
zested164214043zeste_d

Search took 10 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 Filter1786911340270.436409841.7
2DLD Change Limit1340274039.14314659.0
3Display Results4034030.1402878.6
 (SQL Overall)1786914039.71918385.7
 
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.