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

141 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
pocketed1714714(None) 
docketed16156581docketed
packeted17148281packeted
picketed17167381picketed
pocketer16157371pocketer
rocketed15157791rocketed
socketed15177341socketed
bucketed1736762bucketed
cockered17710212cockered
cockeyed2096122cockeyed
crocketed1845122crocketed
jacketed22146532jacketed
jockeyed2563412jockeyed
picketer16187432picketer
pocked154818982pock__ed
pocket144622622pocket__
pocketers17196492pocketers
pockets154612252pocket_s
puckered1736102puckered
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
cricketed1854693cricketed
crocheted1745313crocheted
dackered16116893dackered
dickered16117533dickered
docked145018333dock__ed
docket134721173docket__
dockets144412243docket_s
excreted1846153excreted
faceted13509563fac_eted
gorgeted1135353gorgeted
hocked165521303hock__ed
jockette2165033jockette
jockettes2254383jockettes
junketed2033523junketed
lackered15108683lackered
lackeyed18104513lackeyed
located103114183loc_ated
locked134921663lock__ed
locket123922473locket__
lockets134612203locket_s
lockstep1643813lockstep
marketed1537323marketed
mocked154716613mock__ed
monkeyed1844153monkeyed
nickeled15115513nickeled
nickered15117023nickered
nocked134617383nock__ed
ochered132610283_ochered
packaged18115753packaged
packed154822603pack__ed
packet144726503packet__
packets155114773packet_s
palleted1139873palleted
pargeted1238683pargeted
pecked155019103peck__ed
pelleted1138203pelleted
pickaxed2443513pickaxed
picked154421313pick__ed
pickeer153710113picke_er
pickeered1843463pickeered
pickerel1645273pickerel
picket144924313picket__
picketers17196483picketers
pickets154314183picket_s
pickled164011883pick_led
picoted1239213pic_oted
picrated132110113picrated
pinkened1535753pinkened
pocketful2052413pocketful
pocketing1875853pocketing
pockier153911603pock_ier
pointed103813983po_inted
poked125425393po_k__ed
pokeweed1842943po_keweed
polkaed1435323polk_aed
pollened1157783pollened
polluted1135433polluted
pommeled1543103pommeled
pondered126411293pondered
popeyed1535713po_peyed
porked134717623pork__ed
ported94223243po__rted
portered112311543portered
posited10511493po_sited
posted93722493po__sted
pothered142311043pothered
potted94624013po__tted
pottered112311663pottered
pouted94021393po__uted
powdered15256893powdered
powered132911643po_wered
proceed12310553proc_e_ed
proceeded1544103proceeded
procreated1546443procreated
puckerer1645793puckerer
racheted14149503racheted
rocked135022323rock__ed
rocket125425283rocket__
rocketeer15174493rocketeer
rocketers15186883rocketers
rocketry1744503rocketry
rockets134615363rocket_s
rockweed1843313rockweed
roqueted1834653roqueted
sacheted14127833sacheted
secreted1138643secreted
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.423422437.4
2DLD Change Limit1461621417.47019566.5
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.95622459.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.