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

489 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
missels9461481(None) 
missals93914421missals
missel85216521missel_
misses85130871misse_s
missets94516571missets
mussels9419841mussels
diesels8429142diesels
dispels10310502dispels
disses75225962disse_s
dossels85511602dossels
hassels104311012hassels
hirsels10128342hirsels
hisself1335912hisself
hissers104112312hissers
hisses94719352hisse_s
isseis638562_isseis
kissers114211292kissers
kisses104217332kisse_s
listels74212432listels
masses85028712masse_s
messes84924342messe_s
mioses84318852miose_s
misdeals1147222misdeals
misers85025702mi_sers
mises74740562mi_se_s
miskals13369762miskals
mispens11311072mispens
misrely12319602misrely
missal84314902missal_
missays124010252missays
misseat93617232misseat
misseats104011682misseats
missed94423602misse_d
missend104411372missend
missends11368232missends
missense1037962missense
missent94318712missent
misset85028152misse_t
missies93423982missies
missile92815402missile
missiles103015082missiles
missis84417502miss_is
misspell1244302misspell
misspells1343762misspells
misspelt1247272misspelt
missteps12156142missteps
missus85312292miss_us
misters93927502misters
misusers10348072misusers
misuses93216022misuse_s
morsels94112652morsels
mossers94116192mossers
mosses85527682mosse_s
mussel83412902mussel_
musses84624782musse_s
passels93913022passels
pissers95014752pissers
pisses84525082pisse_s
sisses64520602sisse_s
tassels74510852tassels
tinsels738372tinsels
vessels1035932vessels
wisses94619602wisse_s
ainsell796393ainsell
ainsells895403ainsells
aisles64721143aisle_s
amassers10337833amassers
amasses93912853amasse_s
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
basses85428303basse_s
bassets96414823bassets
biases84618433biase_s
biasses94911653biasse_s
birses84717733birse_s
bises75435623bi_se_s
bisters93922603bisters
blisses94911513blisse_s
bosses85925403bosse_s
brisses94314313brisse_s
bushels124110713bushels
busses85023383busse_s
cesses84221363cesse_s
chisels12219103chisels
cissies94116153cissies
cossets95014283cossets
cuisses9319883cuisse_s
cussers94213393cussers
cusses84522773cusse_s
damsels10126703damsels
diesel74410403diesel_
dieses75218693diese_s
dishelm1335833dishelm
dishelms1444713dishelms
dishes104622653dishe_s
dismals102010243dismals
dismes95617673disme_s
dispel9310323dispel_
disseat83816923disseat
disseats93211503disseats
dissect103614133dissect
dissects11279243dissects
dissed85220173disse_d
disseise939843disseise
dissent84018683dissent
dissents93411863dissents
dissert83720693dissert
disserts92411813disserts
distils83015803distils
disuses84015403disuse_s
dorsels84412573dorsels
dossals8379293dossals
dossel74813643dossel_
dossers84516233dossers
dosses76126273dosse_s
dossils8669773dossils
easels65914553_easels
esses56422973_esse_s
fesses94820253fesse_s
fiscals1238003fiscals
fishers134714723fishers
fishes125221343fishe_s
fissile10269653fissile
fosses96022083fosse_s
fossils10379013fossils
fusels94412453_fusels
fussers104210813fussers
fusses94920553fusse_s
gassers84714633gassers
gasses75724783gasse_s
gimels938893gi_mels
gospels1035593gospels
gunsels8338133gunsels
gussets837443gussets
hansels104011653hansels
hassel95614213hassel_
hassles103411693hassles
himself1544273himself
hirsel9138683hirsel_
hirsles101510073hirsles
hissed104114453hisse_d
hisser94713793hisse_r
hissies103915823hissies
hosels94218603_hosels
hostels103712313hostels
housels105312133housels
impels10389513_impels
insets64016133_insets
isles54220563_isle_s
islets64513083_islets
isohels1035393_isohels
issei568573_isse_i
issuers746123_issuers
issues648803_issues
istles62814983_istles
itself946253_itself
jesses135215953jesse_s
josses135117683josse_s
kismets13306883kismets
kissed114412853kisse_d
kisser104212453kisse_r
kumisses1443583kumisse_s
lasses64827593lasse_s
lessees73510243lessees
lessens7409383lessens
libels85112693li_bels
linseys1035083linseys
lintels73311163lintels
lisles63416283lisle_s
lispers94514323lispers
listees73416673listees
listel64214733listel_
listens74014133listens
listers74026523listers
losels64714583_losels
losses65925233losse_s
mangels103614493mangels
manses84225513manse_s
mantels94515043mantels
marcels113212373marcels
marses84827113marse_s
marvels123810093marvels
masers84623453m_asers
mashers124621053mashers
mashes115030003mashe_s
maskegs14375413maskegs
maskers133913833maskers
massas85116463mass_as
masse75125293masse__
massed94421323masse_d
massedly1444303massedly
masseur935703masseur
masseurs1034923masseurs
masseuse1044253masseuse
massifs1237743massifs
massless10277113massless
masters94628923masters
measles92412753measles
meioses9310833meiose_s
meisters103313843meisters
mels65941533m___els
menses84222453mense_s
mescals112911553mescals
meseems1165603meseems
meshes115019443meshe_s
mesnes85216213mesne_s
messans92710463messans
messed95018183messe_d
messily12298813messily
mestees94617753mestees
metisses1036833metisse_s
miasmas1167743miasmas
miasms1097383mias_ms
miauls8178713mi_auls
micell1098193mi_cell
micells11107683micells
miches134320733miche_s
mickeys18447943mickeys
mickles153415003mickles
middens11379373middens
middles113415303middles
midges103516473midge_s
midgets113910253midgets
midlegs1156323midlegs
midsole1037813midsole
midsoles1137763midsoles
midsts95510053mids_ts
miens76118303mi__ens
miggles113512033miggles
mikes115129893mi_ke_s
mikvehs19111683mikvehs
mildens10339933mildens
mildews13365883mildews
milers84625163mi_lers
miles74645073mi_le_s
milieus939803milieus
milkers134411613milkers
millers93621333millers
milles84526563mille_s
millets94216843millets
mills75435053mi__lls
milnebs11113793milnebs
milreis937323milreis
mils66045323mi___ls
milters93619083milters
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
mimeses1139073mimeses
mimesis1137323mimesis
mincers113714843mincers
minces104420803mince_s
minders103720113minders
mindsets1135683mindsets
miners84126633mi_ners
mines75651953mi_ne_s
mingles103719003mingles
minkes124618783minke_s
minsters103813913minsters
minstrels1145693minstrels
minters93822463minters
minuets9259853minuets
minuses93512703minuse_s
minxes154612983minxe_s
miosis83615163mios_is
mires75640883mi_re_s
misacts1139353misacts
misadds1136303misadds
misaims11310113misaims
misally121111063misally
misavers1348053misavers
misbias1139073misbias
misbill1137023misbill
misbills1246083misbills
miscall1139643miscall
miscalls1239003miscalls
miscues11312393miscues
miscuts1139183miscuts
misdeal1037663misdeal
misdealt1147973misdealt
misdeed113211053misdeed
misdeeds12276813misdeeds
misdeem12217873misdeem
misdeems13255653misdeems
misdials1137493misdials
misdoers1137103misdoers
misdoes10312493misdoes
mise66043573mi_se__
misease92713043mi_sease
miseases102614343misease_s
miseat82925703mi_seat
miseats92815783miseats
miser75430403mi_se_r
miserly12329823miserly
misery114113543mi_sery
misfed124113023misfe_d
misfeed13389683misfeed
misfeeds14315623misfeeds
misfield14265913misfield
misfields15223653misfields
misfile122611553misfile
misfiles133110983misfiles
misfits12279663misfits
misguess1134643misguess
mishaps1438713mishaps
mishear1238393mishear
mishears1338323mishears
mishits122513083mishits
miskal123710263miskal_
miskeep1536403miskeep
miskeeps1644163miskeeps
miskept1538923miskept
mislabels13114313mislabels
mislays12349243mislays
mislead10419973mislead
misleads11358543misleads
misled94719313misle_d
mislies92922283mislies
mismeet113215163mismeet
mismeets12297733mismeets
mismet103722373misme_t
misos76523293mi_s_os
mispen10312173mispe_n
mispled12310463mispled
misread10339723misread
misreads11268923misreads
misrelies1149723misrelies
misrule939353misrule
misrules1039383misrules
miss65339413mi_s__s
missable12311533missable
missaid10310293missaid
missay114112143miss_ay
missenses1148033missenses
misshod1335873misshod
missilry1344653missilry
missing103619073missing
mission9312743mission
missions10311903missions
missises103513693missises
missive122413143missive
missives133212843missives
missort9314653missort
missorts1038323missorts
missout9412663missout
missouts1037623missouts
misspeak1643493misspeak
misspeaks1743063misspeaks
misspend1345243misspend
misspends1443853misspends
misspent1259173misspent
missteer1037223missteer
missteers1135913missteers
misstep11158463misstep
misstop11156413misstop
misstops12176413misstops
misstyle1345273misstyle
misstyles1445023misstyles
missuit9911303missuit
missuits1078023missuits
missuses10309683missuses
missy105617563miss__y
misted93625823miste_d
mistend103812523mistend
mistends11419593mistends
mister84728563miste_r
misterm114314513misterm
misterms123711333misterms
misteuk1335893misteuk
mistily122612343mistily
mistrals101212623mistrals
mistress10310703mistress
mists76633903mi_s_ts
misuse83213643misuse__
misused104111273misuse_d
misuser93210443misuse_r
miters84328773mi_ters
mites75141803mi_te_s
mithers123516733mithers
mitises9315543mitise_s
mitoses9312183mitose_s
mitres83922073mitre_s
mittens9349883mittens
mixers154513563mi_xers
mixes147224403mi_xe_s
mizens174610253mi_zens
mizzens17366123mizzens
mizzles17329493mizzles
models94216353m_odels
mohels115011323m_ohels
moistens10268773moistens
momsers113810843momsers
morels84820013m_orels
morsel85815893morsel_
moseys114711703m_oseys
moshers124017843moshers
moshes115222873moshe_s
mossed94818893mosse_d
mosser84618273mosse_r
motels83616893m_otels
mousers95216443mousers
mouses85531423mouse_s
mousses94012703mousse_s
muscles11310563muscles
musers84719093m_users
muses75134303m_use_s
mushers124016433mushers
mushes114124563mushe_s
muskegs14285003muskegs
muskets13258633muskets
mussed94418903musse_d
mussily12279773mussily
mustees94614923mustees
musters94522493musters
mutuels935943mutuels
myases113711553myase_s
myiases1235493myiase_s
myoses114013843myose_s
myself1445593m_yself
nesses64718323nesse_s
nickels13338653nickels
niseis63512023ni_seis
ousels64815273_ousels
passel85117003passel_
passers94717753passers
passes86030473passe_s
pastels95215183pastels
pishers123815753pishers
pishes114722103pishe_s
pissed94816933pisse_d
pisser84416383pisse_r
pistes85325633piste_s
pistils93314303pistils
pistols93213983pistols
pixels15478533pi_xels
plisses94411773plisse_s
posses85128803posse_s
possess9419113possess
possets94212773possets
prisses94816713prisse_s
pusses84322843pusse_s
rassles73513923rassles
ridgels9348023ridgels
riels55121333ri__els
rinsers73815743rinsers
rinses64720383rinse_s
risers64624783ri_sers
rises55244043ri_se_s
riskers114011993riskers
rissole739783rissole
rissoles839113rissoles
risuses73210923risuse_s
russets738163russets
sasses64124393sasse_s
seels55632823__seels
sels46345983___sels
simnels976103simnels
sisals63013573si_sals
sises55233833si_se_s
sissies73716603sissies
sisters73721573sisters
susses64221053susse_s
swisses10417143swisse_s
tassel66014773tassel_
tasses64826763tasse_s
tassets75012773tassets
teasels74311313teasels
tinsel639443tinsel_
tissues737463tissues
tossers74713493tossers
tosses65225393tosse_s
tressels8367653tressels
tussehs10395563tussehs
tussers74313563tussers
tusses64921243tusse_s
tussles737833tussles
vassals1057953vassals
vessel937953vessel_
vises84427773vi_se_s
visuals1036853visuals
weasels10468503weasels
wisely122711713wi_sely
wises85633193wi_se_s
wishers133215213wishers
wishes124920953wishe_s
wissed104114643wisse_d
wusses93314893wusse_s
yesses93615813yesse_s

Search took 8 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.1561145455.1
2DLD Change Limit1340274897.31018334.7
3Display Results4894890.1732826.6
 (SQL Overall)1786914897.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.