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

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

82 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
hoarsely	14	4	437	(None)
coarsely	13	3	553	1	coarsely
harshly	16	3	627	2	h_arshly
hoarily	13	3	897	2	hoar_ily
hoarse	9	44	1132	2	hoarse__
hoarsen	10	36	799	2	hoarse_n
hoarsens	11	30	603	2	hoarsens
hoarser	10	38	839	2	hoarse_r
hoarsest	11	3	713	2	hoarsest
horsefly	17	4	488	2	ho_rsefly
horsey	12	51	1540	2	ho_rse_y
horsily	13	3	884	2	ho_rsily
sparsely	13	3	512	2	sparsely
aversely	14	4	485	3	aversely
barely	11	47	1679	3	_bar_ely
basely	11	44	1231	3	_ba_sely
coarse	8	48	1390	3	coarse__
coarsen	9	32	1032	3	coarse_n
coarsens	10	34	812	3	coarsens
coarser	9	32	1120	3	coarse_r
coarsest	10	3	916	3	coarsest
dorsel	7	53	1550	3	do_rsel_
dorsels	8	44	1258	3	do_rsels
falsely	13	3	601	3	_falsely
hansel	9	52	1437	3	h_ansel_
hansels	10	40	1166	3	h_ansels
hardily	14	33	1027	3	h_ardily
hardly	13	51	1283	3	h_ar_dly
harslet	10	3	1565	3	h_arslet
hassel	9	56	1421	3	h_assel_
hassels	10	43	1102	3	h_assels
hearsay	13	3	552	3	hears_ay
hearse	9	41	1427	3	hearse__
hearsed	11	38	1140	3	hearse_d
hearses	10	44	1453	3	hearse_s
heartily	14	3	656	3	heartily
herself	13	3	762	3	h_erself
hirsel	9	13	868	3	h_irsel_
hirsels	10	12	835	3	h_irsels
hoarded	12	36	834	3	hoarde_d
hoarder	11	32	923	3	hoarde_r
hoarders	12	30	743	3	hoarders
hoarier	10	42	1174	3	hoarie_r
hoariest	11	3	1288	3	hoariest
hoars	8	59	2555	3	hoars___
hoarsened	13	4	405	3	hoarsened
hoary	11	45	1676	3	hoar___y
homely	14	53	1318	3	ho__mely
honestly	14	35	593	3	honestly
hornily	13	3	828	3	ho_rnily
horribly	16	11	431	3	horribly
horridly	15	11	479	3	horridly
horse	8	61	3265	3	ho_rse__
horsed	10	53	2108	3	ho_rse_d
horseplay	17	4	301	3	ho_rseplay
horses	9	47	2935	3	ho_rse_s
horsy	11	63	1839	3	ho_rs__y
hosel	8	60	2482	3	ho__sel_
hosels	9	42	1861	3	ho__sels
hosey	11	61	2702	3	ho__se_y
hostly	12	42	1086	3	ho__stly
hourly	12	36	962	3	hour__ly
housefly	17	4	411	3	ho_usefly
housel	9	52	1705	3	ho_usel_
housels	10	53	1214	3	ho_usels
jocosely	20	4	277	3	jocosely
largely	11	3	670	3	_largely
loosely	10	3	672	3	lo_osely
morosely	13	4	572	3	morosely
morsel	8	58	1589	3	mo_rsel_
morsels	9	41	1266	3	mo_rsels
obesely	12	4	511	3	_obesely
ourself	10	5	745	3	_ourself
parsley	12	4	780	3	_parsley
rarely	9	35	1365	3	_rar_ely
scarcely	15	3	431	3	scarcely
sorely	9	46	1801	3	so_r_ely
sparely	12	34	1067	3	spar_ely
tersely	10	3	811	3	_tersely
weasely	13	31	785	3	wea_sely
yarely	12	28	1030	3	_yar_ely
yourself	14	4	265	3	yourself

Search took 9 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.423	422437.4
2	DLD Change Limit	146162	82	7.983	18309.2
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	8.439	21174.4