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 “packed” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

216 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
packed15482260(None) 
backed155725721backed
hacked164923511hacked
jacked204817521jacked
lacked135324651lacked
paced106931681pac_ed
packer144223401packer
packet144726501packet
paiked135113431paiked
parked134425141parked
pecked155019101pecked
picked154421311picked
pocked154818981pocked
racked134526081racked
sacked135525211sacked
tacked134723941tacked
yacked164516791yacked
aced79540882_ac_ed
ached119227832_ached
ackee115825372_ackee
acned87520672_acned
acred87126352_acred
acted88521732_acted
arcked136211942arcked
asked106919312_asked
bached145519892bached
backer144525522backer
baked126130772ba_ked
balked135219412balked
banked135021442banked
barked135027312barked
basked135218602basked
becked155417762becked
blacked163613372blacked
bucked155121062bucked
cached145419202cached
cackled164613302cackled
caked126128622ca_ked
calked134617402calked
carked134024822carked
casked134815512casked
clacked164113602clacked
cocked155022562cocked
cracked163514742cracked
dacker134920752dacker
darked123919632darked
decked145217622decked
dicked144920862dicked
docked145018332docked
ducked144718012ducked
faced117727652fac_ed
faked135225482fa_ked
flacked173711582flacked
fucked164114482fucked
gawked15468762gawked
gecked146911932gecked
hackee154921832hackee
hacker154822692hacker
hackled173312492hackled
hanked144220602hanked
harked145422552harked
hawked174712672hawked
hocked165521302hocked
jacker194417582jacker
jacket194720672jacket
jauked18489012jauked
kecked125113172kecked
kicked124415942kicked
knacked13287792knacked
laced87132642lac_ed
lacker125325622lacker
lackey154813352lackey
laked105731122la_ked
larked114519472larked
licked134621562licked
locked134921662locked
lucked135118022lucked
maced108528692mac_ed
mackled164111922mackled
macled116718112macled
marked133921622marked
masked134316522masked
mocked154716612mocked
mucked153816092mucked
nacred95212492nacred
naked105320852na_ked
narked114116742narked
necked134715062necked
nicked135019682nicked
nocked134617382nocked
pace86345772pac_e_
pacer96131612pac_er
paces96741112pac_es
pacey126720282pac_ey
pacier105018682pacier
pack125535442pack__
packaged18115752packaged
packers153818892packers
packeted17148282packeted
packets155114772packets
packly17228332packly
packmen1746312packmen
packs135528932pack_s
padded114113502padded
paged95926782pa_ged
pained95622852pained
paired95017522paired
paled85538722pa_led
palled94625162palled
palmed114314642palmed
palped114513642palped
pancaked1734892pancaked
paned85437182pa_ned
panged104722332panged
panicked1785172panicked
panned94123432panned
panted95024822panted
parched154013692parched
pared86946762pa_red
parged104922042parged
parker124121372parker
parled94626292parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pashed125923142pashed
passed94320942passed
pasted94426902pasted
patched153514622patched
pated85237842pa_ted
patted94724682patted
paused95114962paused
paved115525262pa_ved
paveed12438892paveed
pawed115725612pa_wed
pawned124513282pawned
payed115925932pa_yed
peaced115818912peac_ed
peached154315882peached
peaked136117402peaked
peched144915342peched
pecker144615362pecker
peeked134314582peeked
perked134617692perked
picker144422172picker
picket144924312picket
pickled164011882pickled
piked125623312p_iked
pinked134819882pinked
placed114318002plac_ed
placket15412872placket
planked143512282planked
plucked16367962plucked
poached154212402poached
pocket144622622pocket
poked125425392p_oked
porked134717622porked
pranked143712092pranked
pricked164613832pricked
pucker143817632pucker
puked124716222p_uked
quacked2336792quacked
raced87635312rac_ed
racker124824552racker
racket125229422racket
raked105831422ra_ked
ranked114620742ranked
recked134821802recked
repacked17188742repacked
ricked136523622ricked
rocked135022322rocked
rucked134718762rucked
sacker125124842sacker
sacred94917102sacred
shacked174015392shacked
sicked134524402sicked
slacked143815452slacked
smacked163710992smacked
snacked144013112snacked
socked134721502socked
spaced114517252spac_ed
spackled17297802spackled
spanked143111732spanked
sparked143513142sparked
specked16329012specked
stacked143416122stacked
sucked134120492sucked
swacked173110522swacked
tacker124224502tacker
tacket124627492tacket
tackey154613082tackey
tackled143913192tackled
talcked1446342talcked
talked114015402talked
tanked113919292tanked
tasked114714642tasked
thacked173810202thacked
ticked134720522ticked
tracked143716132tracked
tucked134017492tucked
unpacked17268662unpacked
wacke145918622wacke_
wacker154920122wacker
wackes154717712wackes
waked135626752wa_ked
walked145313782walked
wanked144517152wanked
warked144421212warked
wauked144210572wauked
whacked20458622whacked
wicked164317412wicked
wracked174110112wracked
yakked13366092yakked
yanked144312242yanked
yocked164114422yocked
yucked164013562yucked

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825512162.25036689.3
3Display Results2162160.0802700.0
 (SQL Overall)1786912162.67366850.4
 
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.