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

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

76 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
cowhands	17	6	526	(None)
cowhand	16	6	593	1	cowhand_
commands	15	31	882	2	commands
cowards	13	3	961	2	cow_ards
cowbanes	15	3	742	2	cowbanes
cowbinds	16	3	445	2	cowbinds
cowhages	17	3	611	2	cowhages
cowherds	17	3	542	2	cowherds
lowlands	12	4	437	2	lowlands
blowhards	18	4	327	3	blowhards
bowheads	17	4	537	3	bowheads
browbands	17	4	340	3	browbands
chads	11	61	2223	3	c__ha_ds
changs	12	52	1537	3	c__hangs
chants	11	50	2039	3	c__hants
chards	12	51	1973	3	c__hards
chowhounds	22	5	164	3	chowhounds
clochards	17	4	382	3	clochards
clubhands	17	4	197	3	clubhands
cochairs	15	4	590	3	cochairs
cochins	14	14	1310	3	cochin_s
cofounds	14	4	471	3	cofounds
coheads	13	28	923	3	co_heads
cohunes	12	4	971	3	co_hunes
coleads	10	29	1142	3	colea_ds
collards	11	33	1019	3	collards
command	14	39	921	3	command_
commando	15	27	575	3	commando
commandos	16	24	596	3	commandos
commends	15	30	846	3	commends
compends	15	37	825	3	compends
contends	11	28	1057	3	contends
coolants	10	3	994	3	coolants
corbans	11	3	1317	3	corban_s
costards	11	35	1080	3	costards
cotans	8	13	1792	3	co_tan_s
courants	10	3	1080	3	courants
cowages	13	3	1094	3	cow_ages
coward	12	4	1167	3	cow_ard_
cowbane	14	3	767	3	cowban_e
cowbind	15	3	661	3	cowbind_
cowbirds	16	4	404	3	cowbirds
cowhage	16	3	630	3	cowha_ge
cowherbs	18	3	354	3	cowherbs
cowherd	16	3	695	3	cowherd_
cowhide	16	3	614	3	cowh_ide
cowhides	17	3	601	3	cowhides
cowlings	14	35	978	3	cowlings
cowman	13	9	1037	3	cowman__
cowpats	14	3	771	3	cowpa_ts
cowsheds	17	3	474	3	cowsheds
croplands	14	4	537	3	croplands
dockhands	20	5	312	3	dockhands
downlands	14	5	385	3	downlands
forehands	16	5	674	3	forehands
gormands	12	6	656	3	gormands
gowans	10	55	1229	3	gow_an_s
hands	9	53	2738	3	___hands
hollands	12	24	727	3	hollands
lochans	12	4	883	3	lochan_s
longhands	14	4	361	3	longhands
lowland	11	3	469	3	lowland_
norlands	9	3	644	3	norlands
plowlands	15	4	258	3	plowlands
pochards	16	4	685	3	pochards
robands	10	21	986	3	ro_bands
rowans	9	57	1534	3	row_an_s
snowlands	13	4	357	3	snowlands
solands	8	44	1234	3	so_lands
sowans	9	42	1589	3	sow_an_s
towards	11	3	878	3	tow_ards
towheads	15	4	481	3	towheads
towmonds	14	9	349	3	towmonds
unhands	11	3	777	3	_unhands
wands	9	64	2548	3	__w_ands
whangs	13	43	972	3	__whangs

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.440	406115.9
2	DLD Change Limit	146162	76	7.186	20339.8
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	7.656	23340.0