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

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

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.

83 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
cordierites	14	5	406	(None)
cordierite	13	5	459	1	cordierite_
coderives	15	4	748	3	co_d_erives
collieries	12	4	834	3	collieri_es
cordialities	15	4	615	3	cordialities
cordites	11	3	1463	3	cord___ites
currieries	12	4	454	3	currieri_es
garnierites	12	5	274	3	garnierites
soldieries	11	4	559	3	soldieri_es
borderlines	14	4	325	4	bord_erlines
bowdlerises	17	5	225	4	bowdlerises
bowdlerizes	26	5	235	4	bowdlerizes
broideries	13	4	635	4	broideri_es
carditises	13	4	697	4	cardi_tises
cassiterites	14	5	235	4	cassiterites
cerites	9	48	2343	4	c____erites
chondrites	16	4	476	4	chond__rites
codeines	11	31	1452	4	co_d_e_ines
coderive	14	4	769	4	co_d_erive_
coderived	16	4	479	4	co_d_erived
codifies	14	3	964	4	co_di_fi_es
codirected	16	5	300	4	co_directed
codirects	14	9	359	4	co_direct_s
codrives	14	3	766	4	co_d__rives
coesites	10	13	1309	4	co___esites
cofavorites	19	12	210	4	cofavorites
commiserates	18	5	361	4	commiserates
comraderies	16	5	397	4	comraderi_es
concierges	15	4	455	4	concier_ges
congeries	12	3	1640	4	co_ngeri_es
conniveries	16	4	471	4	conniveri_es
cookeries	15	12	1064	4	co_okeri_es
cooperates	14	6	961	4	co_operates
cooperies	13	11	1332	4	co_operi_es
coordinates	14	4	410	4	coordi_nates
cordelles	12	4	823	4	cord_e_lles
corders	10	45	2088	4	cord_er___s
cordiality	16	4	562	4	cordialit_y
cordite	10	3	1526	4	cord___ite_
cordlesses	13	4	630	4	cordle_sses
cordwaineries	19	6	136	4	cordwaineri_es
corelates	11	3	1486	4	cor__elates
corneitis	11	4	650	4	cor_ne_itis
corneitises	13	4	508	4	corneitises
cornifies	14	3	900	4	corni_fi_es
coronaries	12	4	1024	4	coronari_es
corporates	14	4	1073	4	cor_porates
corporeities	16	5	429	4	corporeities
correlates	12	4	867	4	cor_relates
corries	9	40	2680	4	cor___ri_es
corsetries	12	4	966	4	corsetri_es
corvettes	14	4	743	4	cor_ve_ttes
coteries	10	4	2271	4	co__teri_es
cousinries	12	4	469	4	cousinri_es
cowrites	13	30	1159	4	co___writes
crinites	10	6	1276	4	c_r_i_nites
crockeries	18	5	712	4	crockeri_es
crookeries	16	4	614	4	crookeri_es
diorites	9	3	1352	4	___diorites
dodgeries	12	4	659	4	do_dgeri_es
dolerites	10	14	1089	4	do__lerites
dumortierites	16	12	76	4	dumortierites
farrieries	13	4	435	4	farrieri_es
forgeries	13	3	1000	4	for_geri_es
furrieries	13	4	395	4	furrieri_es
garnierite	11	5	308	4	garnierite_
hosieries	12	4	921	4	ho_sieri_es
marguerites	14	5	374	4	marguerites
moderates	12	7	1075	4	mo_d_erates
orderlies	10	4	545	4	_ord_erlies
ordinaries	11	4	625	4	_ordinari_es
ordinates	10	4	900	4	_ordi_nates
orreries	8	3	1012	4	_or_reri_es
ozocerites	21	4	272	4	_ozocerites
ozokerites	23	6	202	4	_ozokerites
portieres	11	3	822	4	portier__es
preterites	12	4	1180	4	_preterites
siderites	10	4	1043	4	_sid_erites
soldierings	13	5	215	4	soldierings
sorceries	11	4	994	4	sor_ceri_es
trailerites	11	5	497	4	_trailerites
verdigrises	16	5	175	4	verdigrises
wernerites	13	4	495	4	wer_nerites

Search took 10 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	148819	0.436	409841.7
2	DLD Change Limit	148819	83	9.110	16335.8
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	9.592	18629.2