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

162 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
picketed1716738(None) 
packeted17148281packeted
picketer16187431picketer
pocketed17147141pocketed
ticketed15146641ticketed
bickered17108002bickered
bucketed1736762bucketed
cricketed1854692cricketed
dickered16117532dickered
docketed16156582docketed
jacketed22146532jacketed
nickeled15115512nickeled
nickered15117022nickered
pickaxed2443512pickaxed
picked154421312pick__ed
pickeer153710112picke_er
pickeered1843462pickeered
pickerel1645272pickerel
picket144924312picket__
picketers17196482picketers
pickets154314182picket_s
pickled164011882pick_led
picoted1239212pic_oted
picrated132110112picrated
pinkened1535752pinkened
pocketer16157372pocketer
puckered1736102puckered
racketed15169122racketed
rocketed15157792rocketed
sickened1546782sickened
socketed15177342socketed
thicketed1943612thicketed
accreted1336333accreted
bickerer16106783bickerer
billeted1137643billeted
bracketed1855863bracketed
cacheted16148233cacheted
casketed1534953casketed
chickened2144623chickened
cockered17710213cockered
cockeyed2096123cockeyed
cricketer1744573cricketer
crocketed1845123crocketed
dackered16116893dackered
dicked144920863dick__ed
dictated1239203dictated
dieted83115493di__eted
excreted1846153excreted
faceted13509563fac_eted
fidgeted1443893fidgeted
fileted1159093fi_leted
filleted1236603filleted
flickered1943753flickered
gibbeted1492783gibbeted
gimleted1243973gimleted
isleted837523_isleted
jockeyed2563413jockeyed
junketed2033523junketed
kicked124415943kick__ed
lackered15108683lackered
lackeyed18104513lackeyed
lichened1435753lichened
lichted13268803lic_hted
licked134621563lick__ed
likened12267353li_kened
marketed1537323marketed
nicked135019683nick__ed
nickelled1653793nickelled
nickled144010443nick_led
nictated1137793nictated
packaged18115753packaged
packed154822603pack__ed
packet144726503packet__
packets155114773packet_s
palleted1139873palleted
pargeted1238683pargeted
pecked155019103peck__ed
pelleted1138203pelleted
picante11310523picante_
pickaxe2244623pickaxe_
pickaxes2344913pickaxes
pickeers16347243pickeers
picker144422173pick__er
pickerels1743723pickerels
pickers153718093picke_rs
picketing1835683picketing
pickier153912973pick_ier
pickle144215653pick_le_
pickles153215443pick_les
picometer1548913picometer
picotee11311473pic_otee
picotees1247113picotees
picrate112014143picrate_
picrates122013213picrates
picrite111911313picrite_
picrites121811083picrites
pictured1346573pictured
pieced113912103pi__eced
pigmented1544063pigmented
pigweed1465093pigwe_ed
piked125623313pi_k__ed
pikemen1535333pi_kemen
pileated112711133pileated
pilfered1435853pilfered
piloted10310323pi_loted
pinked134819883pink__ed
pinkeye16326493pinkeye_
pinkeyes17335973pinkeyes
pinnated11338553pinnated
pinweed1346933pinwe_ed
pipetted1335263pipetted
pirated102515613pi_rated
pitted94319593pi__tted
pivoted1336513pi_voted
plicated13310643plic_ated
pocked154818983pock__ed
pocket144622623pocket__
pocketers17196493pocketers
pockets154612253pocket_s
pricked164613833prick__ed
pricket153616443pricket__
prickets16329083pricket_s
prickled17358073prick_led
puckerer1645793puckerer
quickened2543163quickened
racheted14149503racheted
richened1435953richened
ricked136523623rick__ed
ricketier15134583ricketier
rickets134915093ricket_s
rickety16478313ricket_y
riveted11258573ri_veted
rocketer14158333rocketer
sacheted14127833sacheted
secreted1138643secreted
shickered19115723shickered
sickbed16396823sick_bed
sicked134524403sick__ed
sickee124622223sicke_e_
sickees134514213sicke_es
sickener1436603sickener
sickled144713433sick_led
sicklied1546583sicklied
signeted1035973signeted
slickened1644293slickened
snickered16115343snickered
spicated13309903spic_ated
suckered1537833suckered
thickened1944303thickened
ticked134720523tick__ed
ticket124524853ticket__
tickets134113683ticket_s
tickled144313133tick_led
tickseed1584513tickseed
tinkered1387683tinkered
trinketed1444253trinketed
tuckered1535963tuckered
whickered22114033whickered
wicked164317413wick__ed
wickeder1843983wickeder
wicket155318943wicket__
wickets164010943wicket_s

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.420425454.8
2DLD Change Limit1461621627.23620199.3
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.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.