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

196 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
cenacles123802(None) 
cenacle1139121cenacle_
centiles103615812centiles
coracles121811162coracles
debacles1335722debacles
enables92813122_enables
fenagles12186082fenagles
manacles1239522manacles
menaces112715522menac_es
pentacles1338772pentacles
tenaces92814512tenac_es
tentacles1146712tentacles
vernacles1445072vernacles
barnacles1355333barnacles
beaches144120653be_aches
beadles103414733be_adles
beagles103212123be_agles
benames112814603bena_mes
benches143918603ben_ches
benzoles1936993benzoles
bernicles1345403bernicles
binnacles13244583binnacles
binocles1236413binocles
cables104527553c__ables
caches137926913c__aches
cackles153717203c__ackles
calces104420053c__alces
calicles123811433calicles
calycles15295693calycles
canailles1148283canailles
canaled103615563cana_led
canalled1139583canalled
canaller1038953canaller
canallers1137213canallers
canals84421673cana_l_s
canapes111213083cana_pes
canaries10318943canaries
cancels114113313can_cels
candles104422343can_dles
canticles1339183canticles
cantles94721413can_tles
caracoles13310093caracoles
carles85435083c__arles
caules85927253c__aules
ceases84427073ce_a_ses
cellules1036813cellules
cenotes92814543cen_otes
censes83721803cen__ses
censures102211623censures
censuses10187543censuses
centals94317053cental_s
centares102913893centares
centeses1079443centeses
centile94217183centile_
centimes124012613centimes
centones10313663centones
centres93817123cen_tres
centuples13134333centuples
cerastes101111093cerastes
cerates95428253cera_tes
cetanes9315133ceta_nes
ceviches1834843ceviches
chancels15439093chancels
chances145218093chanc_es
chancres15429363chancres
chenilles1444373chenilles
chicles143512503c_hicles
cinches144215773cin_ches
cineoles10109403cineoles
circles1139903c_ircles
clenches152910953clen_ches
coaches144018693c_oaches
coenacted1445803coenacted
coenacts1246403coenac_ts
concaves1538913concaves
conches144019813con_ches
condoles113015803condoles
condyles14277463condyles
consoles103216153consoles
coracle112011723coracle_
cornicles1368253cornicles
crackles164111273c_rackles
cradles103114133c_radles
cranches153114543cranches
crankles143510163crankles
crenelles1146733crenelles
crevalles1455723crevalles
cubicles1435883cubicles
curacies12311763curacies
cuticles1237893cuticles
cycles1339303c__ycles
debacle1237443debacle_
defaces133213403defac_es
denticles1237753denticles
detaches1439653detaches
eagles73819163_e_agles
enable83318483_enable_
enabled102510633_enabled
enabler9299363_enabler
enablers10196913_enablers
enacted10310643_enacted
enacts84012973_enac_ts
enamels9128163_enamels
enates64026433_ena_tes
encages103313783_encages
encases93116053_encases
enfaces122110913_enfac_es
enisles72312603_enisles
enlaces92313393_enlac_es
ensiles72714833_ensiles
females12310663fema_les
fenagle11197153fenagle_
fenagled13184853fenagled
fences114617113fen_c_es
finagles12237553finagles
finales104016013fina_les
funicles13246833funicles
ganaches1437433ganaches
gentiles93713523gentiles
gentles83714343gen_tles
kenches163912273ken_ches
leaches123319343le_aches
legacies1139043legacies
lunacies1038013lunacies
macles107023223__macles
manacle11310283manacle_
manacled1336453manacled
measles92412753me_asles
menace103216943menac_e_
menaced122710093menac_ed
menacer112610883menac_er
menacers12279313menacers
menages103615393mena_ges
menarches1646683menarches
mensches1536303mensches
miracles1238333miracles
monocles12310673monocles
naches114622413__naches
nacres85614453__nacres
nuncles939843nun_cles
oracles93212423_oracles
panaches15310293panaches
panicles121010123panicles
peaces106324083pe_ac_es
peaches144120053pe_aches
pedicles1338683pedicles
penances12312443penances
penates93321603pena_tes
pencels113610063pen_cels
penoches1538933penoches
pentacle1239383pentacle_
penuches1536943penuches
penuchles1643763penuchles
penuckles1743243penuckles
percales12313803percales
pinnacles13276043pinnacles
pinocles1248693pinocles
reaches123423203re_aches
reales64934123re_a_les
recycles1535353recycles
refaces123216743refac_es
regales83520793rega_les
relaces93420883relac_es
renailed92512803renailed
renails74917263renail_s
renames92418053rena_mes
resales74724903resa_les
rescales103414573rescales
retables101712673retables
retackles1545363retackles
reticles103912483reticles
sanicles10149943sanicles
seances93015343seanc_es
senates73322613sena_tes
seniles72618023sen_iles
teaches122718353te_aches
teazles16308923te_azles
tenable93214493tenable_
tenace82715693tenac_e_
tenailles946323tenailles
tenails73713923tenail_s
tenancies1149173tenancies
tenches123515523ten_ches
tentacle1037693tentacle_
tentacled1244953tentacled
treacles1039703treacles
tunicles10217133tunicles
uncles8317163_un_cles
vehicles16204683vehicles
vendables15165153vendables
vendaces1457183vendac_es
venules104011483ven_ules
vernacle1345583vernacle_
vernicles1446133vernicles
vesicles13127073vesicles
wenches152914133wen_ches

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.423422437.4
2DLD Change Limit1461621967.51619446.8
3Display Results1961960.0802450.0
 (SQL Overall)1786911968.01922283.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.