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

215 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
cenacle113912(None) 
cenacles1238021cenacles
centile94217182centile
coracle112011722coracle
debacle1237442debacle
enable83318482_enable
fenagle11197152fenagle
manacle11310282manacle
menace103216942menac_e
pentacle1239382pentacle
tenable93214492tenable
tenace82715692tenac_e
tentacle1037692tentacle
vernacle1345582vernacle
amenable1238863amenable
barnacle1245943barnacle
beadle93314683be_adle
beagle93612593be_agle
bename103316073bena_me
bendable131510853bendable
benzole1837133benzole
bernicle1245443bernicle
binnacle12325633binnacle
binocle1136483binocle
cable95329913c__able
cache125122483c__ache
cackle143416923c__ackle
calicle113111433calicle
calycle14245833calycle
canaille1048413canaille
canal75428043cana_l_
canaled103615553cana_led
canalled1139573canalled
canaller1038953canaller
canals84421663cana_ls
canape10913513cana_pe
cancel105316683can_cel
candle94321483can_dle
canticle1239703canticle
cantle84522153can_tle
capable13313363capable
caracole12310353caracole
carle74535703c__arle
cease75227653ce_a_se
cecal94619113ceca_l_
cecally1459393cecally
cellule936523cellule
cenote83715843cen_ote
cense75121403cen__se
censure92310603censure
cental84420963cental_
centals94317053centals
centare93113703centare
centiles103615813centiles
centime114513033centime
centre84316643cen_tre
centuple12164043centuple
cerate84829463cera_te
cercal10314123cercal_
cetane8315283ceta_ne
ceviche1744143ceviche
chance134617093chanc_e
chancel144011773chancel
chancre14348783chancre
chenille1354593chenille
chewable1835443chewable
chicle134312543c_hicle
cicale10314503cica_le
cineole91010003cineole
circle1039703c_ircle
citable11313463citable
cleanable1345203cleanable
cloacae1145233cloacae
codable12311663codable
coenact11311803coenac_t
coenacted1445803coenacted
coenacts1246403coenacts
coinable12311583coinable
concave1439363concave
condole102914953condole
condyle13247053condyle
console92715983console
coracles121811163coracles
cornicle1258783cornicle
crackle153611253c_rackle
cradle93313163c_radle
crankle133610063crankle
crenate93317113crena_te
crenelle1046333crenelle
crevalle1346163crevalle
cubicle1337003cubicle
curable112414513curable
cuticle1138233cuticle
cycle1239523c__ycle
debacles1335723debacles
deface123113863defac_e
deniable11312083deniable
denticle1137773denticle
eagle64219483_e_agle
enabled102510633_enabled
enabler9299363_enabler
enables92813123_enables
enact73525363_enac_t
enacted10310643_enacted
enacts84012973_enacts
enamel81210113_enamel
enate54428143_ena_te
encage93713503_encage
encase83714363_encase
enface112510353_enfac_e
enisle63412093_enisle
enlace82213233_enlac_e
ensile62616473_ensile
female11310553fema_le
fenagled13184853fenagled
fenagles12186083fenagles
fence105319913fen_c_e
finable122213623finable
finagle11238313finagle
finale94116763fina_le
funicle12237483funicle
ganache1346203ganache
gelable101710733gelable
gentile83515293gentile
gentle74014513gen_tle
getable101712553getable
hence104920043hen_c_e
hewable15177823hewable
lendable11169463lendable
lienable10188693lienable
linable92214343linable
macle96127003__macle
manacled1336453manacled
manacles1239523manacles
measle83513223me_asle
menaced122710093menaced
menacer112610883menacer
menaces112715523menaces
menage93216543mena_ge
menarche1545813menarche
mendable131510583mendable
minable112315073minable
miracle1138843miracle
monocle1139663monocle
nacre75715363__nacre
nuncle839363nun_cle
openable1247013openable
oracle84313293_oracle
ownable1237283ownable
panache1458423panache
panicle11129983panicle
peace95026083pe_ac_e
pedicle1238963pedicle
penal75228373pena_l_
penally121111763penally
penance11313443penance
pence94924453pen_c_e
pencel103812913pen_cel
penile82219603pen_ile
penoche1447033penoche
pensile92713543pensile
pentacles1338763pentacles
penuche1435943penuche
penuchle1543763penuchle
penuckle1643263penuckle
percale11314083percale
pinnacle12416963pinnacle
pinocle1138133pinocle
recycle1445343recycle
reface113616353refac_e
regale74821453rega_le
relace83122153relac_e
renail65020763renail_
renailed92512803renailed
renails74917263renails
renal55929503rena_l_
rename82718813rena_me
rentable101716333rentable
resale64025543resa_le
rescale93215473rescale
retable91820403retable
retackle1445043retackle
reticle94112623reticle
sanicle91210263sanicle
seance83716683seanc_e
seeable91113943seeable
senate63725143sena_te
sendable111612043sendable
senile63420213sen_ile
sewable121911173sewable
teazle15329553te_azle
tenably122210453tenably
tenaces92814513tenaces
tenacula1044493tenacula
tenail64516103tenail_
tenaille846803tenaille
tenails73713923tenails
tensile72612733tensile
tentacled1244953tentacled
tentacles1146713tentacles
treacle939973treacle
tunable92511313tunable
tunicle9308033tunicle
unable83819223_unable
uncle7317053_un_cle
vehicle15175253vehicle
venae85920983vena__e
venal85523213vena_l_
venally13119563venally
vendable14159693vendable
vendace1357363vendac_e
venule94411763ven_ule
vernacles1445073vernacles
vernicle1346433vernicle
vesicle12217923vesicle

Search took 7 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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272156.51320578.4
3Display Results2152150.0802687.5
 (SQL Overall)1786912156.73626527.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.