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

238 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
packness163693(None) 
backless162910632backless
blackness1735662blackness
dankness13256692dankness
darkness13247342darkness
hackneys2033682hackneys
laciness102112552laciness
lankness12237042lankness
packers153818892pack_ers
packets155114772pack_ets
packnesses1856622packnesses
paleness10312982paleness
pastness102510502pastness
patness92912282pa_tness
pawkiness1835442pawkiness
pickiness1737622pickiness
pinkness1436512pinkness
raciness102413452raciness
rankness12267942rankness
sickness1437832sickness
slackness1535432slackness
spaciness1337082spaciness
tackiness1557692tackiness
tackless14419482tackless
wackiness1836522wackiness
access1037673_ac_cess
achiness1339703_achiness
acidness1136723_acidness
ackees124914573_ack_ees
acnes75922623_ac_ne_s
actress948533_actress
apartness1146053apartness
aptness9268573_aptness
archness1337513archness
backers153821883back_ers
backrest1639393backrest
backrests1744983backrests
backsets1638853backsets
badness1039573ba_dness
baldness1137043baldness
balkiness1556903balkiness
bareness10912813bareness
barkless14318023barkless
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
blankness1544673blankness
cacklers163710703cacklers
cackles153717203cackle_s
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
cockiness17248783cockiness
cockneys1934493cockneys
cracknels1743433cracknels
dackers143417043dack_ers
daftness1235533daftness
dampness1336073dampness
deaconess1245543deaconess
easiness8313043easiness
exactness1843623exactness
faceless13269173faceless
fairness1136563fairness
fanciness1437673fanciness
farness102912203fa_rness
fastness11238763fastness
fatness103311293fa_tness
feckless17225783feckless
frankness1655223frankness
gameness112810693gameness
gaminess112911053gaminess
gastness9278473gastness
gawkiness1734753gawkiness
gayness1136843ga_yness
hackees165014103hack_ees
hackers164619043hack_ers
hackies163418243hackie_s
hacklers173710303hacklers
hackles162917063hackle_s
hackney1935123hackne_y
haleness11312623haleness
halfness1435563halfness
hardness122411083hardness
harness102413933ha_rness
haziness20248513haziness
iciness938863_iciness
ickiness1436753_ickiness
jackass2034963jack_ass
jackers204214453jack_ers
jackets205011373jack_ets
jackies202912623jackie_s
jacklegs2233953jacklegs
jaconets1745613jaconets
laceless10239853laceless
lackers134120543lack_ers
lackeys16458263lack_eys
lacunes9159623lacune_s
lameness102612673lameness
lankiness1338053lankiness
larkiness1338113larkiness
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
luckiness1596573luckiness
luckless14265893luckless
mackles154415753mackle_s
madness10310073ma_dness
maleness10312313maleness
matiness102114743matiness
maziness19239543maziness
meekness1434303meekness
muchness1534073muchness
neckless14236433neckless
niceness1039843niceness
pacers105124543pac__ers
paces96741113pac__e_s
paciest112917803pac_iest
packagers18144683packagers
packages17138733packages
packed154822603pack_e_d
packer144223403pack_e_r
packet144726503pack_e_t
packings174310063packings
packmen1746313packme_n
packs135528933pack___s
painless10108343painless
paneless102611763paneless
panels84716523pa__nels
panes76148693pa__ne_s
panners93621273pa_nners
pannes85522853pa_nne_s
parceners1337453parceners
pardners11269193pardners
parkers133816873park_ers
partners102711133partners
passless10247223passless
pastiness112312353pastiness
pastless102411203pastless
patchiness1744933patchiness
pathless13138043pathless
patines95225763patine_s
patroness1137483patroness
pavanes123612653pavane_s
pawkiest17277883pawkiest
pawnees12298173pa_wnees
pawners124311073pa_wners
peakless14236673peakless
peartness1137773peartness
peckers153312673peck_ers
peckiest162711393peckiest
perkiness15209163perkiness
pertness10310093pertness
peskiness15216523peskiness
pickeers16347243pickeers
pickers153718093pick_ers
pickets154314183pick_ets
pickiest162712593pickiest
pickles153215443pickle_s
pipiness1238003pipiness
pixiness1736093pixiness
placeless1335613placeless
placidness1553303placidness
plackets1646583plack_ets
plainness1155183plainness
planeness1138153planeness
pluckiness1883823pluckiness
pockets154612253pock_ets
pockiest163412053pockiest
pokiness14219863pokiness
poorness1036353poorness
porkiness15249193porkiness
poshness1356643poshness
primness1276763primness
puckers153514673puck_ers
puniness101610273puniness
punkiness15226983punkiness
pureness101110183pureness
quickness2443723quickness
rackers134320453rack_ers
rackets134916873rack_ets
rankless12268233rankless
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
rawness1038153ra_wness
reckless14257973reckless
richness1337433richness
rockiness15237833rockiness
rockless14297293rockless
sackers133820223sack_ers
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
saneness82313723saneness
sauciness1138043sauciness
slickness1535903slickness
sockless14267793sockless
spaceless1335733spaceless
spackles16319943spackle_s
spareness1139863spareness
spiciness1347053spiciness
stackless1555933stackless
starkness1335963starkness
suchness1335763suchness
suckless14288823suckless
tacitness1134873tacitness
tackers134319623tack_ers
tackets134914363tack_ets
tackiest143112433tackiest
tacklers143010773tacklers
tackles133816523tackle_s
tactless10288463tactless
talkiness1356913talkiness
tallness837103tallness
tameness102411253tameness
tankless12267823tankless
tartness82210133tartness
tautness8217183tautness
thickness1844443thickness
trackless15246723trackless
vainness1136063vainness
vastness11257293vastness
wackes154717713wack_e_s
wackest164710863wack_est
wackiest172610273wackiest
waeness102512783wa_eness
wanness102610683wa_nness
wariness11313213wariness
warmness1337063warmness
waviness1437723waviness
waxiness1836723waxiness
weakness1535353weakness
wickless1736083wickless
yuckiness1874923yuckiness
zaniness1738663zaniness

Search took 9 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.1561145455.1
2DLD Change Limit1461622388.31317582.3
3Display Results2382380.1102163.6
 (SQL Overall)1786912388.57920828.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.