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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
jacketing234564(None) 
packeting1836851packeting
racketing1647871racketing
bracketing1945232bracketing
bucketing1835712bucketing
cacheting1737152cacheting
casketing1635382casketing
dackering1737392dackering
docketing1785412docketing
faceting1438782fac_eting
jacking214515262jack__ing
jockeying2663292jockeying
junketing2143092junketing
lackering1639382lackering
lackeying1934922lackeying
marketing1636512marketing
picketing1835682picketing
pocketing1875852pocketing
racheting1537792racheting
rejacketing2542412rejacketing
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
jabbering2134443jabbering
jacket194720673jacket___
jacketed22146543jacket_ed
jackets205011373jacket__s
jackstone2244383jackstone
jaculating2047303jaculating
jauking19418323jauk__ing
jaunting16328633ja_unting
lacewing1435843lac_ewing
lacking143821543lack__ing
lactating1239193lactating
mackling172710063mack_ling
marketings1743163marketings
nickeling1645393nickeling
nickering1636573nickering
packaging1945163packaging
packing164420723pack__ing
palleting1238743palleting
pargeting1338283pargeting
puckering1835883puckering
rabbeting1445183rabbeting
racketier15165423racketier
racking144323663rack__ing
ratcheting1643783ratcheting
sacking144122703sack__ing
secreting1279823secreting
sickening1635993sickening
slackening1744343slackening
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.843211970.3
2DLD Change Limit148641937.97018650.1
3Display Results93930.0462021.7
 (SQL Overall)178691938.85920170.6
 
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.