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

Here are the results of your fuzzy-string dictionary search for “hound” with Change Limit: [1] [2] [3]

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.

85 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
hound	9	50	1648	(None)
bound	8	48	1958	1	bound
found	9	49	1784	1	found
hounds	10	44	1313	1	hounds
mound	8	39	1831	1	mound
pound	8	44	1786	1	pound
round	6	43	1843	1	round
sound	6	44	2002	1	sound
wound	9	44	1421	1	wound
abound	9	23	986	2	abound
around	7	27	1241	2	around
bond	7	53	3436	2	bo_nd
bounds	9	44	1580	2	bounds
bund	7	55	3066	2	_bund
could	8	65	1771	2	could
count	7	49	3205	2	count
fond	8	63	3095	2	fo_nd
founds	10	48	1419	2	founds
fount	8	47	2703	2	fount
fund	8	56	2498	2	_fund
gourd	7	10	1190	2	gourd
ground	8	23	1027	2	ground
hand	8	68	3371	2	h_and
haunt	8	52	2913	2	haunt
hind	8	55	2975	2	h_ind
hoard	9	49	1831	2	hoard
hod	7	68	5246	2	ho__d
hodad	10	3	1135	2	hodad
hoed	8	78	3798	2	ho_ed
hoked	13	53	2699	2	hoked
hold	8	62	3506	2	ho_ld
holed	9	56	3413	2	holed
homed	11	54	2542	2	homed
hon	6	77	5938	2	ho_n_
honda	9	4	1498	2	ho_nda
hone	7	75	4932	2	ho_ne
honed	9	53	3226	2	honed
hong	8	58	3395	2	ho_ng
honk	11	69	3119	2	ho_nk
hons	7	73	5078	2	ho_ns
hood	8	51	3233	2	ho_od
hoped	11	56	2818	2	hoped
horn	7	67	3561	2	horn_
horned	10	57	1870	2	horned
horns	8	61	2533	2	horns
horny	11	56	1962	2	horny
hosed	9	58	3098	2	hosed
hounded	12	33	1103	2	hounded
hounder	11	34	1223	2	hounder
hour	7	58	2731	2	hou_r
houri	8	59	1525	2	houri
hours	8	54	2239	2	hours
house	8	91	3142	2	house
housed	10	56	2410	2	housed
hued	8	69	2585	2	h_ued
hun	6	58	4471	2	h_un_
hung	8	61	2635	2	h_ung
hunh	10	63	2373	2	h_unh
hunk	11	60	2954	2	h_unk
huns	7	61	3693	2	h_uns
hunt	7	64	4549	2	h_unt
jocund	16	3	362	2	jocund
loud	5	52	2804	2	lou_d
maund	8	55	1545	2	maund
mould	8	60	1575	2	mould
mounds	9	39	1513	2	mounds
mount	7	41	2806	2	mount
noun	4	57	2418	2	noun_
nouns	5	67	1731	2	nouns
oud	4	74	3907	2	_ou_d
poind	8	42	1791	2	poind
pond	7	55	3049	2	po_nd
pounds	9	37	1438	2	pounds
rotund	7	3	729	2	rotund
rounds	7	36	1562	2	rounds
should	10	3	803	2	should
sounds	7	46	1618	2	sounds
stound	7	39	990	2	stound
swound	10	37	763	2	swound
thoued	10	42	900	2	thoued
would	9	55	1315	2	would
wounds	10	38	1163	2	wounds
yond	8	61	2231	2	yo_nd
young	9	7	774	2	young
zounds	16	43	1017	2	zounds

Search took 2 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	53800	0.293	609866.9
2	DLD Change Limit	53800	85	1.486	36204.6
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	1.809	98778.9