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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

105 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
coccoid	11	29	928	(None)
coccid	10	29	1074	1	cocc_id
coccoids	12	17	680	1	coccoids
cactoid	12	3	1103	2	cactoid
cocci	8	28	1267	2	cocc_i_
coccic	8	29	894	2	cocc_ic
coccids	11	27	721	2	cocc_ids
coccoidal	13	4	361	2	coccoidal
coccous	10	3	900	2	coccous
colloid	10	3	1288	2	colloid
conchoid	16	8	804	2	conchoid
concord	12	5	1034	2	concord
conoid	9	8	1888	2	co_noid
coracoid	13	4	816	2	coracoid
cormoid	12	3	1040	2	cormoid
cricoid	12	3	925	2	cricoid
cycloid	15	3	928	2	cycloid
accord	11	7	884	3	_accord
bocci	11	35	1271	3	bocc_i_
boccia	12	33	879	3	bocc_ia
boccie	12	33	1145	3	bocc_ie
boccis	12	39	1113	3	bocc_is
cancroid	13	4	652	3	cancroid
ceboid	11	3	1065	3	c_eboid
cestoid	10	40	1167	3	cestoid
cheloid	13	3	1083	3	cheloid
choreoid	14	4	792	3	choreoid
chorioid	14	4	833	3	chorioid
choroid	13	3	1180	3	choroid
cichlid	15	4	531	3	cichlid
cirsoid	10	3	812	3	cirsoid
cissoid	10	3	734	3	cissoid
coached	15	33	1384	3	coached
coacted	12	36	1161	3	coacted
cocain	10	13	1501	3	co_cain
coccal	9	3	1022	3	cocc_al
coccidia	12	4	401	3	coccidia
coccolith	15	4	441	3	coccolith
coccus	9	7	928	3	cocc_us
coccyx	19	4	266	3	cocc_yx
cochair	14	4	631	3	cochair
cochin	13	13	1320	3	co_chin
cocked	15	50	2256	3	co_cked
cockled	16	37	1082	3	cockled
cockpit	17	4	799	3	cockpit
coco	8	73	3060	3	co_co__
cocoa	9	85	1788	3	co_co_a
cocoas	10	49	1574	3	co_coas
cocoon	10	3	1226	3	co_coon
cocooned	13	3	729	3	cocooned
cocoons	11	3	1056	3	cocoons
cocos	9	56	2469	3	co_co_s
cojoin	15	3	950	3	co_join
colloids	11	3	1017	3	colloids
conceit	11	32	1807	3	conceit
conchie	14	33	1268	3	conchie
conchoids	17	6	628	3	conchoids
concoct	10	3	1290	3	concoct
concords	13	5	860	3	concords
conjoin	16	3	820	3	conjoin
conoids	10	8	1388	3	co_noids
coocoo	10	6	969	3	cooco_o
cooed	8	45	3434	3	co__oed
coracoids	14	4	584	3	coracoids
coronoid	11	4	895	3	coronoid
corticoid	14	4	546	3	corticoid
corvid	12	3	1047	3	co_rvid
cosmid	11	8	1064	3	co_smid
cotyloid	14	4	549	3	cotyloid
couched	15	41	1579	3	couched
couloir	9	3	615	3	couloir
coxcomb	22	4	329	3	coxcomb
cricoids	13	4	719	3	cricoids
crinoid	10	3	994	3	crinoid
ctenoid	10	7	868	3	ctenoid
cuboid	11	3	950	3	c_uboid
cuckold	16	4	372	3	cuckold
cycloids	16	4	704	3	cycloids
cymoid	14	5	947	3	c_ymoid
cystoid	13	30	921	3	cystoid
discoid	11	3	1124	3	discoid
ericoid	10	4	989	3	ericoid
factoid	13	3	869	3	factoid
fucoid	12	3	789	3	_fucoid
gobioid	11	4	602	3	gobioid
locoed	9	43	1219	3	lo_coed
mucoid	11	3	978	3	_mucoid
noctuid	10	6	438	3	noctuid
noctuoid	11	6	350	3	noctuoid
oceloid	10	3	797	3	oceloid
ochroid	13	5	790	3	ochroid
opioid	9	3	1008	3	_opioid
orchid	12	8	957	3	_orchid
ovoid	9	48	1102	3	_o_void
percoid	12	3	1232	3	percoid
placoid	12	3	977	3	placoid
sarcoid	10	3	1045	3	sarcoid
scincoid	13	4	475	3	scincoid
tomcod	11	3	578	3	tomco_d
toroid	7	4	1601	3	to_roid
toxoid	14	3	815	3	to_xoid
trochoid	14	6	844	3	trochoid
viscoid	13	3	702	3	viscoid
zincoid	19	4	666	3	zincoid
zooid	15	3	1210	3	zo__oid

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.390	458182.1
2	DLD Change Limit	134027	105	6.516	20568.9
3	Display Results	105	105	0.046	2282.6
	(SQL Overall)	178691	105	6.952	25703.5