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

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

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
whaler	12	46	1197	(None)
haler	8	50	3352	1	_haler
thaler	9	46	1310	1	thaler
waler	8	42	2926	1	w_aler
whale	11	55	1743	1	whale_
whaled	13	46	1203	1	whaled
whalers	13	52	970	1	whalers
whales	12	47	1694	1	whales
baler	7	56	3527	2	_baler
chafer	14	47	1457	2	chafer
chaleh	14	37	1199	2	chaleh
chalet	11	38	2599	2	chalet
chaser	11	49	1838	2	chaser
chawer	14	43	1441	2	chawer
choler	11	37	1715	2	choler
coaler	8	41	2170	2	coaler
dealer	7	41	2214	2	dealer
dialer	7	43	1543	2	dialer
hailer	9	47	2034	2	_hailer
hale	7	60	5283	2	_hale_
haled	9	53	3582	2	_haled
halers	9	49	2691	2	_halers
haleru	9	42	1207	2	_haleru
hales	8	54	4984	2	_hales
halter	9	44	2088	2	_halter
hater	8	50	3475	2	_hater
hauler	9	50	1512	2	_hauler
haver	11	51	2446	2	_haver
hayer	11	46	2024	2	_hayer
hazer	17	48	2023	2	_hazer
healer	9	42	2180	2	healer
inhaler	10	6	805	2	inhaler
paler	7	54	3693	2	_paler
realer	6	35	2859	2	realer
scaler	8	43	2160	2	scaler
sealer	6	39	2896	2	sealer
shader	10	42	1876	2	shader
shaker	13	43	1946	2	shaker
shale	8	53	3283	2	shale_
shaled	10	50	2395	2	shaled
shales	9	47	3125	2	shales
shaley	12	37	1499	2	shaley
shalier	10	31	1642	2	shalier
shaper	11	41	1993	2	shaper
sharer	9	50	2548	2	sharer
shaver	12	37	1891	2	shaver
shoaler	10	26	1007	2	shoaler
staler	6	40	2582	2	staler
taler	5	60	3486	2	_taler
thalers	10	62	1226	2	thalers
thawer	12	48	934	2	thawer
vealer	9	40	1654	2	vealer
wader	9	53	2536	2	w_ader
wafer	11	44	1764	2	w_afer
wager	9	59	2505	2	w_ager
wailer	9	37	2032	2	wailer
waker	12	55	2659	2	w_aker
wale	7	45	4643	2	w_ale_
waled	9	43	3099	2	w_aled
walers	9	48	2446	2	w_alers
wales	8	61	4283	2	w_ales
walker	13	39	1399	2	w_alker
water	8	47	3331	2	w_ater
waver	11	50	2570	2	w_aver
waxer	15	43	1748	2	w_axer
weaker	13	40	1544	2	weaker
weaner	9	38	1677	2	weaner
wearer	9	43	1940	2	wearer
weaver	12	39	1661	2	weaver
whacker	19	36	850	2	whacker
whapper	17	34	827	2	whapper
wheeler	13	29	877	2	wheeler
while	11	54	1869	2	while_
whiled	13	45	1413	2	whiled
whiles	12	44	1801	2	whiles
whiner	12	45	1663	2	whiner
whirler	13	30	760	2	whirler
whiter	12	43	1639	2	whiter
whole	11	44	1809	2	whole_
wholes	12	46	1677	2	wholes
willer	9	40	2106	2	willer
wooler	9	36	1587	2	wooler

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.123	1452772.4
2	DLD Change Limit	82551	82	2.780	29694.6
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	2.936	60862.1