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 “racheting” 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
racheting153779(None) 
cacheting1737151cacheting
racketing1647871racketing
ratcheting1643781ratcheting
bracketing1945232bracketing
crocheting1844702crocheting
faceting1438782fac_eting
jacketing2345642jacketing
packeting1836852packeting
rabbeting1445182rabbeting
rechewing1836492rechewing
richening1546222richening
rocketing1666972rocketing
yachting1734932yach_ting
acceding1446093_acceding
accenting1487823_accenting
accepting1695803_accepting
accreting1446333accreting
acetin8314693_ac_etin_
acetins9313173_ac_etins
achieving1843303_achieving
aching126521973_ach__ing
acting95920983_ac__ting
adhering1338883_adhering
arching136216693arch__ing
archiving1844763archiving
atheling1249203_atheling
baching156017753bach__ing
basseting1236153basseting
brachiating1944433brachiating
bucketing1835713bucketing
caching156317503cach__ing
carpeting1439483carpeting
casketing1635383casketing
cathecting1844833cathecting
cheating144014523__cheating
chefing16359033__chefing
chewing163911143__chewing
chuting132910733__chuting
cricketing1944033cricketing
dackering1737383dackering
docketing1785413docketing
escheating1645883escheating
eschewing1893503eschewing
excreting1946433excreting
facetting1535283facetting
fathering161010093fathering
galleting1137623galleting
gathering1499463gathering
hachuring1845123hachuring
hatcheling1943693hatcheling
kashering1736253kashering
lacewing1435843lac_ewing
lackering1639373lackering
lackeying1934923lackeying
lactating1239183lactating
lathering13912253lathering
lechering1538443lechering
lichening1545673lichening
lichting14268513lich_ting
machining1746933machining
marketing1636513marketing
ochering14219393_ochering
palleting1238733palleting
parachuting1952513parachuting
pargeting1338283pargeting
picketing1835683picketing
pocketing1875853pocketing
rabbiting1445033rabbiting
rachet115028973rachet___
racheted14149503rachet_ed
rachets124516833rachet__s
rachitic1547593rachiti_c
rachitis1348353rachiti_s
racing95030533rac___ing
racketier15165413racketier
racking144323663rac__king
radiating111112123radiating
rafting113815753ra__fting
ragouting1134893ragouting
ranching141712043ranch__ing
ranting84025413ra__nting
rappeling1435963rappeling
rating74938703ra___ting
rattening10288763rattening
ratting83822363ra__tting
raveling123414373ra_veling
ravening122611293ra_vening
rawhiding1743113rawhiding
razeeing1834363ra_zeeing
reacceding1644223reacceding
reaccenting1665013reaccenting
reaccepting1863893reaccepting
reaching143317203reach__ing
reacting113317893reac__ting
recanting122414823recanting
recasting122414233recasting
receding122713763rec_eding
recharting1637213recharting
rechecking2244463rechecking
reciting113118073rec_iting
recoating121317463recoating
recrating121318793recrating
recreating131214583recreating
recutting1239483recutting
reheating132314913r_eheating
rejacketing2542413rejacketing
remeeting12311433remeeting
ricocheting1952373ricocheting
righting132610853righ_ting
riveting12139443r_iveting
roaching143210433roach__ing
roqueting1944603roqueting
ruching133612933ruch__ing
russeting1065323russeting
scheming1636633_scheming
secreting1279823secreting
socketing1666383socketing
tableting1236353tableting
targeting1137303targeting
ticketing1635633ticketing
tochering1537153tochering
trachling1537823trach_ling
vacating14310353vac_ating
valeting1238843va_leting
wauchting1843473wauch_ting
yachtings1842663yach_tings

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.436409841.7
2DLD Change Limit1486411277.65619415.0
3Display Results1271270.0632015.9
 (SQL Overall)1786911278.15521911.8
 
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.