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

195 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
bedecks163579(None) 
bedeck1536211bedeck_
becks135522012b__ecks
bedecked1874572bedecked
bedells10379362bedells
bedels94015272bede_ls
bedews12398942bede_ws
bedrocks1745332bedrocks
bedticks1774162bedticks
beflecks1943752beflecks
bemocks1735372bemocks
decks124822192__decks
medicks16368412medicks
rebecks15288012rebecks
rednecks1544012rednecks
redocks14409932redocks
zebecks24274192zebecks
aedes64625153aede__s
backs135729623b__acks
beaders104120183beade_rs
beaks115326623b__eaks
beck126226573b__eck_
bedamns1235733bedamns
bedaubs1233693bedaubs
bedbugs13193503bedbugs
bedders113513383bedders
bedecking1934283bedecking
bedel84219403bede__l
bedell93610043bede_ll
bedeman12168843bedeman
bedemen12910183bedemen
bedevil1344513bedevil
bedevils1444373bedevils
bedew114513043bede__w
bedewed1437153bedewed
bedims1149593bed_ims
bedlams1237053bedlams
bedless1039703bedless
bedlike14369533bedlike
bedpans1237173bedpans
bedrock1645643bedrock_
bedrugs11194283bedrugs
beds75937783bed___s
bedsits1037563bedsits
bedtick1645233bedtick_
beduins1039123beduins
bedumbs1433633bedumbs
bedunces1345513bedunces
beech124315503be_ec_h
beeches143413883be_eches
beechy16397503be_echy
beedies10314203beedies
beefs105618563be_e_fs
beeps95320973be_e_ps
beers75628393be_e_rs
bees65453383be_e__s
beets76131443be_e_ts
beeves114615043be_eves
befleck1843943befleck_
begets96215523bege_ts
beheads1338523beheads
behests1235953behests
bejesus1643693bejesus
beleaps1138053beleaps
belleeks1444363belleeks
belowdecks225653belowdecks
bemeans1148743bemeans
bemock1636173bemock_
bendees103913863bende_es
benders104021063bende_rs
benedicks1842563benedicks
benes75536233bene__s
berets85822523bere_ts
berks115423123b__erks
berserks1433993berserks
beseems1175913beseems
beses75830723bese__s
besets85718803bese_ts
bespeaks1643963bespeaks
betels84515063bete_ls
bevels113913983beve_ls
beweeps1494563beweeps
beyliks1634853beyliks
bezels173712283beze_ls
biders94822803bide_rs
bides85536773bide__s
bidets95215533bide_ts
bipacks1745043bipacks
bisects1137133bisects
blacks144914953b_lacks
bleaks125112433b_leaks
blocks144513943b_locks
bocks134526573b__ocks
bodegas1135483bodegas
bodes84935103bode__s
bodices12710593bodices
breaks124816423b_reaks
bredes94818473brede__s
breeks125310793b_reeks
bricks144614623b_ricks
brocks145214153b_rocks
bucks134824293b__ucks
burdocks1744033burdocks
ceders93817673cede_rs
cedes84927333cede__s
checks174912703_checks
codecs115112933codec_s
copecks1745873copecks
debeaks1436103debeaks
deck115827753__deck_
decos85522123__decos
deduces1168793deduces
deducts1166593deducts
defects134511523defects
dejects17389223dejects
desks105913073__desks
detects104011093detects
deticks1437353deticks
dicks125824693__dicks
docks126022313__docks
drecks13459203_drecks
ducks124823213__ducks
edemas9310503_edemas
edicts94911703_edicts
educes94011953_educes
educts9439893_educts
ejects15409953_ejects
elects83315003_elects
erects84116183_erects
execs14539723_exec_s
fecks145417853__fecks
fedexes1835473fedexes
flecks154310803_flecks
foredecks1973383foredecks
gecks125117093__gecks
geeks104915843ge_e_ks
geoducks1642283geoducks
gweducks1941443gweducks
hecks145220653__hecks
heders104119763hede_rs
henpecks1942873henpecks
kecks105416573__kecks
keeks84717253ke_e_ks
kopecks1433073kopecks
leeks95318893le_e_ks
medick154010133medick_
medicos12339833medicos
medics114115353medic_s
necks115119333__necks
oedemas1056693oedemas
overdecks1944573overdecks
pecks135724433__pecks
pedes85327293pede__s
peeks115021113pe_e_ks
rebeck14419913rebeck_
rebecs103913673rebec_s
rechecks1944553rechecks
recks115625133__recks
recocks154711463recocks
redacts10510943redacts
redears82814453redears
redeems1037163redeems
redes65139133rede__s
redeyes112910973redeyes
redneck1445113redneck_
redock134311543redock_
reduces10513343reduces
reeks94124033re_e_ks
refects124012743refects
rejects163910693rejects
relocks134411293relocks
repacks15269543repacks
reperks13298093reperks
reracks132310533reracks
resects94115593resects
reseeks11348623reseeks
retacks132210713retacks
seders74420283sede_rs
seduces1069283seduces
seeks94724643se_e_ks
selects91912143selects
senecas939013senecas
snecks124410033_snecks
specks144312703_specks
sundecks1544253sundecks
undocks1436163undocks
wedelns11325243wedelns
wedels103811033wede_ls
wedlocks1844393wedlocks
weeks125017863we_e_ks
wrecks15418883_wrecks
xebecs17355363xebec_s
zebeck23255203zebeck_
zebecs19316183zebec_s
zydecos2241903zydecos

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.393454684.5
2DLD Change Limit1340271956.65620136.3
3Display Results1951950.0762565.8
 (SQL Overall)1786911957.12525079.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.