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

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

66 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
whalers	13	52	970	(None)
halers	9	49	2691	1	_halers
thalers	10	62	1226	1	thalers
walers	9	48	2446	1	w_alers
whaler	12	46	1197	1	whaler_
whales	12	47	1694	1	whale_s
balers	8	56	2693	2	_balers
chafers	15	45	1272	2	chafers
chalehs	15	26	880	2	chalehs
chalets	12	28	1347	2	chalets
chasers	12	37	1489	2	chasers
chawers	15	44	1203	2	chawers
cholers	12	42	1519	2	cholers
coalers	9	44	1933	2	coalers
dealers	8	41	1861	2	dealers
dialers	8	36	1429	2	dialers
hailers	10	40	1726	2	_hailers
haler	8	50	3352	2	_haler_
haleru	9	42	1207	2	_haleru
hales	8	54	4984	2	_hale_s
halters	10	46	1980	2	_halters
halvers	13	33	1142	2	_halvers
haters	9	49	3039	2	_haters
haulers	10	40	1244	2	_haulers
havers	12	47	2148	2	_havers
hayers	12	44	1594	2	_hayers
hazers	18	46	1595	2	_hazers
healers	10	43	1946	2	healers
inhalers	11	6	663	2	inhalers
scalers	9	38	1726	2	scalers
sealers	7	43	2355	2	sealers
shaders	11	59	1555	2	shaders
shakers	14	40	1556	2	shakers
shales	9	47	3125	2	shale_s
shapers	12	40	1689	2	shapers
sharers	10	47	2062	2	sharers
shavers	13	41	1509	2	shavers
talers	6	46	2814	2	_talers
thaler	9	46	1310	2	thaler_
thawers	13	42	848	2	thawers
vealers	10	32	1429	2	vealers
waders	10	91	2064	2	w_aders
wafers	12	43	1614	2	w_afers
wagers	10	51	2220	2	w_agers
wailers	10	39	1680	2	wailers
wakers	13	48	2249	2	w_akers
waler	8	42	2926	2	w_aler_
wales	8	61	4283	2	w_ale_s
walkers	14	34	1147	2	w_alkers
waters	9	50	3062	2	w_aters
wavers	12	50	2247	2	w_avers
waxers	16	40	1430	2	w_axers
weaners	10	46	1383	2	weaners
wearers	10	46	1590	2	wearers
weavers	13	37	1446	2	weavers
whackers	20	32	654	2	whackers
whale	11	55	1743	2	whale__
whaled	13	46	1203	2	whale_d
whappers	18	27	674	2	whappers
wheelers	14	28	773	2	wheelers
whiles	12	44	1801	2	while_s
whiners	13	40	1157	2	whiners
whirlers	14	28	605	2	whirlers
wholes	12	46	1677	2	whole_s
willers	10	35	1790	2	willers
woolers	10	42	1402	2	woolers

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	107671	0.296	603685.8
2	DLD Change Limit	107671	66	7.923	13589.7
3	Display Results	66	66	0.060	1100.0
	(SQL Overall)	178691	66	8.279	21583.6