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

Here are the results of your fuzzy-string dictionary search for “wither” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

157 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
wither	12	43	2135	(None)
cither	11	46	1668	1	cither
dither	10	44	1768	1	dither
either	9	45	1742	1	either
hither	12	44	1725	1	hither
ither	8	46	1760	1	_ither
lither	9	45	2095	1	lither
mither	11	42	1856	1	mither
swither	13	37	1099	1	swither
tither	9	49	2028	1	tither
wether	12	33	1539	1	wether
whither	16	35	1025	1	whither
wisher	12	36	1706	1	wisher
withe	11	52	2023	1	withe_
withed	13	44	1623	1	withed
withers	13	44	1775	1	withers
withes	12	46	2084	1	withes
withier	13	29	1049	1	withier
writher	13	40	1085	1	writher
wuther	12	45	1161	1	wuther
zither	18	38	1308	1	zither
aether	9	42	1367	2	aether
anther	9	37	1506	2	anther
bather	11	53	2251	2	bather
biter	7	50	3003	2	bit_er
bitter	8	46	2267	2	bitter
blither	12	48	1217	2	blither
bother	11	52	1806	2	bother
cipher	13	37	1026	2	cipher
citer	7	48	2733	2	cit_er
cithern	12	48	991	2	cithern
cithers	12	43	1577	2	cithers
diether	11	4	744	2	diether
ditcher	13	40	1200	2	ditcher
dithers	11	40	1615	2	dithers
dithery	14	31	894	2	dithery
ether	8	45	1877	2	_ether
father	12	51	1671	2	father
fisher	12	49	1714	2	fisher
fitter	9	41	2003	2	fitter
gather	10	41	1586	2	gather
higher	13	46	1089	2	higher
hitcher	15	37	1200	2	hitcher
hitter	9	44	1986	2	hitter
jitter	13	33	1499	2	jitter
kiter	9	55	2321	2	kit_er
kithe	12	59	1745	2	kithe_
kithed	14	46	1301	2	kithed
kithes	13	50	1665	2	kithes
lather	9	51	2436	2	lather
liter	5	47	3634	2	lit_er
lithe	8	49	2201	2	lithe_
litter	6	43	2485	2	litter
miter	7	57	3479	2	mit_er
mithers	12	35	1673	2	mithers
mitier	8	36	2067	2	mitier
mother	11	37	1864	2	mother
neither	10	3	757	2	neither
nether	9	40	1416	2	nether
nigher	10	36	1275	2	nigher
niter	5	50	2897	2	nit_er
nother	9	38	1596	2	nother
other	8	42	1910	2	_other
pisher	11	43	1775	2	pisher
pitcher	14	38	1371	2	pitcher
pithed	12	46	1561	2	pithed
pithier	12	30	1029	2	pithier
pitier	8	40	1982	2	pitier
pother	11	38	1885	2	pother
rather	9	43	1974	2	rather
richer	11	40	1504	2	richer
ritter	6	38	2242	2	ritter
sigher	10	38	1370	2	sigher
sitter	6	33	2338	2	sitter
slither	10	41	1298	2	slither
swather	13	42	1360	2	swather
swisher	13	36	952	2	swisher
switcher	16	17	768	2	switcher
swithe	12	40	1068	2	swithe_
swithers	14	43	1053	2	swithers
tether	9	37	1610	2	tether
thither	13	32	810	2	thither
titer	5	54	3061	2	tit_er
titfer	9	40	952	2	titfer
tithe	8	53	1970	2	tithe_
tithed	10	41	1559	2	tithed
tithers	10	42	1673	2	tithers
tithes	9	47	2021	2	tithes
titter	6	34	2116	2	titter
tother	9	41	1714	2	tother
twitcher	16	13	534	2	twitcher
twitter	10	27	809	2	twitter
waiter	9	43	2125	2	wait_er
washer	12	47	2039	2	washer
watcher	15	31	1340	2	watcher
water	8	47	3331	2	wat_er
watter	9	32	2198	2	watter
weather	13	35	1322	2	weather
weigher	14	13	634	2	weigher
wethers	13	52	1469	2	wethers
wetter	9	39	1944	2	wetter
whether	16	34	662	2	whether
whiter	12	43	1639	2	whit_er
whitier	13	33	1106	2	whitier
whitter	13	91	1089	2	whitter
wiches	14	44	1875	2	wiches
wicker	15	45	1867	2	wicker
widder	11	29	1397	2	widder
wider	9	48	2635	2	wi_der
wiener	9	45	1354	2	wiener
wiftier	13	29	773	2	wiftier
wilder	10	36	1647	2	wilder
wilier	9	32	1707	2	wilier
willer	9	40	2106	2	willer
wincer	11	50	1819	2	wincer
wincher	15	34	1065	2	wincher
winder	10	40	2526	2	winder
winger	10	41	2544	2	winger
winier	9	45	2245	2	winier
winker	13	42	2029	2	winker
winner	9	42	1993	2	winner
winter	9	42	2280	2	winter
wiper	10	54	2129	2	wi_per
wirer	8	51	2495	2	wi_rer
wirier	9	42	1555	2	wirier
wiser	8	55	2280	2	wi_ser
wished	13	44	1751	2	wished
wishers	13	32	1521	2	wishers
wishes	12	49	2095	2	wishes
witched	16	30	1219	2	witched
witchery	19	23	609	2	witchery
witches	15	27	1579	2	witches
witchier	16	30	788	2	witchier
wite	7	54	4327	2	wit_e_
wited	9	47	2714	2	wit_ed
wites	8	55	3696	2	wit_es
with	10	57	3047	2	with__
withal	12	3	893	2	withal
withered	15	16	943	2	withered
witherer	14	18	795	2	witherer
witherod	15	15	615	2	witherod
withies	13	39	1354	2	withies
within	12	36	1138	2	within
withy	14	48	1376	2	with_y
witney	12	35	684	2	witney
witted	10	42	1681	2	witted
wittier	10	39	1082	2	wittier
wiver	11	59	2451	2	wi_ver
writer	9	44	1651	2	writ_er
writhe	12	53	1070	2	writhe_
writhed	14	38	962	2	writhed
writhen	13	40	786	2	writhen
writhers	14	39	898	2	writhers
writhes	13	48	1170	2	writhes
wuthers	13	37	1152	2	wuthers
zithern	19	44	702	2	zithern
zithers	19	39	1197	2	zithers

Search took 8 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	1.143	156335.1
2	DLD Change Limit	82551	157	6.186	13344.8
3	Display Results	157	157	0.110	1427.3
	(SQL Overall)	178691	157	7.439	24020.8