Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “scenical” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

81 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
scenical	12	4	713	(None)
ascetical	13	4	628	2	ascetical
conical	11	3	1620	2	_conical
cynical	14	3	787	2	_cynical
iconical	12	4	820	2	iconical
irenical	10	4	855	2	irenical
scenic	10	5	1051	2	scenic__
scenically	17	4	794	2	scenically
scenics	11	3	777	2	scenic_s
sceptical	15	4	534	2	sceptical
sterical	10	3	1125	2	sterical
achenial	13	4	828	3	acheni_al
acronical	13	4	783	3	acronical
arsenical	11	4	557	3	arsenical
cecal	9	46	1911	3	_ce__cal
censual	9	3	766	3	_censual
cental	8	44	2096	3	_cen_tal
central	9	31	1447	3	_central
centrical	13	4	835	3	_centrical
cercal	10	3	1412	3	_ce_rcal
cervical	15	4	685	3	_cervical
chemical	17	4	839	3	chemical
clerical	12	4	823	3	clerical
clinical	12	4	702	3	clinical
comical	13	3	1222	3	_comical
cubical	13	3	846	3	_cubical
denial	7	47	2051	3	_deni_al
ecumenical	16	9	383	3	ecumenical
eirenical	11	4	593	3	eirenical
epical	10	4	1339	3	__epical
ethnical	13	4	636	3	ethnical
eugenical	12	4	506	3	eugenical
finical	12	3	969	3	_finical
fornical	13	4	779	3	fornical
galenical	12	4	468	3	galenical
genial	7	49	1761	3	_geni_al
genital	8	4	979	3	_genital
hectical	15	4	793	3	hectical
helical	12	3	1115	3	_helical
icterical	13	4	721	3	icterical
identical	12	4	631	3	identical
ironical	10	4	996	3	ironical
lexical	16	3	736	3	_lexical
medical	12	3	1251	3	_medical
menial	8	42	2303	3	_meni_al
meniscal	12	4	620	3	_meniscal
metical	11	3	1536	3	_metical
obconical	15	4	417	3	obconical
penial	8	41	2089	3	_peni_al
penicil	11	3	883	3	_penicil
poetical	12	3	1153	3	poetical
satanical	11	4	541	3	satanical
scandal	10	3	867	3	scan_dal
scena	7	48	1578	3	scen__a_
scenas	8	41	1470	3	scen__as
sceptral	12	4	451	3	sceptral
sciential	11	4	632	3	sciential
scribal	11	3	796	3	sc_ribal
seminal	9	12	1341	3	s_eminal
sendal	7	33	1499	3	s_en_dal
seneca	8	3	979	3	s_eneca_
senecas	9	3	901	3	s_enecas
sensual	7	3	805	3	s_ensual
septical	12	5	936	3	septical
serial	6	46	2586	3	s_eri_al
silvical	13	4	522	3	silvical
skeptical	17	4	396	3	skeptical
special	11	3	1030	3	speci_al
spherical	16	4	580	3	spherical
splenial	10	4	718	3	spleni_al
statical	10	3	942	3	statical
stencil	9	4	689	3	sten_cil
stoical	9	3	1028	3	s_toical
surgical	11	4	625	3	surgical
syndical	14	4	537	3	syndical
technical	16	4	605	3	technical
thetical	13	4	912	3	thetical
uncynical	16	4	389	3	uncynical
venial	9	42	1828	3	_veni_al
vesical	12	15	981	3	_vesical
xenial	13	34	1490	3	_xeni_al

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	146162	0.406	440125.6
2	DLD Change Limit	146162	81	7.623	19173.8
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	8.059	22172.9