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

224 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
cecally145939(None) 
caecally1547701caecally
cavally1588482cavally
cecal94619112ceca_l_
chally144314292c_hally
coevally1646282coevally
ducally13257412ducally
focally15188552focally
leally94012612le_ally
legally1138132legally
locally12179722locally
mesally12119792mesally
penally121111762penally
really93315612re_ally
recall83815722recall_
recalls92613622recalls
rectally1339712rectally
regally1159872regally
retally10413682retally
venally13119562venally
vocally15188342vocally
actually1366853actually
aerially11911913aerially
ally76935643___ally
anally9513503_anally
apically1539833apically
areally10411243areally
aurally10310543aurally
axially1737233axially
bally105530103__bally
banally1249223banally
basally1237963basally
becalm1239203beca_lm
becalms1335743becalms
befall114410643befall_
befalls12349123befalls
begall92610723begall_
begalls10319163begalls
belly104625493be__lly
buccally1744623buccally
caecal103713733caeca_l_
call66838673__call_
calla74827073__calla
calls75634733__calls
calmly1337613__calmly
capably1639253capably
carnally1339513carnally
casually1356823casually
catcall1139153catcall_
catcalls1238323catcalls
caudally1446463caudally
causally1356613causally
cavalla1257883cavalla
cavalry1554963cavalry
ceca84820783ceca___
cecity1398153cec_ity
cedary12419603ceda_ry
cedilla1036343cedilla
cell65031723ce__ll_
cella75420313ce__lla
celli76717693ce__lli
cello74919583ce__llo
cells75428063ce__lls
cenacle1139123cenacle
centrally1448893centrally
cercal10314123cerca_l_
chalky18468773c_halky
challa114014193c_halla
cheaply1735023cheaply
chemically2248313chemically
chilly144113223c_hilly
chorally1638103chorally
cicala10310053cica_la
cicalas1139303cicalas
cicale10314503cica_le
cicely1338833cic_ely
civically1946563civically
civilly1535483civilly
cleanly1236323cleanly
clearly1236663clearly
clerically1748193clerically
clinally1347233clinally
clonally1346693clonally
coaly105521593c_oa_ly
cockily1838493cockily
coequally2344033coequally
coitally1339483coitally
colly104926773__colly
comically18310523comically
conically16312813conically
coolly114811393c_oolly
costally1339723costally
coxalgy2042603coxalgy
crackly18397703crackly
crawly144610763c_rawly
crevalle1346163crevalle
crucially1645443crucially
cruelly1236563cruelly
cubically1846143cubically
cully105520463__cully
curably142010773curably
cynically1947253cynically
dally95324743__dally
deadly113811473de_adly
deafly13389123de_afly
dearly104615323de_arly
decal85523233deca_l_
decalog1136003decalog
decals93717713deca_ls
decay114718483deca__y
decimally1745613decimally
delly96023873de__lly
dentally121110063dentally
dually103210063_dually
early85324123_e_arly
epically15310583epically
equally1936873equally
evilly1236593_evilly
facially1637643facially
fatally1339893fatally
fealty122910223fe_alty
featly123711753fe_atly
fecal105119213feca_l_
feckly18335963fec_kly
felly114922803fe__lly
festally1437543festally
feudally1554823feudally
finally13310103finally
fiscally1646073fiscally
fugally1435603fugally
gally95026173__gally
genially12129523genially
genically151110173genically
gyrally1435583gyrally
helically1749433helically
icefall1254303icefall_
icefalls1344253icefalls
ideally1137793ideally
jelly154218253je__lly
jurally1736963jurally
kelly124617023ke__lly
laically1338983laically
lealty92910603le_alty
leanly93811503le_anly
lethally1445923lethally
levelly1335843levelly
lexically2146773lexically
loyally13126843loyally
mealy104422183me_a_ly
meanly115412043me_anly
measly113610443me_asly
medially14129323medially
medically17310113medically
menially131111093menially
mentally131010403mentally
mesially13119083mesially
mesically16310093mesically
misally121111063misally
modally1338403modally
morally12411493morally
nasally1057443nasally
navally1366473navally
nearly94813733ne_arly
neatly93812483ne_atly
nelly84618813ne__lly
neurally1137933neurally
nodally1137913nodally
orally93113593_orally
ovally12278443_ovally
pally105727123__pally
papally1437973papally
pearly116414843pe_arly
penalty1267743penalty
racially1339623racially
rally84725903__rally
rascally1347733rascally
realty92713693re_alty
recalled11310803recalled
recaller1039323recaller
recarry1245063recarry
refall94314393refall_
refalls103312243refalls
retrally11310523retrally
royally13157733royally
rurally1038303rurally
sally85129713__sally
scall74420373_scall_
scalls84218203_scalls
scaly104718723_sca_ly
scenically1747943scenically
secantly1345983secantly
serially11912843serially
sexually1845603sexually
socially1338543socially
specially1647343specially
squally1937673squally
tally84526863__tally
techily1537123techily
telically1449853telically
telly84920823te__lly
tenably122210453tenably
teocalli1044373teocalli
tidally1137933tidally
tonally10311373tonally
totally1039893totally
trevally1446343trevally
uncially1339073uncially
usually1066063usually
vagally1435833vagally
vealy115817773ve_a_ly
venially1499423venially
verbally1647183verbally
vernally1447823vernally
vestally1437413vestally
vicarly1536463vicarly
virally1339653virally
vitally1339673vitally
vocably17157153vocably
wally114625093__wally
weakly1636483we_akly
welly114620013we__lly
xerically2149533xerically
yearly125210273ye_arly
zonally1938003zonally

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.1561145455.1
2DLD Change Limit1340272246.65320145.3
3Display Results2242240.0802800.0
 (SQL Overall)1786912246.88925938.6
 
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.