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

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

68 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
cornpone	12	4	693	(None)
cornpones	13	4	710	1	cornpones
compone	13	65	1719	2	co_mpone
condone	10	26	1629	2	co_ndone
canzone	18	5	881	3	c_anzone
chinbone	15	5	516	3	chinbone
chinone	12	5	1015	3	chin_one
colone	8	54	2500	3	co__lone
compony	16	130	1191	3	co_mpony
compose	13	57	1666	3	co_mpose
compote	13	56	1646	3	co_mpote
condole	10	29	1495	3	co_ndole
condoned	12	26	1202	3	co_ndoned
condoner	11	29	1340	3	co_ndoner
condones	11	28	1739	3	co_ndones
confine	12	3	1558	3	co_nfine
coniine	9	3	1680	3	co_niine
conine	8	45	2855	3	co_n_ine
connote	9	3	1161	3	co_nnote
console	9	27	1598	3	co_nsole
convene	12	33	1432	3	co_nvene
convoke	16	20	717	3	co_nvoke
cordon	9	50	1729	3	cor_don_
cordoned	12	22	961	3	cor_doned
cordons	10	44	1576	3	cor_dons
corncake	16	4	526	3	corncake
corncob	13	4	566	3	cornco_b
corncobs	14	4	472	3	corncobs
corneous	10	3	1003	3	corneous
cornice	11	6	1293	3	corn_ice
corniche	15	7	592	3	corniche
cornicle	12	5	878	3	cornicle
corning	10	37	2012	3	corn_ing
cornrow	12	4	560	3	cornro_w
cornrowed	15	4	362	3	cornrowed
cornrows	13	4	531	3	cornrows
cornute	9	3	963	3	corn_ute
corona	8	38	1740	3	cor__ona
coronae	9	42	1489	3	cor__onae
coronel	9	45	1522	3	cor__onel
coroner	9	42	1820	3	cor__oner
coronet	9	42	2717	3	cor__onet
corpora	11	3	935	3	cor_pora
corpse	10	40	1340	3	cor_p_se
corrode	10	13	1057	3	cor_rode
cortisone	11	4	704	3	cortisone
corvine	12	21	1364	3	cor_vine
coryphee	18	7	403	3	coryphee
coupon	10	28	1099	3	co_upon_
coupons	11	27	1055	3	co_upons
cowpoke	18	3	510	3	co_wpoke
crepon	10	3	993	3	c_repon_
crepons	11	3	931	3	c_repons
crone	7	52	3133	3	c_r__one
downzone	21	13	427	3	downzone
fordone	11	4	937	3	for_done
foredone	12	4	973	3	foredone
foregone	12	3	858	3	foregone
forgone	11	3	934	3	for_gone
hormone	12	4	1050	3	hor_mone
hornpipe	15	4	276	3	hornpipe
hornpout	13	5	670	3	hornpout
hornstone	12	6	607	3	hornstone
ionone	6	3	1344	3	io_n_one
orgone	7	11	1091	3	_or_gone
orpine	8	39	1448	3	_or_pine
postpone	12	4	869	3	postpone
propone	11	27	1630	3	_propone

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.173	1032896.0
2	DLD Change Limit	146162	68	7.530	19410.6
3	Display Results	68	68	0.033	2060.6
	(SQL Overall)	178691	68	7.736	23098.6