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

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

64 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
coronary	13	4	769	(None)
chronaxy	23	4	325	2	chronaxy
corollary	14	4	391	2	corollary
corona	8	38	1740	2	corona__
coronach	15	4	576	2	coronach
coronae	9	42	1489	2	corona_e
coronal	9	41	1576	2	corona_l
coronally	14	4	841	2	coronally
coronals	10	33	1291	2	coronals
coronas	9	39	1691	2	corona_s
coronate	10	30	1821	2	coronate
coroner	9	42	1820	2	coroner_
coroners	10	40	1623	2	coroners
octonary	13	4	498	2	octonary
canary	11	3	1469	3	c__anary
canonry	12	3	592	3	canon_ry
carbonara	13	4	506	3	carbonara
catenary	13	4	658	3	catenary
colony	11	54	1727	3	colon__y
cometary	15	4	769	3	cometary
contrary	13	4	749	3	contrary
cookery	16	42	1039	3	co_okery
coopery	14	39	1027	3	co_opery
corner	8	46	2562	3	cor_ner_
corners	9	47	2331	3	cor_ners
cornify	15	3	625	3	cor_nify
cornily	12	4	1085	3	cor_nily
corny	10	60	2327	3	cor_n__y
corody	12	14	970	3	coro__dy
coronachs	16	4	425	3	coronachs
coronaries	12	4	1024	3	coronaries
coronated	12	33	1332	3	coronated
coronates	11	108	1692	3	coronates
coronel	9	45	1522	3	coron_el
coronels	10	40	1215	3	coronels
coronet	9	42	2717	3	coron_et
coronets	10	38	1436	3	coronets
coronoid	11	4	895	3	coronoid
corotate	10	28	1393	3	corotate
corsetry	13	6	557	3	corsetry
costmary	15	4	505	3	costmary
country	12	38	804	3	co_untry
covary	14	3	874	3	c__ovary
croaky	15	52	848	3	c_ro_aky
crony	10	59	1867	3	c_ron__y
crookery	17	41	599	3	crookery
crooner	9	37	1404	3	crooner_
crooners	10	39	1139	3	crooners
culinary	13	5	585	3	culinary
granary	11	5	779	3	_granary
heronry	13	4	604	3	heron_ry
honorary	14	4	580	3	honorary
horary	12	3	1038	3	hor__ary
moronity	13	4	733	3	moronity
mortary	12	36	904	3	mor_tary
mortuary	13	7	392	3	mortuary
ordinary	12	4	491	3	_ordinary
ornery	9	3	846	3	_or_nery
rosary	9	28	1035	3	__rosary
rotary	9	24	1130	3	__rotary
ternary	10	3	834	3	ter_nary
trinary	10	3	917	3	_trinary
urinary	10	3	724	3	_urinary
zonary	18	3	879	3	__zonary

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.420	425454.8
2	DLD Change Limit	146162	64	7.470	19566.5
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	7.906	22601.9