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

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

87 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
cooncan	11	4	723	(None)
cooncans	12	4	627	1	cooncans
cancan	10	3	1410	2	c_ancan
aeonian	7	3	835	3	aeonian
bookman	15	13	648	3	bookman
cancans	11	3	1187	3	c_ancans
cloaca	10	3	726	3	cloaca_
cloacae	11	4	523	3	cloacae
cloacal	11	3	516	3	cloacal
cloacas	11	3	623	3	cloacas
clonal	8	3	1091	3	clon_al
coca	8	80	3064	3	c_o_ca_
cocain	10	13	1501	3	c_o_cain
cocas	9	59	2657	3	c_o_cas
coccal	9	3	1022	3	c_occal
coenact	11	3	1180	3	coenact
cognac	11	5	727	3	cogn_ac
cognacs	12	5	604	3	cognacs
colicin	11	3	1374	3	colicin
colonial	10	4	1134	3	colonial
colorman	12	4	789	3	colorman
comical	13	3	1222	3	comical
concave	14	3	937	3	c_oncave
conceal	11	33	1302	3	c_onceal
concent	11	44	2251	3	c_oncent
concern	11	30	1196	3	c_oncern
conch	12	46	2007	3	c_onc_h
concha	13	42	1328	3	c_oncha
conchae	14	39	1164	3	c_onchae
conchal	14	42	1159	3	c_onchal
conchas	14	40	1331	3	c_onchas
concho	13	44	1426	3	c_oncho
conchs	13	47	1490	3	c_onchs
conchy	16	37	1022	3	c_onchy
concur	10	4	1110	3	c_oncur
confab	13	4	706	3	c_onfab
conga	8	54	1987	3	c_onga_
congas	9	44	1703	3	c_ongas
conical	11	3	1620	3	conical
conin	7	62	3272	3	c_on_in
conn	6	62	2913	3	c_on__n
contain	9	3	1583	3	c_ontain
cooch	12	49	1683	3	coo_c_h
coocoo	10	6	969	3	coo_coo
coolant	9	3	1646	3	coo_lant
coon	6	72	4894	3	coo___n
coons	7	67	3728	3	coon__s
coonskin	14	4	439	3	coonskin
coontie	9	3	1142	3	coontie
copycat	16	4	759	3	copycat
corban	10	3	1469	3	c_orban
corncake	16	4	526	3	corncake
corncob	13	4	566	3	corncob
cornea	8	40	1893	3	cornea_
corneal	9	44	1450	3	corneal
corneas	9	47	1700	3	corneas
cornua	8	54	1190	3	cornua_
cornual	9	42	1017	3	cornual
corona	8	38	1740	3	coron_a_
coronach	15	4	576	3	coronach
coronae	9	42	1489	3	coron_ae
coronal	9	41	1576	3	coron_al
coronas	9	39	1691	3	coron_as
cosecant	12	4	1068	3	cosecant
cotan	7	15	2178	3	c_o_tan
council	11	3	747	3	council
countian	10	4	812	3	countian
courlan	9	11	776	3	courlan
cowman	13	9	1037	3	c_owman
doorman	10	3	706	3	doorman
eonian	6	3	1183	3	_eonian
footman	12	3	640	3	footman
goodman	11	3	593	3	goodman
honan	8	53	1977	3	_hon_an
ironman	9	3	661	3	ironman
longan	7	56	1236	3	_longan
mooncalf	15	4	453	3	mooncalf
nonfan	9	4	829	3	_nonfan
nonman	8	4	1236	3	_nonman
noonday	11	4	460	3	noonday
oilcan	8	3	779	3	_oilcan
poontang	11	4	381	3	poontang
rootcap	11	4	397	3	rootcap
toucan	8	3	819	3	_toucan
woodman	13	3	631	3	woodman
woolman	12	3	543	3	woolman
zoonal	15	5	808	3	zoon_al

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	87	6.250	21444.3
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	6.686	26726.1