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

Here are the results of your fuzzy-string dictionary search for “codicil” 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.

78 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
codicil	12	4	681	(None)
codicils	13	4	604	1	codicils
codices	12	5	1258	2	codices
colicin	11	3	1374	2	colicin
comical	13	3	1222	2	comical
conical	11	3	1620	2	conical
council	11	3	747	2	council
domicil	12	4	643	2	domicil
nodical	10	4	986	2	nodical
bodice	11	7	1142	3	bodic_e
bodices	12	7	1059	3	bodices
civil	10	34	1193	3	c__ivil
coccal	9	3	1022	3	co_ccal
cocci	8	28	1267	3	co_cci_
coccic	8	29	894	3	co_ccic
coccid	10	29	1074	3	co_ccid
codec	10	71	2034	3	codec__
codecs	11	51	1293	3	codec_s
codeia	9	41	1219	3	cod_eia
codein	9	49	1672	3	cod_ein
codified	15	3	740	3	codified
codifier	14	4	716	3	codifier
codifies	14	3	964	3	codifies
codify	15	3	716	3	codi_fy
coding	10	40	2479	3	codi_ng
codlin	9	45	1644	3	cod_lin
coil	6	64	3965	3	co___il
coital	8	41	1705	3	co_ital
colic	9	57	2617	3	colic__
colicine	12	3	1299	3	colicine
colicins	12	3	1285	3	colicins
colicky	18	3	578	3	colicky
colics	10	42	1990	3	colic_s
colitic	11	29	1619	3	colitic
colitis	9	26	1735	3	colitis
comic	11	47	2181	3	comic__
comics	12	40	1556	3	comic_s
comitia	11	3	972	3	comitia
comitial	12	4	869	3	comitial
conic	9	53	2979	3	conic__
conicity	15	4	1109	3	conicity
conics	10	39	2059	3	conic_s
conidia	10	6	930	3	conidia
conidial	11	5	950	3	conidial
corbeil	11	85	921	3	corbeil
cordial	10	3	1294	3	cordi_al
cortical	12	4	1221	3	cortical
cosmical	14	4	801	3	cosmical
cotidal	10	3	846	3	cotidal
councils	12	4	697	3	councils
coxitis	16	23	846	3	coxitis
cubical	13	3	846	3	cubical
culicid	12	4	738	3	culicid
cynical	14	3	787	3	cynical
domical	12	3	937	3	domical
domicile	13	4	608	3	domicile
domicils	13	4	507	3	domicils
iconical	12	4	820	3	iconical
indicia	10	4	698	3	indicia
iodic	8	48	1675	3	iodic__
judicial	18	4	464	3	judicial
lodicule	11	4	326	3	lodicule
logical	10	3	851	3	logical
medical	12	3	1251	3	medical
modica	11	3	1006	3	modic_a
modicum	14	4	507	3	modicum
modioli	10	4	548	3	modioli
odic	7	49	2057	3	_odic__
pedicel	12	3	781	3	pedicel
penicil	11	3	883	3	penicil
poditic	12	26	1158	3	poditic
radical	10	33	1279	3	radical
radicel	10	27	887	3	radicel
sodic	8	49	1749	3	sodic__
solicit	9	3	1574	3	solicit
topical	11	3	995	3	topical
toxical	16	3	764	3	toxical
zodiacal	20	4	224	3	zodiacal

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	78	5.983	22401.3
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	6.419	27837.8