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

Here are the results of your fuzzy-string dictionary search for “corncob” 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
corncob	13	4	566	(None)
corncobs	14	4	472	1	corncobs
corncrib	14	4	390	2	corncrib
cornrow	12	4	560	2	cornrow
borneol	9	3	682	3	borneol
bronco	10	17	949	3	bronco_
broncos	11	18	807	3	broncos
caracol	11	3	1042	3	caracol
carob	9	53	2522	3	car__ob
coanchor	15	4	525	3	coanchor
coco	8	73	3060	3	co__co_
cocoa	9	85	1788	3	co__coa
cocos	9	56	2469	3	co__cos
conch	12	46	2007	3	co_nc_h
concha	13	42	1328	3	co_ncha
concho	13	44	1426	3	co_ncho
conchos	14	43	1396	3	co_nchos
conchs	13	47	1490	3	co_nchs
conchy	16	37	1022	3	co_nchy
concoct	10	3	1290	3	co_ncoct
concord	12	5	1034	3	co_ncord
concur	10	4	1110	3	co_ncur
condo	8	53	2259	3	co_ndo_
condom	11	42	1536	3	co_ndom
condor	9	46	1697	3	co_ndor
condos	9	43	2233	3	co_ndos
confab	13	4	706	3	co_nfab
congo	8	56	2313	3	co_ngo_
congos	9	42	1988	3	co_ngos
congou	9	43	1324	3	co_ngou
consol	8	26	1411	3	co_nsol
conto	7	60	2717	3	co_nto_
contos	8	49	2323	3	co_ntos
convoy	14	34	854	3	co_nvoy
coocoo	10	6	969	3	co_ocoo
cooncan	11	4	723	3	cooncan
coracle	11	20	1172	3	coracle
coracoid	13	4	815	3	coracoid
coranto	9	3	1189	3	coranto_
corantos	10	3	1010	3	corantos
cordoba	12	5	574	3	cor_doba
cordon	9	50	1729	3	cor_don
corn	6	99	4581	3	corn___
corncake	16	4	526	3	corncake
corncribs	15	4	296	3	corncribs
cornea	8	40	1892	3	corn_ea
corneal	9	44	1450	3	corneal
corneas	9	47	1700	3	corneas
corned	9	52	2452	3	corn_ed
cornel	8	40	2005	3	corn_el
cornels	9	47	1666	3	cornels
corneous	10	3	1003	3	corneous
corner	8	46	2562	3	corn_er
corners	9	47	2331	3	corners
cornet	8	44	3673	3	corn_et
cornets	9	48	2057	3	cornets
cornfed	13	3	738	3	cornfed
cornice	11	6	1293	3	cornice
corniced	13	6	859	3	corniced
cornices	12	7	1329	3	cornices
corniche	15	7	592	3	corniche
cornichon	16	4	288	3	cornichon
cornicle	12	5	878	3	cornicle
cornier	9	30	1709	3	cornier
cornify	15	3	625	3	cornify
cornily	12	4	1085	3	cornily
corning	10	37	2012	3	corning
cornpone	12	4	693	3	cornpone
cornrows	13	4	531	3	cornrows
corns	7	60	3476	3	corn__s
cornu	7	59	2132	3	corn__u
cornua	8	54	1190	3	corn_ua
cornual	9	42	1017	3	cornual
cornus	8	48	1656	3	corn_us
cornute	9	3	964	3	cornute
cornuto	9	3	703	3	cornuto
cornutos	10	4	605	3	cornutos
corny	10	60	2327	3	corn__y
corymb	15	3	522	3	cor_ymb
council	11	3	747	3	council
coxcomb	22	4	329	3	co_xcomb
curacoa	11	4	622	3	curacoa
dornock	14	4	440	3	dornock
hobnob	13	3	513	3	hobn_ob
noncom	10	3	968	3	no_ncom
porno	7	51	2065	3	porn_o_
pornos	8	50	1525	3	porn_os

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	87	6.013	22289.5
3	Display Results	87	87	0.033	2636.4
	(SQL Overall)	178691	87	6.436	27764.3