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

127 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
packeting183685(None) 
jacketing2345641jacketing
picketing1835681picketing
pocketing1875851pocketing
racketing1647871racketing
bracketing1945232bracketing
bucketing1835712bucketing
cacheting1737152cacheting
casketing1635382casketing
dackering1737392dackering
docketing1785412docketing
faceting1438782fac_eting
lackering1639382lackering
lackeying1934922lackeying
marketing1636512marketing
packaging1945162packaging
packing164420722pack__ing
palleting1238742palleting
pargeting1338282pargeting
puckering1835882puckering
racheting1537792racheting
rocketing1666972rocketing
socketing1666382socketing
ticketing1635632ticketing
acceding1446093_acceding
accenting1487833_accenting
accepting1695823_accepting
accreting1446333accreting
acetin8314693_ac_etin_
acetins9313173_ac_etins
acting95920983_ac__ting
backbiting2144293backbiting
backdating2045723backdating
backing165523443back__ing
backswing2144903backswing
basseting1236153basseting
bickering1837673bickering
blackening1944793blackening
blanketing1743323blanketing
cackling172610943cack_ling
cankering162110793cankering
carpeting1439483carpeting
cockering1839693cockering
cricketing1944033cricketing
daikering1536103daikering
darkening1535683darkening
dickering1737463dickering
excreting1946433excreting
facetting1535283facetting
galleting1137633galleting
hacking173720613hack__ing
hackling183310163hack_ling
hackneying2342443hackneying
hankering17239383hankering
harkening1746923harkening
jacking214515263jack__ing
jockeying2663293jockeying
junketing2143093junketing
lacewing1435843lac_ewing
lacking143821543lack__ing
lactating1239193lactating
mackling172710063mack_ling
marketings1743163marketings
nickeling1645393nickeling
nickering1636573nickering
pacesetting1652633pacesetting
pacifying2045503pacifying
pacing114522753pac___ing
packagings2042543packagings
packet144726503packet___
packeted17148293packet_ed
packets155114773packet__s
packings174310063pack__ings
paiking143814813paik__ing
painting113614423pa_inting
palpating1438543palpating
paltering122612903paltering
pampering1638383pampering
pandering133211963pandering
paneling111013633pa_neling
panting104025423pa__nting
papering132213313pa_pering
parceling1438443parceling
parenting12611583parenting
pargetings1443713pargetings
pargetting1444943pargetting
parking143423043park__ing
parleying1536113parleying
parqueting2243633parqueting
parroting1239153parroting
parting103527383pa__rting
pasting103826553pa__sting
patenting1248953patenting
pattering122314433pattering
patting103722343pa__tting
paupering1437273paupering
pecking164017783peck__ing
pelleting1237953pelleting
pickaxing2543103pickaxing
pickeering1943533pickeering
picking163418333pick__ing
pickling17239203pick_ling
picoting1338883pic_oting
pinkening1634993pinkening
placating1438513plac_ating
pocking163916763pock__ing
rabbeting1445183rabbeting
racketier15165423racketier
racking144323663rack__ing
ratcheting1643783ratcheting
rejacketing2542413rejacketing
sacking144122703sack__ing
secreting1279823secreting
sickening1635993sickening
slackening1744343slackening
spackling18266503spack_ling
suckering1638103suckering
tableting1236353tableting
tacking144421483tack__ing
tackling153211123tack_ling
targeting1137303targeting
tuckering1635693tuckering
vacating14310363vac_ating
valeting1238853va_leting
wakening1636323wa_kening
yachting1734933yac_hting
yacking174315683yack__ing

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411277.68619339.2
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.18521831.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.