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

266 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
dotards93725(None) 
dotard839051dotard_
boards94616932bo_ards
boyards13399322boyards
costards113510802costards
cowards1339612cowards
dastards10278082dastards
dotages92311792dotages
dotardly1343842dotardly
doters74423912doter_s
hoards104912622ho_ards
holards1148432holards
leotards945302leotards
petards104311152petards
retards85015002retards
ritards8439942ritards
towards1138782towards
altars64518153altar_s
attars64515313attar_s
awards107113453_awards
bards87139643__bards
bastards113310313bastards
bayards13379683bayards
beards94116673_beards
board85523003bo_ard_
boars75229603bo_ar_s
boarts84716873bo_arts
boatyards1543963boatyards
bogarts1047743bogarts
bollards11339153bollards
bombards1536493bombards
botas75328783bota__s
boyard125411283boyard_
boyars115611983boyar_s
briards10398553briards
bustards11308513bustards
canards10311203canards
cards85137933__cards
chards125119733_chards
collards113310193collards
cords86030623co__rds
costard104113353costard_
costars94218013costar_s
cotans81317923cota_ns
cottars94412243cottar_s
coward12411673coward_
custards11338393custards
dads67442773d__a_ds
damars93815003damar_s
darbs85323263d__arbs
dares66146703d__ares
darks106727873d__arks
darns66927893d__arns
darts67635733d__arts
dastard9279703dastard_
dataries9314033dataries
datary10310243datar_y
daters74827373dater_s
daturas838783daturas
deads75726913d_ea_ds
dears65736883d_ear_s
debarks14388493debarks
debars94218043debar_s
debeards1235503debeards
decares102818533decares
dekares122710873dekares
demands114311413demands
demarks14339233demarks
denars74621433denar_s
deodands1144603deodands
deodaras1044693deodaras
deodars937623deodar_s
departs104310683departs
desands94810163desands
details84214043details
detains83716093detains
deters74724683deter_s
dewars105117073dewar_s
diehards1346213diehards
dinars75417563dinar_s
disarms1039043disarms
discards1238913discards
ditas65923673dita__s
doated84118183doated_
doats65224883do_a_ts
dobras94811913do_bras
dobros93910233do_bros
dockyards2042983dockyards
doctors1039993doctor_s
doers65225713do_er_s
dogcarts1243883dogcarts
dogears937513dogear_s
dollars83311023dollar_s
dolors75115313dolor_s
domains10510873domains
donas65926473dona__s
donates83217223donates
donors75115793donor_s
doodads1035093doodads
doors65022133do_or_s
dooryards1443263dooryards
dopants1038433dopants
dopas85019063dopa__s
dopers95522483doper_s
dorado838813dora_do
dorados938203dorados
dorks105724443do__rks
dorms85723843do__rms
dorps85419223do__rps
dorrs65520593do__rrs
dors56747603do__r_s
dosages92310803dosages
dosers75723633doser_s
dotage82711613dota_ge
dotal64919623dota__l
doted75227073dot_ed_
doter65428623doter__
dotes65836693dot__es
dots55647663dot___s
dotted84717523dotted_
dottels8327783dottels
dotters83715973dotters
dottles83912283dottles
dottrel834463dottrel
dottrels963493dottrels
dourahs11487253dourahs
douras75016723do_uras
dowers104523293dower_s
downwards1743833downwards
dozers164815423dozer_s
dreads84115023drea_ds
drears74614253drear_s
dryads11436623drya_ds
duads76515343d_ua_ds
dullards1045493dullards
dwarfs13436273d_warfs
dyads10549973d_ya_ds
echards1337963echards
fards96629843__fards
fords95328183fo__rds
forwards1537043forwards
foulards12266463foulards
goads77022853go_a_ds
goliards1045133goliards
gonads84511733gona_ds
gourds8108253go_urds
guards84611573_guards
hards96435653__hards
hazards2037463hazards
hoard94918313ho_ard_
hoars85925553ho_ar_s
hodads1147963hoda_ds
holard10410573holard_
hotbeds13315003hotbeds
hotrods1148283hotrods
innards837153innards
inwards1138343inwards
iotas54821113iota__s
izzards16143963izzards
jeopards1843683jeopards
jotas125717443jota__s
jowars16369653jowar_s
lards65331863__lards
leopards1144753leopards
leotard846193leotard_
liards75212613_liards
lizards17427613lizards
loads65323373lo_a_ds
lords64923503lo__rds
lotahs9479873lota_hs
lotas55926303lota__s
mazards1937703mazards
molars85517323molar_s
monads94515303mona_ds
monarda1046613monarda
monardas1145713monardas
mortars93411523mortar_s
motors84616603motor_s
mustards11297883mustards
nards65928463__nards
nomads94711603noma_ds
nonarts7311303nonarts
notaries8314933notaries
notary92310713notar_y
notates72817483notates
notecards1243553notecards
noters64021003noter_s
oars46846033_o_ar_s
octads987333octa_ds
onwards1137173onwards
ootids71110353oot_ids
ottars64112223ottar_s
outadds936203outadds
outwards1299123outwards
pards85634333__pards
petard95013803petard_
pochards1646853pochards
polars84419353polar_s
pollards11299523pollards
poniards1145823poniards
postcards1445733postcards
potages102416423potages
potshards1544053potshards
poulards11288233poulards
regards94112563regards
retard75018933retard_
rewards114813993rewards
ritard74812083ritard_
roads66523623ro_a_ds
roars55622243ro_ar_s
robands10219863robands
rotaries8315693rotaries
rotary92411303rotar_y
rotas54827723rota__s
rotates72819773rotates
rotors64917953rotor_s
sards64736183__sards
sataras7315063sataras
shards104319173_shards
sitars65417593sitar_s
soars54732513so_ar_s
sofars94712783sofar_s
solands84412343solands
sonars64818973sonar_s
sords64527803so__rds
souaris7312333souaris
sowars94318013sowar_s
stands75118053_stands
stares66038753_stares
stars55836573_star_s
starts65423123_starts
swards105415133_swards
tabards10310383tabards
tads57143943__ta_ds
tardo65321103__tardo
tardy94720463__tardy
tares57456563__tares
tarns56433953__tarns
taros55640823__taros
tarps76527123__tarps
tars46763953__tar_s
tarts57242023__tarts
tatars64619793tatar_s
tetrads82910193tetrads
toads65621073to_a_ds
tolars64817943tolar_s
totals63115163tota_ls
toters65026363toter_s
toward10311063toward_
turds65021693__turds
unitards945623unitards
upwards13135963upwards
vawards14457573vawards
visards11328153visards
vizards20377263vizards
votaress1144223votaress
votaries11312013votaries
votarist111012163votarist
votary12248333votar_y
voters95017443voter_s
wards97734403__wards
wizards20326403wizards
woads94818443wo_a_ds
woalds10427583wo_alds
words95425073wo__rds
yards95324613__yards

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.406440125.6
2DLD Change Limit1340272666.95319276.1
3Display Results2662660.0932860.2
 (SQL Overall)1786912667.45223978.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.