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

Here are the results of your fuzzy-string dictionary search for “chemical” 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
chemical	17	4	839	(None)
chemicals	18	4	560	1	chemicals
alchemical	19	5	442	2	alchemical
chemic	15	30	1209	2	chemic__
chemically	22	4	831	2	chemically
chemics	16	34	958	2	chemic_s
clerical	12	4	823	2	clerical
comical	13	3	1222	2	c_omical
cosmical	14	4	801	2	cosmical
helical	12	3	1115	2	_helical
thetical	13	4	912	2	thetical
academical	17	5	358	3	academical
achenial	13	4	828	3	acheni_al
atomical	12	4	890	3	atomical
biochemical	22	5	435	3	~~bio~~chemical
caecal	10	37	1373	3	cae__cal
cecal	9	46	1911	3	c_e__cal
cercal	10	3	1412	3	c_e_rcal
cervical	15	4	685	3	cervical
chamisa	14	32	885	3	chamisa_
chamisas	15	31	781	3	chamisas
cheliceral	17	5	228	3	cheliceral
chemise	14	32	1150	3	chemi_se
chemises	15	32	1198	3	chemises
chemism	16	33	930	3	chemi_sm
chemisms	17	27	821	3	chemisms
chemist	14	36	1500	3	chemi_st
chemists	15	27	1032	3	chemists
chica	12	58	1826	3	ch__ica_
chicas	13	59	1647	3	ch__icas
chimerical	19	5	453	3	chimerical
chiral	11	46	1441	3	ch__iral
chital	11	43	1388	3	ch__ital
chorial	12	42	1414	3	chori_al
chymic	18	31	788	3	chymic__
chymics	19	29	553	3	chymic_s
clericals	13	4	535	3	clericals
clinical	12	4	702	3	clinical
conical	11	3	1620	3	c_onical
cortical	12	4	1221	3	cortical
criminal	12	4	830	3	criminal
critical	12	3	1026	3	critical
cubical	13	3	846	3	c_ubical
cyclical	14	4	565	3	cyclical
cynical	14	3	787	3	c_ynical
domical	12	3	937	3	_domical
endemical	14	4	538	3	endemical
epical	10	4	1339	3	__epical
geminal	10	10	991	3	_geminal
geochemical	21	5	452	3	~~geo~~chemical
gnomical	13	4	668	3	gnomical
gremial	10	3	915	3	gremi_al
hectical	15	4	793	3	_hectical
heliacal	13	4	472	3	_heliacal
hemal	10	44	1980	3	_hem__al
hematal	12	3	895	3	_hematal
hemic	12	57	1862	3	_hemic__
hemiola	12	10	700	3	_hemiola
heroical	13	4	1002	3	_heroical
icterical	13	4	721	3	icterical
inimical	12	4	731	3	inimical
irenical	10	4	855	3	irenical
khedival	19	4	199	3	khedival
lexical	16	3	736	3	_lexical
medical	12	3	1251	3	_medical
metical	11	3	1536	3	_metical
mimical	13	3	923	3	_mimical
nonchemical	20	7	561	3	~~non~~chemical
pemican	13	4	816	3	_pemican
physical	18	4	570	3	physical
poetical	12	3	1153	3	poetical
polemical	15	4	734	3	polemical
rhombical	18	5	285	3	rhombical
scenical	12	4	713	3	scenical
seminal	9	12	1341	3	_seminal
spherical	16	4	580	3	spherical
sterical	10	3	1125	3	sterical
thecal	11	33	1030	3	the__cal
theriacal	14	4	355	3	theriacal
vesical	12	15	981	3	_vesical
whimsical	19	5	223	3	whimsical

Search took 8 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	6.923	21112.5
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	7.359	24282.0