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

150 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
cacheted1614823(None) 
racheted14149501racheted
sacheted14127831sacheted
accreted1336332accreted
cached145419202cach__ed
cachet134526412cachet__
cachets145014262cachet_s
carpeted1338952carpeted
casketed1534952casketed
cathected1744542cathected
catheter1338152catheter
crocheted1745312crocheted
faceted13509562fac_eted
jacketed22146532jacketed
machete14310882machete_
machetes1539632machetes
packeted17148282packeted
racketed15169122racketed
ratcheted1554782ratcheted
yachted1634852yach_ted
acceded1336103_acceded
accented13107773accented
accepted15105383accepted
accosted1345513accosted
accrete1137843accrete_
accretes1238113accretes
ached119227833_ach__ed
achene11313813_achene_
achenes12313493_achenes
achieved1743713_achieved
acted88521733_ac__ted
adhered1239233_adhered
baccated15148373baccated
bached145519893bach__ed
basseted1136743basseted
bracketed1855863bracketed
bucketed1736763bucketed
cache125122483cach__e_
cachectic1443203cachectic
cachepot1744993cachepot
caches137926913cach__es
cacheting1737153cacheting
cachexia2263583cachexia
cachexic2153543cachexic
cachexies2364163cachexies
cachexy2443283cache_xy
cackled164613303cac_kled
cacoethes1643623cacoethes
cambered15129003cambered
cameoed1238383ca_meoed
canceled13279403canceled
cancered132411553cancered
cankered153010223cankered
canted94825783ca__nted
cantered113415983cantered
capered123014043ca_pered
careened1139193careened
careered1139493careered
carted98631443ca__rted
caseated11310713caseated
cashed125124353cash__ed
cashiered1543403cashiered
catered103117773ca_tered
cathead1338753cathe_ad
catheters1437013catheters
cathexes2036273cathexes
catted95422473ca__tted
caudated1238063caudated
caveated1439133caveated
cavorted1435693cavorted
chapleted1743973chapleted
cheated134416343__cheated
chefed155010563__chefed
chested133811673__chested
chewed154415013__chewed
chuted124611843__chuted
ciphered1637053ciphered
closeted1135613closeted
coached153313843coach__ed
coacted123611613coac__ted
cockered17710213cockered
cockeyed2096123cockeyed
cocreated142710093cocreated
cohered133514693c_ohered
colleted113011663colleted
competed154113593competed
concreted1439413concreted
corseted11311473corseted
coshered14610293coshered
cosseted1178343cosseted
coveted133011523c_oveted
cricketed1854683cricketed
crocheter1645563crocheter
crocketed1845123crocketed
curveted1435293curveted
cyphered1934653cyphered
dackered16116893dackered
docketed16156583docketed
escheated1546273escheated
eschewed1743443eschewed
excreted1846153excreted
facete115014833fac_ete_
facetted1445743facetted
fathered151510433fathered
galleted1038213galleted
garreted1057523garreted
gathered13149373gathered
hachured1744393hachured
hatcheled1844223hatcheled
kashered1636403kashered
lackered15108673lackered
lackeyed18104513lackeyed
lactated1138863lactated
lanceted1137073lanceted
lappeted13255833lappeted
lathered121512323lathered
lechered1437523lechered
lichened1435753lichened
lichted13268803lich_ted
machined1637303machined
marketed1537323marketed
ochered132610283_ochered
palleted1139873palleted
pargeted1238683pargeted
picketed17167383picketed
pocketed17147143pocketed
rabbeted1334443rabbeted
racemed1237013rac_emed
rachet115028973rachet__
rachets124516833rachet_s
rechewed1735633rechewed
richened1435953richened
ricocheted1852373ricocheted
rocketed15157793rocketed
sachet114725773sachet__
sachets123914103sachet_s
satcheled1544423satcheled
schemed1577753_schemed
secreted1138633secreted
socketed15177343socketed
tableted1137533tableted
targeted1037483targeted
ticketed15146643ticketed
tochered1437913tochered
tracheated1646333tracheated
unchewed1735803unchewed
vacated1349353vac_ated
valeted1139013va_leted
wauchted1753373wauch_ted
yachter1534913yach_ter

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621507.83018666.9
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.32921454.1
 
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.