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

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

67 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
couchant	15	4	905	(None)
couching	16	32	1326	2	couching
courant	9	3	1797	2	cou_rant
bacchant	17	4	780	3	bacchant
bouffant	16	4	368	3	bouffant
chant	10	59	3269	3	___chant
clachan	14	3	718	3	clachan_
clachans	15	4	641	3	clachans
clubhand	16	4	243	3	clubhand
coaching	16	40	1196	3	coaching
coachman	17	4	498	3	coachman_
cochair	14	4	631	3	co_chair
cochin	13	13	1320	3	co_chin_
cochins	14	14	1310	3	co_chins
cocoanut	12	4	690	3	co_coanut
colorant	10	4	1472	3	colorant
concent	11	44	2251	3	conc_ent
concha	13	42	1328	3	concha__
conchae	14	39	1164	3	concha_e
conchal	14	42	1158	3	concha_l
conchas	14	40	1331	3	concha_s
constant	10	5	1559	3	constant
coolant	9	3	1646	3	co_olant
coruscant	13	24	604	3	coruscant
corybant	15	4	757	3	corybant
cosecant	12	4	1068	3	cosecant
cotenant	10	5	1179	3	cotenant
couch	12	53	2011	3	couch___
couched	15	41	1579	3	couch_ed
coucher	14	45	1585	3	couch_er
couchers	15	35	1386	3	couchers
couches	14	40	2047	3	couch_es
couchette	16	4	491	3	couchette
couchings	17	28	576	3	couchings
coughing	15	30	921	3	coughing
count	7	49	3205	3	cou___nt
courante	10	4	995	3	cou_rante
couranto	10	4	690	3	cou_ranto
courants	10	3	1080	3	cou_rants
courlan	9	11	776	3	courlan_
courlans	10	11	761	3	courlans
couthest	13	3	1208	3	couthest
covenant	13	4	969	3	covenant
cowhand	16	6	593	3	co_whand
crouching	17	4	638	3	crouching
crucian	11	4	628	3	crucian_
crucians	12	4	529	3	crucians
currant	9	3	1417	3	c_urrant
cushat	11	35	1369	3	c_usha_t
douching	15	34	984	3	douching
enchant	12	3	1312	3	_enchant
etchant	12	4	982	3	_etchant
lochan	11	3	909	3	lo_chan_
lochans	12	4	883	3	lo_chans
merchant	15	4	881	3	merchant
mouching	16	31	1058	3	mouching
occupant	14	4	467	3	occupant
octant	8	12	1655	3	_o_ctant
ouching	13	43	1490	3	_ouching
outhunt	10	3	1104	3	_outhunt
penchant	15	4	958	3	penchant
pouching	16	32	1041	3	pouching
souchong	14	8	451	3	souchong
toucan	8	3	819	3	touc_an_
toucans	9	3	758	3	touc_ans
touching	14	32	1134	3	touching
vouching	17	30	823	3	vouching

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.453	394461.4
2	DLD Change Limit	146162	67	6.546	22328.4
3	Display Results	67	67	0.013	5153.8
	(SQL Overall)	178691	67	7.012	25483.6