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

143 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
picketer1618743(None) 
pickeer153710111picke_er
picketed17167381picketed
picketers17196481picketers
pocketer16157371pocketer
bickerer16106772bickerer
cricketer1744562cricketer
packeted17148282packeted
pickeers16347242picke_ers
picker144422172pick__er
pickerel1645272pickerel
picket144924312picket__
pickets154314182picket_s
pickier153912972pick_ier
picometer1548912picometer
pocketed17147142pocketed
pocketers17196492pocketers
puckerer1645792puckerer
ricketier15134582ricketier
rocketer14158332rocketer
sickener1436602sickener
ticketed15146642ticketed
wickeder1843982wickeder
bicker144819173bick__er
bickered17108003bickered
bickerers17115593bickerers
billeter1037563billeter
biometer1239603biometer
bucketed1736763bucketed
cricketed1854683cricketed
cricketers1843893cricketers
diameter1148063diameter
dicker134521403dick__er
dickered16117533dickered
dickier143512453dick_ier
dieter73516773di__eter
dimeter10411893di_meter
docketed16156583docketed
epicenter1395503epicenter
excreter1766123excreter
fickler16348423fick_ler
fidgeter1343783fidgeter
huckster1743823huckster
icker114018443_ick__er
ickier12439923_ick_ier
jacketed22146533jacketed
junketer1943713junketer
kicker114116183kick__er
kickier12349053kick_ier
licker125222043lick__er
marketer1437383marketer
mickler153310233mick_ler
nickeled15115513nickeled
nicker123818703nick__er
nickered15117023nickered
packager17136153packager
packer144223403pack__er
packet144726503packet__
packets155114773packet_s
pecker144615363peck__er
peckier153910523peck_ier
peter74427593p___eter
piaster93012883pi_aster
picante11310523picante_
pickaxe2244623pickaxe_
pickaxed2443513pickaxed
pickaxes2344913pickaxes
picked154421313pick__ed
pickeered1843463pickeered
pickerels1743723pickerels
pickers153718093picke_rs
picketing1835683picketing
pickle144215653pick_le_
pickled164011883pick_led
pickles153215443pick_les
picometers1648283picometers
picometre1546553picometre
picoted1239213pic_oted
picotee11311473pic_otee
picotees1247113picotees
picrate112014143picrate_
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite_
picrites121811083picrites
piecer105213083pi__ecer
pikemen1535333pi_kemen
piker115622843pi_k__er
pilaster1038163pilaster
pilferer1344923pilferer
pilsener1044753pilsener
pinaster1037113pinaster
pinkened1535753pinkened
pinker125322443pink__er
pinkeye16326493pinkeye_
pinkeyes17335973pinkeyes
pinsetter1145013pinsetter
pioneer936893pione_er
pocket144622623pocket__
pockets154612253pocket_s
pockier153911603pock_ier
pricker154013413prick__er
pricket153616443pricket__
prickets16329083pricket_s
prickier16368143prick_ier
pricklier17245063pricklier
pucker143817633puck__er
puckered1736103puckered
puckerers1744513puckerers
puckerier1754313puckerier
quickener2443123quickener
racketed15169123racketed
racketeer15174633racketeer
racketier15165413racketier
rickets134915093ricket_s
rickety16478313ricket_y
riveter10208753ri_veter
rocketed15157793rocketed
rocketeer15174493rocketeer
rocketers15186883rocketers
secreter1038513secreter
sickee124622223sicke_e_
sickees134514213sicke_es
sickened1546783sickened
sickeners1535733sickeners
sicker124023903sick__er
sicklier1457213sicklier
slickener1544043slickener
slickster1543413slickster
snickerer15134563snickerer
socketed15177343socketed
thickener1844163thickener
thicketed1943613thicketed
ticker124321503tick__er
ticket124524853ticket__
tickets134113683ticket_s
tickler133612653tick_ler
tinkerer1286803tinkerer
trickster15265703trickster
trinketer1344563trinketer
wicker154518673wick__er
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.436409841.7
2DLD Change Limit1461621436.59322169.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.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.