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

124 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
cacheting173715(None) 
racheting1537791racheting
accreting1446332accreting
caching156317502cach__ing
carpeting1439482carpeting
casketing1635382casketing
cathecting1844832cathecting
crocheting1844702crocheting
faceting1438782fac_eting
jacketing2345642jacketing
packeting1836852packeting
racketing1647872racketing
ratcheting1643782ratcheting
yachting1734932yach_ting
acceding1446093_acceding
accenting1487823accenting
accepting1695803accepting
accosting1446733accosting
acetin8314693_ac_etin_
acetins9313173_ac_etins
achieving1843303_achieving
aching126521973_ach__ing
acting95920983_ac__ting
adhering1338883_adhering
atheling1249203_atheling
baching156017753bach__ing
basseting1236153basseting
bracketing1945233bracketing
bucketing1835713bucketing
cachectic1443203cachecti_c
cachet134526413cachet___
cacheted16148233cachet_ed
cachets145014263cachet__s
cachexia2263583cachexi_a
cachexias2363383cachexias
cachexic2153543cachexi_c
cachexies2364163cachexies
cackling172610943cac_kling
cageling12310843ca_geling
cambering16109873cambering
cameoing1379063ca_meoing
canceling14310163canceling
cankering162110793cankering
canoeing11310213canoe_ing
cantering122417373cantering
canting104725903ca__nting
capering132414963ca_pering
careening12310013careening
careering12311203careering
carpetings1544213carpetings
carting104228283ca__rting
caseating12311743caseating
cashiering1643783cashiering
cashing135022553cash__ing
casting104628343ca__sting
catching163712773catch__ing
catering112019903ca_tering
catting103922643ca__tting
caveating1539293caveating
cavorting1536063cavorting
cheating144014523__cheating
chefing16359033__chefing
chewing163911143__chewing
chuting132910733__chuting
ciphering17217703ciphering
closeting1236183closeting
coaching164011963coach__ing
coacting133412703coac__ting
cockering1839693cockering
cocreating15310293cocreating
cohering142413833c_ohering
colleting12311053colleting
competing163712463competing
concreting1539873concreting
corseting12312173corseting
coshering15510023coshering
cosseting1239543cosseting
coveting141912303c_oveting
cricketing1944033cricketing
curveting1535353curveting
cyphering20175243cyphering
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
pargeting1338283pargeting
picketing1835683picketing
pocketing1875853pocketing
rabbeting1445183rabbeting
rechewing1836493rechewing
richening1546223richening
ricocheting1952373ricocheting
rocketing1666973rocketing
scheming1636633_scheming
secreting1279823secreting
socketing1666383socketing
tableting1236353tableting
targeting1137303targeting
ticketing1635633ticketing
tochering1537153tochering
vacating14310353vac_ating
valeting1238843va_leting
wauchting1843473wauch_ting
yachtings1842663yach_tings

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.453394461.4
2DLD Change Limit1486411246.73622066.7
3Display Results1241240.0602066.7
 (SQL Overall)1786911247.24924650.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.