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

95 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
docketing178541(None) 
pocketing1875851pocketing
rocketing1666971rocketing
socketing1666381socketing
bucketing1835712bucketing
cockering1839692cockering
dackering1737382dackering
dickering1737462dickering
docking153615012dock__ing
jacketing2345642jacketing
jockeying2663292jockeying
packeting1836852packeting
picketing1835682picketing
racketing1647872racketing
ticketing1635632ticketing
accreting1446333accreting
bickering1837663bickering
bonneting1236173bonneting
bracketing1945233bracketing
cacheting1737153cacheting
casketing1635383casketing
cocking163619983cock__ing
cockling172310393cock_ling
cocreating15310293cocreating
colleting12311053colleting
competing163712463competing
concreting1539873concreting
corseting12312173corseting
cosseting1239543cosseting
coveting141912303co_veting
cricketing1944033cricketing
crocheting1844703crocheting
daikering1536103daikering
darkening1535683darkening
decanting132510633decanting
decking153915593deck__ing
decocting1538123decocting
decreeing1335523decreeing
dekeing13358353d_eke_ing
deleting103314423d_eleting
depleting1378193depleting
dicking153617613dick__ing
dictating1338883dictating
dieting93616833d__ieting
doating93816863do__ating
docetic1239913doc_eti_c
docket134721173docket___
docketed16156583docket_ed
dockets144412243docket__s
doctoring1346183doctoring
documenting1753123documenting
doddering1335183doddering
donating10311803do_nating
doting84821913do___ting
dotting93314483do__tting
doubting1237373do_ubting
dovening13238353do_vening
doweling13279763do_weling
dowering132510613do_wering
dozening19236183do_zening
ducking154315053duck__ing
duckling16247703duck_ling
ducting113713593duc__ting
dueting93814393d__ueting
excreting1946433excreting
faceting1438783fac_eting
hocking173417243hock__ing
junketing2143093junketing
lackering1639373lackering
lackeying1934923lackeying
locating11311503loc_ating
locking143718153lock__ing
marketing1636513marketing
mocking163614453mock__ing
monkeying1944473monkeying
nickeling1645393nickeling
nickering1636573nickering
nocking143615113nock__ing
ochering14219393_ochering
pocking163916763pock__ing
puckering1835883puckering
racheting1537793racheting
rocking143619633rock__ing
rockling15259383rock_ling
roqueting1944603roqueting
secreting1279823secreting
sickening1635993sickening
socking143518603sock__ing
sonneting1037003sonneting
suckering1638103suckering
tochering1537153tochering
toileting1036263toileting
tokening1336463to_kening
tuckering1635693tuckering
yocking173712373yock__ing

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 Filter1786911486410.423422437.4
2DLD Change Limit148641957.07621006.4
3Display Results95950.0462065.2
 (SQL Overall)178691957.54523683.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.