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

143 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
racketing164787(None) 
bracketing1945231bracketing
jacketing2345641jacketing
packeting1836851packeting
racheting1537791racheting
rocketing1666971rocketing
bucketing1835712bucketing
cacheting1737152cacheting
casketing1635382casketing
cricketing1944032cricketing
dackering1737382dackering
docketing1785412docketing
faceting1438782fac_eting
lackering1639372lackering
lackeying1934922lackeying
marketing1636512marketing
picketing1835682picketing
pocketing1875852pocketing
rabbeting1445182rabbeting
racketier15165412racketier
racking144323662rack__ing
ratcheting1643782ratcheting
rejacketing2542412rejacketing
socketing1666382socketing
ticketing1635632ticketing
acceding1446093_acceding
accenting1487823_accenting
accepting1695803_accepting
accreting1446333accreting
acetin8314693_ac_etin_
acetins9313173_ac_etins
acting95920983_ac__ting
arcking145811963arck__ing
backbiting2144293backbiting
backdating2045713backdating
backing165523443back__ing
backswing2144903backswing
basseting1236153basseting
bickering1837663bickering
blackening1944793blackening
blanketing1743323blanketing
cackling172610943cack_ling
cankering162110793cankering
carpeting1439483carpeting
cockering1839693cockering
cracking174013903crack__ing
crackling18157003crack_ling
crocheting1844703crocheting
daikering1536103daikering
darkening1535683darkening
dickering1737463dickering
excreting1946433excreting
facetting1535283facetting
galleting1137623galleting
hacking173720613hack__ing
hackling183310163hack_ling
hackneying2342443hackneying
hankering17239383hankering
harkening1746923harkening
jacking214515263jack__ing
jockeying2663293jockeying
junketing2143093junketing
lacewing1435843lac_ewing
lacking143821543lack__ing
lactating1239183lactating
mackling172710063mack_ling
marketings1743163marketings
nickeling1645393nickeling
nickering1636573nickering
packaging1945163packaging
packing164420723pack__ing
palleting1238733palleting
pargeting1338283pargeting
puckering1835883puckering
rabbiting1445033rabbiting
racing95030533rac___ing
racket125229423racket___
racketed15169123racket_ed
racketeer15174633racketeer
racketeering1951763racketeering
racketiest1643903racketiest
rackets134916873racket__s
rackety16499113racket__y
radiating111112123radiating
rafting113815753ra__fting
ragouting1134893ragouting
raking114728423ra_k__ing
ranking124320883rank__ing
rankling132610113rank_ling
ranting84025413ra__nting
rappeling1435963rappeling
rating74938703ra___ting
rattening10288763rattening
ratting83822363ra__tting
raveling123414373ra_veling
ravening122611293ra_vening
razeeing1834363ra_zeeing
reacceding1644223reacceding
reaccenting1665013reaccenting
reaccepting1863893reaccepting
reacting113317893reac__ting
recanting122414823recanting
recasting122414233recasting
receding122713763rec_eding
rechewing1836493rechewing
reciting113118073rec_iting
recking144319923reck__ing
reckoning1637643reckoning
recoating121317463recoating
recrating121318793recrating
recreating131214583recreating
recutting1239483recutting
rekeying1637563r_ekeying
remarketing1843713remarketing
remeeting12311433remeeting
richening1546223richening
ricketier15134583ricketier
ricking143920233rick__ing
riveting12139443r_iveting
rocking143619633rock__ing
rockling15259383rock_ling
roqueting1944603roqueting
rucking143216673ruck__ing
ruckling15258573ruck_ling
russeting1065323russeting
sacking144122703sack__ing
secreting1279823secreting
sickening1635993sickening
slackening1744343slackening
suckering1638103suckering
tableting1236353tableting
tacking144421483tack__ing
tackling153211123tack_ling
targeting1137303targeting
tracking153715463track__ing
trinketing1544153trinketing
tuckering1635693tuckering
vacating14310353vac_ating
valeting1238843va_leting
wakening1636323wa_kening
wracking18349963wrack__ing
yachting1734933yac_hting
yacking174315683yack__ing

Search took 7 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 Limit1486411436.26323733.2
3Display Results1431430.0801787.5
 (SQL Overall)1786911436.79626293.6
 
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.