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

422 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
mispens1131107(None) 
mispen10312171mispen_
aspens85013352_aspens
crispens12286252crispens
dispels10310502dispels
dispend11289412dispend
dispends12308532dispends
dispense11129782dispense
lippens11328532lippens
lispers94514322lispers
listens74014132listens
middens11379382middens
miens76118302mi__ens
mildens10339932mildens
misers85025702mis_ers
mises74740562mis_e_s
misplans1238862misplans
missels94614812missels
missend104411372missend
missends11368232missends
missense1037962missense
missent94318712missent
misses85130872misse_s
missets94516572missets
misspend1345242misspend
misspends1443852misspends
misspent1259172misspent
mistend103812522mistend
mistends11419592mistends
misters93927512misters
mittens9349882mittens
mizens174610252mi_zens
mizzens17366122mizzens
moistens10268772moistens
pigpens1235502pigpens
ripens85012172ri_pens
aisles64721143aisle_s
arpens84814823_arpens
aspen75216093_aspen_
aspers86220313_aspers
biogens1038963biogens
bipeds11458053bi_peds
bises75435623bis_e_s
bisons83914373bis_ons
bisters93922613bisters
cisterns10369573cisterns
copens106119963_copens
crispen11348203crispen_
crispers12309433crispers
dampens12348563dampens
deepens10307813deepens
diapers104713913diapers
dickens144410133dickens
dippers123615183dippers
discerns1138163discerns
dishes104622653dishe_s
dishpans14115833dishpans
dismes95617673disme_s
disowns1136733disowns
dispel9310323dispe_l
dispensed13158773dispensed
dispenser12128323dispenser
dispenses121210763dispenses
disperse111011353disperse
dissent84018683dissent
dissents93411863dissents
disses75225963disse_s
distend93312073distend
distends10339823distends
distent84120853distent
dizens164911393di_zens
eisweins1143383eisweins
fastens105511753fastens
fishers134714723fishers
fishes125221343fishe_s
gaspers105014133gaspers
gipons9389603gi_pons
gippers123212083gippers
givens10379733gi_vens
glistens9366593glistens
gospels1035593gospels
happens14359173happens
hastens106214813hastens
hissers104112313hissers
hisses94719353hisse_s
impels10389523_impels
impend11478793_impend
impends12376803_impends
inspans937803inspans
isles54220563_isle_s
islets64513083_islets
isseis638563_isseis
jaspers164310463jaspers
kippen14299013kippen_
kippers153211433kippers
kismets13306883kismets
kissers114211293kissers
kisses104217333kisse_s
kittens11347583kittens
lessens7409383lessens
lichens123510683lichens
liens56525503li__ens
likens105613703li_kens
limens84618033li_mens
limpers113815223limpers
limpets11329783limpets
lindens839413lindens
linens64818393li_nens
lipins85016883li_pins
lippen103911403lippen_
lippers113416443lippers
lisles63416283lisle_s
lisped94113423lispe_d
lisper84114433lispe_r
lisping103412753lisping
lisps76913913lisp__s
listees73416673listees
listels74212433listels
listen64816813listen_
listers74026533listers
livens94314893li_vens
lumpens11298263lumpens
maddens11359753maddens
maidens10349663maidens
mappers133313783mappers
martens93714953martens
mascons113411583mascons
masers84623453mas_ers
mashers124621053mashers
mashes115030003mashe_s
maskegs14375413maskegs
maskers133913843maskers
masons83916513mas_ons
masses85028713masse_s
masters94628923masters
mavens114312973m_avens
meisters103313843meisters
meseems1165603meseems
meshes115019443meshe_s
mesnes85216213mesne_s
mesons83215843mes_ons
messans92710463messans
messes84924343messe_s
mestees94617753mestees
miches134320733miche_s
mickeys18447943mickeys
microns113814783microns
midden104112853midden_
midges103516483midge_s
midgets113910253midgets
midlegs1156323midlegs
mien65028363mi__en_
mignons1037863mignons
mikes115129893mi_ke_s
mikrons13428413mikrons
mikvehs19111683mikvehs
milden94113153milden_
mildews13365883mildews
milers84625163mi_lers
miles74645073mi_le_s
milieus939803milieus
milkers134411613milkers
millers93621343millers
milles84526563mille_s
millets94216843millets
milnebs11113793milnebs
milpas101710273milp_as
milreis937323milreis
milters93619093milters
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
mincers113714853mincers
minces104420803mince_s
minders103720123minders
miners84126633mi_ners
mines75651953mi_ne_s
minions93314623minions
minkes124618783minke_s
minsters103813923minsters
minters93822473minters
minuend1035383minuend
minuends1143893minuends
minuets9259853minuets
minxes154612983minxe_s
minyans1237263minyans
miocene1147923miocene
mioses84318853miose_s
mips85534083mi_p__s
mires75640883mi_re_s
mirins83918903mi_rins
misacts1139353misacts
misadds1136303misadds
misagent11410723misagent
misagents1246793misagents
misaims11310113misaims
misavers1348063misavers
misbegins1444893misbegins
misbias1139083misbias
misbind1258273misbind
misbinds1345163misbinds
miscoins12311083miscoins
miscues11312393miscues
miscuts1139183miscuts
misdeal1037663misdeal
misdeals1147223misdeals
misdeed113211053misdeed
misdeeds12276813misdeeds
misdeem12217873misdeem
misdeems13255653misdeems
misdoers1137103misdoers
misdoes10312493misdoes
misdone10310863misdone
mise66043583mis_e__
misease92713043mis_ease
miseat82925713mis_eat
miseats92815783miseats
miser75430403mis_e_r
misery114113543mis_ery
misevent1349223misevent
misevents1456003misevents
misfed124113023misfe_d
misfeed13389683misfeed
misfeeds14315623misfeeds
misfits12279663misfits
misguess1134643misguess
mishaps1438723mishaps
mishear1238393mishear
mishears1338323mishears
mishits122513083mishits
misjoins1736913misjoins
miskals13369763miskals
miskeep1536403miskeep
miskeeps1644163miskeeps
miskept1538923miskept
misknew1633883misknew
mislays12349243mislays
mislead10419973mislead
misleads11358543misleads
mislearns1144523mislearns
misled94719313misle_d
mislies92922283mislies
mismeet113215163mismeet
mismeets12297733mismeets
mismet103722373misme_t
misos76523293mis__os
mispage12310523mispage
mispages13311183mispages
mispaint121111893mispaint
mispaints13106183mispaints
misparse1237733misparse
mispart111113783mispart
misparts12108173misparts
mispenned1445413mispenned
misplan1147773misplan
misplant12410763misplant
misplants1347313misplants
misplay1436383misplay
misplays1555543misplays
misplead1345023misplead
mispleads1444203mispleads
mispled12310463mispled
mispoint121012363mispoint
mispoints13106633mispoints
mispoise1248263mispoise
misprint12912973misprint
misprints13107223misprints
misread10339723misread
misreads11268923misreads
misrely12319613misrely
miss65339423mis___s
missals93914423missals
missays124010253missays
misseat93617243misseat
misseats104011683misseats
missed94423603misse_d
missel85216523misse_l
missenses1148033missenses
misset85028153misse_t
missies93423983missies
missing103619073missing
missions10311903missions
missis84417503mis_sis
misspeak1643493misspeak
misspeaks1743063misspeaks
misspell1244303misspell
misspells1343763misspells
misspelt1247273misspelt
missteps12156143missteps
missus85312293mis_sus
misted93625823miste_d
mister84728563miste_r
misterm114314513misterm
misterms123711353misterms
misteuk1335893misteuk
misting103623383misting
mistress10310703mistress
mists76633903mis__ts
mistune9310653mistune
mistunes10311133mistunes
mistypes15116713mistype_s
misusers10348083misusers
misuses93216023misuses
miters84328783mi_ters
mites75141803mi_te_s
mithers123516733mithers
mitogens1146973mitogens
mitres83922073mitre_s
mitten83914093mitten_
mixers154513563mi_xers
mixes147224403mi_xe_s
mizen164815273mi_zen_
mizzen16447953mizzen_
moisten93110143moisten_
mopeds11499663m_opeds
mopers104220373m_opers
mopes95134983m_ope_s
moppers133412463moppers
moppets13307163moppets
moreens939963moreens
morgens10310463morgens
moseys114711703mos_eys
moshers124017843moshers
moshes115222873moshe_s
mossers94116193mossers
mosses85527683mosse_s
mudhens1335103mudhens
mullens93611313mullens
mumpers133311373mumpers
musers84719103mus_ers
muses75134303mus_e_s
mushers124016443mushers
mushes114124563mushe_s
muskegs14285013muskegs
muskets13258643muskets
muslins9312213muslins
mussels9419843mussels
musses84624783musse_s
mustees94614923mustees
musters94522513musters
myopes13419963myope_s
nippers113012623nippers
niseis63512023nis_eis
opens76118553__opens
pens65649643___pens
pigpen1136583pigpen_
pinkens13419643pinkens
pipers104318663pi_pers
pipes96030143pi_pe_s
pipets105714773pi_pets
pippins10319753pippins
pishers123815753pishers
pishes114722103pishe_s
pissers95014753pissers
pisses84525083pisse_s
pistes85325633piste_s
pistons93016373pistons
raspers94415923raspers
reopens939373reopens
richens12349733richens
ripen75619263ri_pen_
ripes75435773ri_pe_s
rippers114115033rippers
risen54621883ris_en_
risers64624783ris_ers
rises55244043ris_e_s
riskers114011993riskers
samisens1035483samis_ens
shippens15316803shippens
sickens134411483sickens
siemens938413siemens
simpers113014123simpers
sipes76036953si_pe_s
sippers113117753sippers
sippets113310183sippets
sirens65318153si_rens
sises55233833sis_e_s
siskins1159583siskins
sisses64520603sisse_s
sisters73721593sisters
sithens1039383sithens
smidgens12325643smidgens
spans74528733__spans
speans85417143__speans
specs96916673__specs
spend85619333__spend
spends94714473__spends
spense83912433__spense
spent75532833__spent
spews105015923__spews
spins75327983__spins
suspend1036013suspend
suspends1145143suspends
suspense10135743suspense
tiepins939463tiepins
tippers113414353tippers
tippets11339373tippets
tisanes7311853tisanes
unpens82511013_unpens
unspent92610893unspent
vespers1239033vespers
vipers114914533vi_pers
vises84427773vis_e_s
visions10311023visions
vixens16286203vi_xens
whispers16266993whispers
widens106212723wi_dens
wipers115416083wi_pers
wipes104827083wi_pe_s
wisent93516343wis_ent
wisents10249063wis_ents
wises85633193wis_e_s
wishers133215213wishers
wishes124920953wishe_s
wisped123411893wispe_d
wisping133711943wisping
wisps105214183wisp__s
wisses94619603wisse_s
wizens186110263wi_zens
wizzens18385483wizzens
yipes106017843yi_pe_s
zippers203310383zippers

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274225.82623005.0
3Display Results4224220.1602637.5
 (SQL Overall)1786914226.39227955.4
 
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.