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

134 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
docketed1615658(None) 
pocketed17147141pocketed
rocketed15157791rocketed
socketed15177341socketed
bucketed1736762bucketed
cockered17710212cockered
cockeyed2096122cockeyed
crocketed1845122crocketed
dackered16116892dackered
dickered16117532dickered
docked145018332dock__ed
docket134721172docket__
dockets144412242docket_s
jacketed22146532jacketed
jockeyed2563412jockeyed
packeted17148282packeted
picketed17167382picketed
pocketer16157372pocketer
racketed15169122racketed
rocketer14158332rocketer
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
daikered1495223daikered
darkened1435943darkened
decanted122310493decanted
decked145217623deck__ed
decocted1437683decocted
decreed112710253decre_ed
deleted93314913d_eleted
depleted12258723depleted
dicked144920863dick__ed
dictated1239203dictated
dieted83115493d__ieted
doated84118183do__ated
docetic1239913doc_etic
dockage1535723dockage_
dockages1635983dockages
docker134417653dock__er
dockers143715003docke_rs
docketing1785413docketing
dockhand1953393dockhand
dockland1643713dockland
dockside16154743dockside
dockyard1943283dockyard
doctored1245613doctored
documented1653203documented
doddered1234943doddered
doited85016633do__ited
donated93513863do_nated
donnered10307753donnered
dormered1255673dormered
doted75227073do___ted
dotted84717523do__tted
doubted11307483do_ubted
dovened12389063do_vened
doweled12269773do_weled
dowered122811553do_wered
dozened18377453do_zened
ducked144718013duck__ed
duckweed1943023duckweed
ducted104012123duc__ted
dueted84113593d__ueted
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
sacheted14127833sacheted
secreted1138633secreted
sickened1546783sickened
socked134721503sock__ed
socket123923523socket__
sockets134012983socket_s
sockeye1666413sockeye_
sockeyes1765763sockeyes
sonneted936183sonneted
suckered1537833suckered
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.453394461.4
2DLD Change Limit1461621347.20320291.8
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.71923149.5
 
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.