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

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

114 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
withe	11	52	2023	(None)
kithe	12	59	1745	1	kithe
lithe	8	49	2201	1	lithe
swithe	12	40	1068	1	swithe
tithe	8	53	1970	1	tithe
wite	7	54	4327	1	wit_e
with	10	57	3047	1	with_
withed	13	44	1623	1	withed
wither	12	43	2135	1	wither
withes	12	46	2084	1	withes
withy	14	48	1376	1	withy
writhe	12	53	1070	1	writhe
bathe	10	58	2288	2	bathe
bite	6	65	4700	2	bit_e
blithe	11	58	1086	2	blithe
cite	6	56	4034	2	cit_e
cither	11	46	1668	2	cither
dite	5	55	4755	2	dit_e
dither	10	44	1768	2	dither
either	9	45	1742	2	either
fiche	13	46	1674	2	fiche
gighe	10	13	973	2	gighe
gite	5	54	3861	2	git_e
hither	12	44	1725	2	hither
ither	8	46	1760	2	_ither
kite	8	53	3823	2	kit_e
kith	11	58	2635	2	kith_
kithed	14	46	1301	2	kithed
kithes	13	50	1665	2	kithes
kiths	12	58	1497	2	kiths
kythe	15	50	967	2	kythe
lathe	8	56	2671	2	lathe
lethe	8	57	1730	2	lethe
lite	4	70	5454	2	lit_e
lither	9	45	2095	2	lither
litho	8	65	1378	2	litho
litre	5	54	2146	2	litre
miche	12	62	1924	2	miche
mite	6	62	4941	2	mit_e
mither	11	42	1856	2	mither
mitre	7	55	2242	2	mitre
niche	10	50	1679	2	niche
nite	4	59	4358	2	nit_e
nitre	5	75	1968	2	nitre
pith	9	54	3269	2	pith_
pithed	12	46	1561	2	pithed
piths	10	58	1754	2	piths
pithy	13	56	1446	2	pithy
rathe	8	58	2192	2	rathe
rite	4	58	4945	2	rit_e
saithe	9	47	1391	2	saithe
sidhe	9	53	1510	2	sidhe
site	4	70	5241	2	sit_e
sith	7	54	3515	2	sith_
swathe	12	55	1411	2	swathe
swith	11	59	1740	2	swith_
swither	13	37	1099	2	swither
the	6	74	3605	2	__the
tithed	10	41	1559	2	tithed
tither	9	49	2028	2	tither
tithes	9	47	2021	2	tithes
title	5	47	2107	2	title
titre	5	46	1939	2	titre
tythe	11	52	1045	2	tythe
vitae	8	42	1763	2	vitae
wether	12	33	1539	2	wether
white	11	49	2030	2	whit_e
whither	16	35	1025	2	whither
wich	12	57	2474	2	wich_
wiches	14	44	1875	2	wiches
wide	8	52	3540	2	wi_de
width	12	3	1096	2	width_
widths	13	3	512	2	widths
wife	10	52	2802	2	wi_fe
wight	12	37	2557	2	wight
wile	7	59	4437	2	wi_le
wince	10	52	2088	2	wince
wine	7	49	5342	2	wi_ne
wintle	9	40	1460	2	wintle
winze	17	50	1485	2	winze
wipe	9	48	3028	2	wi_pe
wire	7	58	3981	2	wi_re
wise	7	57	3734	2	wi_se
wish	10	72	2873	2	wish_
wisha	11	49	1085	2	wisha
wished	13	44	1751	2	wished
wisher	12	36	1706	2	wisher
wishes	12	49	2095	2	wishes
wit	6	65	6377	2	wit__
witan	8	38	1650	2	witan
witch	13	45	1756	2	witch
witched	16	30	1219	2	witched
witches	15	27	1579	2	witches
witchy	17	46	859	2	witchy
wited	9	47	2714	2	wited
wites	8	55	3696	2	wites
withal	12	3	893	2	withal
withers	13	44	1775	2	withers
withier	13	29	1049	2	withier
withies	13	39	1354	2	withies
within	12	36	1138	2	within
witney	12	35	684	2	witney
wits	7	60	4487	2	wit_s
witted	10	42	1681	2	witted
witty	11	47	1701	2	witty
wive	10	59	3175	2	wi_ve
write	8	55	2283	2	writ_e
writhed	14	38	962	2	writhed
writhen	13	40	786	2	writhen
writher	13	40	1085	2	writher
writhes	13	48	1170	2	writhes
wuther	12	45	1161	2	wuther
wyte	10	60	1864	2	wyt_e
zither	18	38	1308	2	zither

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	114	1.796	29955.5
3	Display Results	114	114	0.030	3800.0
	(SQL Overall)	178691	114	1.922	92971.4