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

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

75 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
wharf	14	3	1582	(None)
wharfs	15	4	637	1	wharfs
arf	6	74	5337	2	__arf
barf	9	58	4441	2	_barf
chaff	16	50	1628	2	chaff
char	9	51	3215	2	char_
chard	11	61	2474	2	chard
chare	10	52	3198	2	chare
chark	14	42	2271	2	chark
charm	12	61	2466	2	charm
charr	10	48	2178	2	charr
chars	10	59	3664	2	chars
chart	10	50	3828	2	chart
chary	13	50	2313	2	chary
dwarf	12	60	1524	2	dwarf
haaf	10	62	2773	2	_haaf
half	10	62	3845	2	_half
hard	8	54	4350	2	_hard
hare	7	62	5573	2	_hare
hark	11	52	3739	2	_hark
harl	7	57	4000	2	_harl
harm	9	56	3779	2	_harm
harp	9	61	3429	2	_harp
hart	7	68	6577	2	_hart
khaf	14	53	1960	2	kha_f
scarf	10	54	2714	2	scarf
shard	9	61	2596	2	shard
share	8	64	3708	2	share
sharif	12	29	1712	2	sharif
shark	12	62	2502	2	shark
sharn	8	48	2370	2	sharn
sharp	10	49	2253	2	sharp
snarf	8	65	2542	2	snarf
swarf	11	53	2465	2	swarf
tharm	10	59	1664	2	tharm
waff	13	42	2804	2	w_aff
waif	10	58	3675	2	w_aif
war	6	72	6242	2	w_ar_
ward	8	65	4225	2	w_ard
ware	7	62	5472	2	w_are
wark	11	57	3777	2	w_ark
warm	9	59	3567	2	w_arm
warn	7	52	3932	2	w_arn
warp	9	56	3500	2	w_arp
wars	7	86	5980	2	w_ars
wart	7	78	6608	2	w_art
wary	10	67	4001	2	w_ary
wear	7	58	3672	2	wear_
wears	8	60	3030	2	wears
weary	11	56	2061	2	weary
wha	9	64	2207	2	wha__
whack	17	48	1302	2	whack
whale	11	55	1743	2	whale
wham	12	53	2169	2	wha_m
whamo	13	55	1126	2	whamo
whams	13	55	1564	2	whams
whang	12	48	1338	2	whang
whap	12	51	1964	2	wha_p
whaps	13	51	1516	2	whaps
wharfed	17	3	441	2	wharfed
wharve	15	45	620	2	wharve
what	10	54	3407	2	wha_t
whats	11	77	1899	2	whats
whaup	13	45	888	2	whaup
where	11	70	1942	2	where
whiff	17	3	1006	2	whiff
whir	10	55	1928	2	whir_
whirl	11	49	1382	2	whirl
whirr	11	46	1119	2	whirr
whirs	11	52	1809	2	whirs
whoof	14	46	1269	2	whoof
whore	11	60	1804	2	whore
whorl	11	46	1245	2	whorl
whort	11	46	2369	2	whort
zarf	16	69	2912	2	_zarf

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.096	1861364.6
2	DLD Change Limit	53800	75	1.670	32215.6
3	Display Results	75	75	0.016	4687.5
	(SQL Overall)	178691	75	1.782	100275.5