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

235 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
dorados93820(None) 
dorado838811dorado_
dados75522432d__ados
dodos75819392do__dos
ordos65216202_or_dos
parados103816052parados
tornados945372tornados
abrades10312073abrades
ados57633513___ados
avocados1472983avocados
boards94616933board_s
boraces113716853boraces
borages103917163borages
borals86721913bora_ls
boranes93720403boranes
boras75938303bora__s
borates94823013borates
boraxes163511633boraxes
boredom1236943boredom
boredoms1346043boredoms
borides10515153borides
brads85528293_brad_s
bravos114711393_bravos
broads94515153broad_s
comedos12329073comedos
comrades13149773comrades
condos94322333co_ndos
corals85325143cora_ls
corantos10310103corantos
cordon95017293cor_don
cordons104415763cor_dons
cords86030623cor_d_s
corrades111211263corrades
credos94612853_credos
dadas75819863d__adas
dado67126333d__ado_
dadoes85616533d__adoes
dads67442773d__ad_s
dagos76419443d__agos
datos65222783d__atos
deads75726913d_ead_s
decades113615513decades
degrades11269923degrades
derails84216393derails
derates84028893derates
derats74625063dera_ts
derays105514253dera_ys
derides93420853derides
didos76820813d__idos
dildos8179303d_ildos
dioramas1145513dioramas
dirams94413703dira_ms
dirndls933893dirndls
doats65224883do_a_ts
dobras94811913dobra__s
dobros93910233do_bros
dodo66024913do__do_
dodoes85716103do__does
dogdom1186363do_gdom
dogdoms1295423do_gdoms
dogedom1244663dogedom
dogedoms1344333dogedoms
dojos135111793do__jos
dolmades1245463dolmades
domains10510873domains
dominos103210193dominos
donas65926473dona__s
donates83217223donates
donator8310263donator
donators9310403donators
doodads1035093doodads
doodoo8108893do_odoo
doodoos9107623doodoos
dopants1038433dopants
dopas85019063dopa__s
dorbugs1132983dorbugs
dorhawks1941613dorhawks
dories75232363dor_ies
dorks105724443dor__ks
dormers104313923dormers
dormins10311273dormins
dorms85723843dor__ms
dorpers104113173dorpers
dorps85419223dor__ps
dorrs65520593dor__rs
dors56747603dor___s
dorsad8408973dorsad__
dorsals84110843dorsals
dorsels84412573dorsels
dorsers83516303dorsers
dosages92310803dosages
dotages92311793dotages
dotards937253dotards
dourahs11487253doura_hs
douras75016723doura__s
drabs85119673d_ra_bs
draffs13617903d_raffs
drafts105012533d_rafts
dragon838843d_ragon
dragons938383d_ragons
drags75521113d_ra_gs
drails74716953d_rails
drains73719403d_rains
drakes114715863d_rakes
dramas95814653d_ramas
drams86025833d_ra_ms
drapes95419653d_rapes
drats66628373d_ra_ts
drawls105511393d_rawls
draws95119373d_ra_ws
drays95819773d_ra_ys
dreads84115023dread_s
droids84712583droid_s
drongos935493drongos
dryades12395633dryades
dryads11436623dryad_s
duads76515343d_uad_s
duras65727733dura__s
duros65422693dur__os
dyads10549973d_yad_s
dynamos1373853dynamos
extrados1645343extrados
fados95620733__fados
farads104713273farad_s
forages114217283forages
forams115115913fora_ms
forays124813003fora_ys
fordo97218653for_do_
fordoes11311963for_does
fords95328183for_d_s
foredo10510823foredo_
foredoes12310803foredoes
forzandos2242553forzandos
goads77022853go_ad_s
gonads84511733gonad_s
gorals76917653gora_ls
grades84926313_grades
grads75625753_grad_s
gradus84411223_gradus
hoards104912623hoard_s
hodads1147963hodad_s
horahs126313873hora_hs
horas86333103hora__s
hordes104921633hor_des
intrados946563intrados
irades74517393_irades
jorams154810533jora_ms
jordans1566833jordans
koras95927113kora__s
korats105416063kora_ts
loads65323373lo_ad_s
lorans65117603lora_ns
lords64923503lor_d_s
mikados1444683mikados
mirador1046503mirador
miradors1146853miradors
monades103713823monades
monads94515303monad_s
mondos95217333mo_ndos
morales93619403morales
morals85324633mora_ls
moras76438783mora__s
morass84614503mora_ss
morays114613883mora_ys
morphos14159083morphos
morros83714673mor_ros
nomads94711603nomad_s
noyades1136563noyades
odorants946043odorants
ooralis7312553ooralis
orad56031693_orad__
orals55826483_ora_ls
orangs74116033_orangs
orates64328613_orates
orator6314533_orator
orators7313823_orators
ordo54622353_or_do_
oreads73915773_oread_s
orzos143311253_or_zos
parades104121463parades
parador103311413parador
paradors113411903paradors
paradox17358173paradox
paramos113213513paramos
parodos103011753parodos
pomades123711733pomades
pornos85015253por_nos
posadas1037193posadas
praos74923563_pra_os
radios74018673__radios
radon64620503__radon
radons74118533__radons
rads56046603__rad_s
ratos55528763__ratos
redos65126763__redos
reredos838633reredos
roadeos837413ro_adeos
roads66523623ro_ad_s
robalos937683robalos
romanos94311483romanos
rondos74616733ro_ndos
solanos74412853solanos
sopranos1046433sopranos
soras55041013sora__s
sordor7310223sor_dor
sordors8310013sor_dors
sords64527803sor_d_s
sorghos11327603sorghos
sorgos74514663sor_gos
teredos839183teredos
tirades8311723tirades
toads65621073to_ad_s
toledos8388863toledos
tondos75115923to_ndos
torahs95115643tora_hs
toras55540373tora__s
toreador945003toreador
toreadors1045153toreadors
toreros7311343toreros
tornado845673tornado_
tornadoes1044293tornadoes
toros54336193tor__os
torpedos1143933torpedos
torsades937213torsades
torsos64815733tor_sos
tostados995073tostados
touracos1045313touracos
trades75724503_trades
turacos938643turacos
uredos73910623_uredos
viragos1146713viragos
woads94818443wo_ad_s
words95425073wor_d_s
worlds10568733world_s
zocalos1835393zocalos

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.830215290.4
2DLD Change Limit1340272358.29616155.6
3Display Results2352350.0802937.5
 (SQL Overall)1786912359.20619410.3
 
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.