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

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

65 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
wharfs	15	4	637	(None)
wharf	14	3	1582	1	wharf_
arfs	7	60	2996	2	__arfs
barfs	10	48	2600	2	_barfs
chaffs	17	45	961	2	chaffs
charas	11	42	2361	2	charas
chards	12	51	1973	2	chards
chares	11	56	3180	2	chares
charks	15	52	1970	2	charks
charms	13	52	1884	2	charms
charrs	11	52	1919	2	charrs
chars	10	59	3664	2	char_s
charts	11	58	2309	2	charts
dwarfs	13	43	627	2	dwarfs
haafs	11	57	1116	2	_haafs
hards	9	64	3565	2	_hards
hares	8	62	5554	2	_hares
harks	12	63	3343	2	_harks
harls	8	56	3450	2	_harls
harms	10	68	2901	2	_harms
harps	10	59	2687	2	_harps
harts	8	84	4159	2	_harts
khafs	15	64	884	2	kha_fs
pharos	11	3	1206	2	pharos
scarfs	11	47	1468	2	scarfs
shards	10	43	1917	2	shards
shares	9	52	3641	2	shares
sharifs	13	27	990	2	sharifs
sharks	13	50	1972	2	sharks
sharns	9	55	1698	2	sharns
sharps	11	55	1608	2	sharps
snarfs	9	51	1342	2	snarfs
swarfs	12	56	1206	2	swarfs
tharms	11	57	1224	2	tharms
waffs	14	63	1547	2	w_affs
waifs	11	57	1987	2	w_aifs
wards	9	77	3440	2	w_ards
wares	8	82	5058	2	w_ares
warks	12	79	3240	2	w_arks
warms	10	77	2685	2	w_arms
warns	8	72	3100	2	w_arns
warps	10	71	2642	2	w_arps
wars	7	86	5980	2	w_ar_s
warts	8	148	4040	2	w_arts
wears	8	60	3030	2	wear_s
whacks	18	46	1048	2	whacks
whales	12	47	1694	2	whales
whams	13	55	1564	2	wha_ms
whangs	13	43	972	2	whangs
whaps	13	51	1516	2	wha_ps
wharfed	17	3	442	2	wharfed
wharve	15	45	621	2	wharve
wharves	16	45	714	2	wharves
whats	11	77	1899	2	wha_ts
whaups	14	40	575	2	whaups
wheres	12	59	1744	2	wheres
whiffs	18	3	508	2	whiffs
whirls	12	47	1053	2	whirls
whirrs	12	40	859	2	whirrs
whirs	11	52	1809	2	whir_s
whoofs	15	45	724	2	whoofs
whores	12	56	1710	2	whores
whorls	12	44	1016	2	whorls
whorts	12	51	1143	2	whorts
zarfs	17	47	1362	2	_zarfs

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	65	2.250	36689.3
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	2.609	68490.2