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

428 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
dottels832778(None) 
dottel73610891dottel_
dotters83715971dotters
dottles83912281dottles
dottrels963491dottrels
boatels93510232boatels
botels84815802bo_tels
bottles94216272bottles
cotters94323442cotters
donzels1735392donzels
dorsels84412572dorsels
dossels85511602dossels
doters74423912do_ters
dotes65836692do_te_s
dotted84717522dotte_d
dotter74419342dotte_r
dotterels1043902dotterels
dottily1147282dottily
dottle74212502dott_le
dottrel834462dottrel_
dowels104813342do_wels
hostels103712312hostels
hotels94515512ho_tels
jotters143413802jotters
lotters73921062lotters
lottes65322752lotte_s
motels83616892mo_tels
mottes85523692motte_s
mottles93415802mottles
otters64021512_otters
potters94024342potters
pottles93816982pottles
rotters74421392rotters
rottes64524832rotte_s
totters74618732totters
adoptees1145123adoptees
adopters1136693adopters
artels66216233_artels
battens95313263battens
batters94626013batters
battles94517683battles
betels84515063_betels
bethels1238533bethels
betters94422093betters
bitters94920363bitters
blotters104110983blotters
boatel84314093boatel_
boaters93419243boaters
boites84322703boite_s
bolters94017803bolters
bootees94114473bootees
bordels103911973bordels
botel75121863bo_tel_
bothers124317753bothers
bottle84916073bott_le
bottled104611233bottled
bottler94211883bottler
bottlers103810013bottlers
bottoms1136993bottoms
botts75224863bott__s
bowels114315593bo_wels
brothels13277073brothels
buttals938503buttals
butters94521723butters
buttes84822563butte_s
cartels94618123cartels
chattels13286793chattels
coatees93816553coatees
coaters93525793coaters
colters93522443colters
compels133210883compels
comtes106222813comte_s
contes84432913conte_s
cooters94525723cooters
copters113621283copters
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
costers94128333costers
costrels1038933costrels
cotes76347843co_te_s
cottars94412243cottars
cottas84615573cott_as
cotter84926673cotte_r
cottiers10399153cottiers
cottons9312193cottons
couters93827303couters
cutters94218963cutters
cuttles93613923cuttles
dactyls1333913dactyls
damsels10126703damsels
darnels83710433darnels
darters84017603darters
dartles84014133dartles
daters74827373d_aters
dates65639153d_ate_s
dattos74311903datt_os
deckels14367363deckels
defuels11296983defuels
dels56745473d___els
dentals83915393dentals
dentils84115583dentils
details84214043details
deters74724683d_eters
devels104313903d_evels
diesels8429143diesels
dieters83216433dieters
diopters1137693diopters
dispels10310503dispels
distils83015803distils
dites66339153d_ite_s
dithers114016153dithers
ditties83116983ditties
dittos74111973ditt_os
ditzes163212423ditze_s
djebels1753293djebels
doated84118183doate_d
doats65224883doat__s
dobbers123513253dobbers
dobies94422093dobie_s
dockers143715003dockers
dockets144412243dockets
doctors1039993doctors
dodders105511793dodders
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119083dodge_s
dodoes85716103dodoe_s
doers65225713do__ers
does56554473do__e_s
doffers14359853doffers
doges75630163do_ge_s
dogeys115510663do_geys
doggers104413433doggers
doggrels1142633doggrels
dogies85022253dogie_s
doglegs1034783doglegs
doited85016633doite_d
doits66223673doit__s
doles67843753do_le_s
dolls66126923do__lls
dolmens10388693dolmens
dols56943053do___ls
dolts65626313dolt__s
domes85735563do_me_s
donates83217223donate_s
donees74519493do_nees
dongles93212873dongles
donkeys15426663donkeys
donnees84210363donnees
donzel1636313donzel_
doodles93614163doodles
doolees83711613doolees
doozers17419293doozers
dopers95522483do_pers
dopes84935043do_pe_s
dories75232363dorie_s
dormers104313923dormers
dorpers104113173dorpers
dorsals84110843dorsals
dorsel75315503dorsel_
dorsers83516303dorsers
dosers75723633do_sers
doses65938503do_se_s
dossals8379293dossals
dossel74813643dossel_
dossers84516233dossers
dosses76126273dosse_s
dossils8669773dossils
dotages92311793dotages
dotal64919623do_tal_
dotards937253dotards
dote55442883do_te__
doted75227073do_te_d
doter65428623do_te_r
dotier73917033dotie_r
dotiest83717453dotiest
dots55647663do_t__s
dotterel945063dotterel
dottier83910923dottier
dottiest92611393dottiest
dottiness1058043dottiness
dotting93314483dotting
dotty94516103dott__y
doubles103113353doubles
doubters11257393doubters
doucely1344883doucely
dousers84817273dousers
douses74928933douse_s
dovens104413903do_vens
doves94728153do_ve_s
dowel95618193do_wel_
dowers104523293do_wers
downers113912773downers
dowsers115013533dowsers
dowses105718303dowse_s
doxies143917853doxie_s
doyens104810223do_yens
doyleys14384923doyleys
dozens164612463do_zens
dozers164815423do_zers
dozes155226303do_ze_s
drivels11397923drivels
duels65619233d__uels
duffels14296453duffels
dusters84918363dusters
duties74921903dutie_s
dynels10536813d_ynels
fattens105111713fattens
fetters103517903fetters
fettles103912733fettles
fitters104517753fitters
floatels11295663floatels
footers104618333footers
footles103715713footles
fortes95327183forte_s
fosters104220103fosters
fyttes1236933fytte_s
getters84216103getters
goatees82710443goatees
goiters84014443goiters
gospels1035593gospels
gotten73410113gotte_n
gutters83715513gutters
guttles83011933guttles
hatters104221523hatters
hitters104717593hitters
hooters104520473hooters
hosels94218603ho_sels
hostel93914153hostel_
hostess103210243hostess
hotbeds13315003hotbeds
hotel85520753ho_tel_
hotness1038613hotness
hotted104319943hotte_d
hotter94720083hotte_r
hottest10411383hottest
hotties103016963hotties
housels105312133housels
hovels125413333ho_vels
jitters144314473jitters
jolters143711993jolters
jostles143411143jostles
jotted143615173jotte_d
jotter134315633jotte_r
kettles113411613kettles
kittel10368873kittel_
kittens11347583kittens
kittles113012493kittles
knotters12276153knotters
koels94613903ko__els
lattens75014673lattens
lattes65324203latte_s
letters73819853letters
lintels73311163lintels
listels74212433listels
litters73422573litters
littles73212783littles
lofters103912903lofters
loiters74116613loiters
looters74419163looters
losels64714583lo_sels
lotte54923853lotte__
lotted74222403lotte_d
lotter64025603lotte_r
lottery10389833lottery
lottos64613103lott_os
mantels94515043mantels
matters94421753matters
mattes85624533matte_s
mettles94115023mettles
mittens9349883mittens
models94216353mo_dels
mohels115011323mo_hels
molters93816973molters
montes84226933monte_s
mooters93818623mooters
morels84820013mo_rels
morsels94112653morsels
mortals93914003mortals
motel76623243mo_tel_
motes75944003mo_te_s
motets84216193mo_tets
mothers123717623mothers
motiles93317433motiles
motleys1235683motleys
motte75526973motte__
mottle84116053mott_le
mottled10409973mottled
mottler94410343mottler
mottlers10388183mottlers
mottoes93412193mottoes
mottos84615243mott_os
motts76527003mott__s
mutters94117143mutters
mutuels935943mutuels
natters73718063natters
netters73618583netters
nettles73214083nettles
noels56418703no__els
notates72817483notate_s
noters64021003no_ters
notes55034583no_te_s
novels95512503no_vels
nutters74215433nutters
oaters65029793_oaters
octets839403_octets
octyls11135323_octyls
oriels64914623_oriels
others93918003_others
ottars64112223_ottars
otter54423973_otte_r
ottos54714323_ott_os
ousels64815273_ousels
outers64230173_outers
outtell797883outtell
outtells896853outtells
ouzels15408703_ouzels
oxters134813273_oxters
pastels95215183pastels
pattens95414923pattens
patters94825193patters
petrels9279373petrels
petters93722363petters
pettles93916483pettles
plotters104011553plotters
poetess938933poetess
poitrels1035243poitrels
pommels13235783pommels
pontes83627853ponte_s
pontils9312213pontils
portals94015563portals
porters93722703porters
postals93716373postals
posters93928013posters
poteens92910883poteens
potfuls1236293potfuls
pothers123818623pothers
potted94624013potte_d
potteen9319673potteen
potteens10256793potteens
potter83926983potte_r
pottery123011073pottery
potties93723543potties
pottle84416103pott_le
pottos84615873pott_os
potzers184010543potzers
pouters94221873pouters
powters124015663powters
puttees93612913puttees
putters94219193putters
ratels64518213_ratels
rattens74213403rattens
ratters74422473ratters
rattles73217303rattles
ritters74020623ritters
rondels82510053rondels
ronnels7318613ronnels
rooters74522933rooters
rootles73215633rootles
rosters73727543rosters
rotates72819773rotate_s
rotes56143903ro_te_s
rotls55620163ro_t_ls
rotte54625933rotte__
rotted74524433rotte_d
rotten64115433rotte_n
rottenly1144153rottenly
rotter64325463rotte_r
routers74822873routers
routes66129313route_s
rowels94515453ro_wels
settees73513633settees
setters73822063setters
settles73916003settles
shtetels1143233shtetels
shtetls1034583shtetls
sitters74221553sitters
slotters84012403slotters
softens10347623softens
sorels63921163so_rels
sorrels7310723sorrels
sorters74221133sorters
sotols63714473so_tols
sotted74121403sotte_d
sottedly1244303sottedly
souters74422603souters
spotters104313383spotters
steels64117983_steels
suttees74114063suttees
swotters11448483swotters
taels56822073__taels
tatters74520483tatters
tattles73616283tattles
teels55726373__teels
tels46841693___tels
tetters74320473tetters
titters74219623titters
tittles73413253tittles
tooters73818773tooters
tootles72915603tootles
tortes64826053torte_s
totals63115163to_tals
totems86810763to_tems
toters65026363to_ters
totes55139683to_te_s
totted74319953totte_d
totter65021463totte_r
tottery10388483tottery
touters74018353touters
towels94314643to_wels
trotters83310243trotters
utters63817123_utters
vetters104016323vetters
vittles103211113vittles
voltes94915583volte_s
voters95017443vo_ters
votes84627083vo_te_s
votress1035483votress
vowels124410483vo_wels
wattles103814073wattles
wetters103817753wetters
wittols1035733wittols
wotted104115713wotte_d
yatters103914623yatters
yodels104610073yo_dels
yokels13488063yo_kels
zosters163015413zosters

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.403443402.0
2DLD Change Limit1340274286.42320866.7
3Display Results4284280.1403057.1
 (SQL Overall)1786914286.96625651.9
 
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.