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

122 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
rocketing166697(None) 
docketing1785411docketing
pocketing1875851pocketing
racketing1647871racketing
socketing1666381socketing
bracketing1945232bracketing
bucketing1835712bucketing
cockering1839692cockering
cricketing1944032cricketing
crocheting1844702crocheting
jacketing2345642jacketing
jockeying2663292jockeying
packeting1836852packeting
picketing1835682picketing
racheting1537792racheting
rocking143619632rock__ing
rockling15259382rock_ling
roqueting1944602roqueting
ticketing1635632ticketing
accreting1446333accreting
bickering1837663bickering
bonneting1236173bonneting
brokering1636283bro_kering
cacheting1737153cacheting
casketing1635383casketing
cocking163619983cock__ing
cockling172310393cock_ling
cocreating15310293cocreating
colleting12311063colleting
competing163712463competing
concreting1539873concreting
corseting12312173corseting
cosseting1239543cosseting
coveting141912303co_veting
crocking174313443crock__ing
croqueting2243173croqueting
dackering1737383dackering
dickering1737463dickering
docking153615013dock__ing
excreting1946433excreting
faceting1438783fac_eting
frocking18309573frock__ing
grommeting1642913grommeting
hocking173417243hock__ing
junketing2143093junketing
lackering1639373lackering
lackeying1934923lackeying
locating11311503loc_ating
locking143718153lock__ing
marketing1636513marketing
mocking163614453mock__ing
monkeying1944473monkeying
nickeling1645393nickeling
nickering1636573nickering
nocking143615113nock__ing
ochering14219393_ochering
pocking163916763pock__ing
proceeding1644673proceeding
procreating1647693procreating
puckering1835883puckering
rabbeting1445183rabbeting
racketier15165413racketier
racking144323663rack__ing
ratcheting1643783ratcheting
recanting122414823recanting
recasting122414233recasting
receding122713763rec_eding
rechewing1836493rechewing
reciting113118073rec_iting
recking144319923reck__ing
reckoning1637643reckoning
recoating121317463recoating
recrating121318793recrating
recreating131214583recreating
recutting1239483recutting
rejacketing2542413rejacketing
rekeying1637563r_ekeying
remeeting12311433remeeting
richening1546223richening
ricketier15134583ricketier
ricking143920233rick__ing
ricocheting1952373ricocheting
riveting12139443r_iveting
roasting93012703ro_asting
rockeries15128973rockeries
rocket125425283rocket___
rocketed15157793rocket_ed
rocketeer15174493rocketeer
rocketer14158333rocket_er
rocketers15186883rocketers
rocketries1645893rocketries
rocketry1744503rocket_ry
rockets134615363rocket__s
rocklings16224843rock_lings
rodeoing1037253ro_deoing
rogering10310273ro_gering
rogueing1054313rogue_ing
rooking123517363rook__ing
roosting93411463ro_osting
rooting83522433ro__oting
rotating92614553ro_tating
rotting82919683ro__tting
rouletting1144753rouletting
rousting93913273ro_usting
routing83821093ro__uting
roweling122811123ro_weling
rucking143216673ruck__ing
ruckling15258573ruck_ling
russeting1065323russeting
secreting1279823secreting
sickening1635993sickening
skyrocketing216823skyrocketing
socking143518603sock__ing
sonneting1037003sonneting
suckering1638103suckering
tochering1537153tochering
toileting1036263toileting
tokening1336463to_kening
trinketing1544153trinketing
trocking153612423trock__ing
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.420425454.8
2DLD Change Limit1486411227.11020905.9
3Display Results1221220.0631936.5
 (SQL Overall)1786911227.59323533.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.