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

154 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
socketed1517734(None) 
docketed16156581docketed
pocketed17147141pocketed
rocketed15157791rocketed
bucketed1736762bucketed
cockered17710212cockered
cockeyed2096122cockeyed
crocketed1845122crocketed
jacketed22146532jacketed
jockeyed2563412jockeyed
packeted17148282packeted
picketed17167382picketed
pocketer16157372pocketer
racketed15169122racketed
rocketer14158332rocketer
sacheted14127832sacheted
secreted1138632secreted
sickened1546782sickened
socked134721502sock__ed
socket123923522socket__
sockets134012982socket_s
sockeye1666412sockeye_
sockeyes1765762sockeyes
sonneted936182sonneted
suckered1537832suckered
ticketed15146642ticketed
accreted1336333accreted
bickered17108003bickered
bonneted1136223bonneted
bracketed1855863bracketed
cacheted16148233cacheted
casketed1534953casketed
cockaded1836393cockaded
cocked155022563cock__ed
cockerel16107113cockerel
cockeye1867223cockeye_
cockeyes1967033cockeyes
cockled163710823cock_led
cocreated142710093cocreated
colleted113011663colleted
competed154113593competed
concreted1439413concreted
corseted11311473corseted
cosseted1178343cosseted
coveted133011523co_veted
cricketed1854683cricketed
crocheted1745313crocheted
dackered16116893dackered
dickered16117533dickered
docked145018333dock__ed
docket134721173docket__
dockets144412243docket_s
excreted1846153excreted
faceted13509563fac_eted
gorgeted1135353gorgeted
hocked165521303hock__ed
jockette2165033jockette
jockettes2254383jockettes
junketed2033523junketed
lackered15108673lackered
lackeyed18104513lackeyed
located103114183loc_ated
locked134921663lock__ed
locket123922473locket__
lockets134612203locket_s
lockstep1643813lockstep
marketed1537323marketed
mocked154716613mock__ed
monkeyed1844153monkeyed
nickeled15115513nickeled
nickered15117023nickered
nocked134617383nock__ed
ochered132610283_ochered
picketer16187433picketer
pocked154818983pock__ed
pocket144622623pocket__
pocketers17196493pocketers
pockets154612253pocket_s
puckered1736103puckered
racheted14149503racheted
rocked135022323rock__ed
rocket125425283rocket__
rocketeer15174493rocketeer
rocketers15186883rocketers
rocketry1744503rocketry
rockets134615363rocket_s
rockweed1843313rockweed
roqueted1834653roqueted
sacked135525213sack__ed
scanted104114393s_canted
scarted104816123s_carted
scatted103512773s_catted
scented102811883s_cented
schemed1577753s_chemed
scooted103612283s_cooted
scouted104112033s_couted
screed95718933s_cre_ed
screwed135710663s_crewed
seceded11319203sec_eded
secrete9311073secrete_
secreter1038513secreter
secretes10410473secretes
sheeted113813043s_heeted
shickered19115723shickered
shocked174611813shock__ed
sickbed16396823sick_bed
sicked134524403sick__ed
sickee124622223sicke_e_
sickees134514213sicke_es
sickener1436603sickener
sickled144713433sick_led
sicklied1546583sicklied
signeted1035973signeted
skated114414883s__kated
skeed105018983s__ke_ed
skewed145610233s__kewed
skited114313483s__kited
skyrocketed205763skyrocketed
slackened1644243slackened
sleeted83113223s_leeted
slickened1644293slickened
smocked16398223smock__ed
snickered16115343snickered
snookered1443263snookered
snorkeled1442883snorkeled
soaked114717593soak__ed
sobered102912433so_bered
societal1045723societal
societies1148803societies
society1236083societ_y
socketing1666383socketing
sockmen1535453sock_men
soddened1144643soddened
softened1235663softened
sokemen1337053so_kemen
solated83618023so_lated
soldered1038153soldered
solvated12237443solvated
sonnetted1044543sonnetted
sooted73922593so__oted
sopited104211063so_pited
sorted74523713so__rted
sotted74121403so__tted
stockaded1743533stockaded
stocked144312873stock__ed
succeed1235983succe_ed
sucked134120493suck__ed
suckled144212513suck_led
thicketed1943613thicketed
tochered1437913tochered
toileted936993toileted
tokened1236393to_kened
tuckered1535963tuckered
yocked164114423yock__ed

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 Filter1786911461620.623286823.4
2DLD Change Limit1461621546.40622816.4
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.09225196.1
 
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.