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

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

212 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
with	10	57	3047	(None)
kith	11	58	2636	1	kith
pith	9	54	3269	1	pith
sith	7	54	3515	1	sith
swith	11	59	1740	1	swith
wich	12	57	2474	1	wich
width	12	3	1096	1	width
wish	10	72	2873	1	wish
wit	6	65	6377	1	wit_
witch	13	45	1756	1	witch
wite	7	54	4327	1	wite
withe	11	52	2023	1	withe
withy	14	48	1376	1	withy
wits	7	60	4487	1	wits
airth	8	56	2102	2	airth
ait	3	80	9390	2	ait_
aitch	10	52	1616	2	aitch
aits	4	63	5553	2	aits
baith	10	80	2313	2	baith
bath	9	59	4008	2	bath
beth	9	66	2923	2	beth
birth	10	56	1987	2	birth
bit	5	70	7090	2	bit_
bitch	12	50	1776	2	bitch
bite	6	65	4700	2	bite
bits	6	61	4816	2	bits
bitt	6	55	4581	2	bitt
both	9	65	3343	2	both
brith	10	49	2437	2	brith
cite	6	56	4034	2	cite
city	9	51	2262	2	city
dish	8	63	2833	2	dish
dit	4	70	7133	2	dit_
dita	5	60	3252	2	dita
ditch	11	50	1509	2	ditch
dite	5	55	4755	2	dite
dits	5	64	5052	2	dits
ditz	14	69	2951	2	ditz
doth	8	62	2571	2	doth
eath	7	57	3566	2	eath
eth	6	66	3098	2	_eth
faith	11	56	2085	2	faith
fifth	14	52	1092	2	fifth
filth	11	50	1582	2	filth
firth	11	58	1953	2	firth
fish	10	69	2627	2	fish
fit	6	63	6545	2	fit_
fitch	13	48	1687	2	fitch
fits	7	60	4346	2	fits
frith	11	59	2203	2	frith
girth	9	56	1884	2	girth
git	4	62	6605	2	git_
gite	5	54	3861	2	gite
gits	5	57	4459	2	gits
goth	8	68	2508	2	goth
grith	9	55	2037	2	grith
hath	10	59	3391	2	hath
heth	10	70	2802	2	heth
high	11	66	1992	2	high
hit	6	65	6919	2	hit_
hitch	13	45	1547	2	hitch
hits	7	55	4513	2	hits
ich	8	62	2774	2	_ich
it	2	84	5568	2	_it_
itch	9	56	1917	2	_itch
its	3	55	3883	2	_its
kit	7	85	5988	2	kit_
kite	8	53	3824	2	kite
kithe	12	59	1745	2	kithe
kiths	12	58	1497	2	kiths
kits	8	64	4177	2	kits
laith	8	57	2210	2	laith
lath	7	66	4038	2	lath
lich	9	62	3084	2	lich
lit	3	93	7731	2	lit_
lite	4	70	5454	2	lite
lithe	8	49	2201	2	lithe
litho	8	65	1378	2	litho
lits	4	62	5249	2	lits
litu	4	76	3156	2	litu
loth	7	61	3213	2	loth
math	9	54	3745	2	math
meth	9	58	2784	2	meth
mirth	10	64	1889	2	mirth
mite	6	62	4941	2	mite
mitt	6	61	4549	2	mitt
mity	9	55	2821	2	mity
moth	9	67	3133	2	moth
myth	12	67	1543	2	myth
nigh	8	52	2066	2	nigh
ninth	8	3	1458	2	ninth
nit	3	70	6594	2	nit_
nite	4	59	4358	2	nite
nits	4	57	4164	2	nits
nth	6	63	2059	2	_nth
oath	7	61	3215	2	oath
path	9	91	3491	2	path
pish	9	61	2791	2	pish
pit	5	64	7192	2	pit_
pita	6	54	3643	2	pita
pitch	12	50	1841	2	pitch
piths	10	58	1754	2	piths
pithy	13	56	1446	2	pithy
pits	6	63	4874	2	pits
pity	9	60	3193	2	pity
rath	7	60	3766	2	rath
rich	9	70	2554	2	rich
rite	4	58	4945	2	rite
ritz	13	51	2998	2	ritz
ruth	7	68	2599	2	ruth
saith	8	58	2655	2	saith
sidh	8	62	2299	2	sidh
sigh	8	56	2589	2	sigh
sinh	7	62	3804	2	sinh
sit	3	58	7775	2	sit_
site	4	70	5241	2	site
sits	4	50	5020	2	sits
sixth	15	55	1223	2	sixth
smith	10	78	1805	2	smith
soth	7	59	3252	2	soth
swath	11	59	2038	2	swath
swish	11	51	1482	2	swish
switch	14	45	891	2	switch
swithe	12	40	1068	2	swithe
teth	7	63	2789	2	teth
tilth	8	55	1536	2	tilth
tit	3	67	7105	2	tit_
tithe	8	53	1970	2	tithe
titi	4	71	3062	2	titi
tits	4	61	4504	2	tits
twit	7	63	2906	2	twit_
twitch	14	40	616	2	twitch
twits	8	60	1579	2	twits
vita	7	58	2852	2	vita
wait	7	55	5369	2	wait_
waits	8	83	3352	2	waits
wash	10	60	3381	2	wash
wat	6	73	7892	2	wat_
watch	13	56	1706	2	watch
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
weigh	12	54	1251	2	weigh
wet	6	59	6662	2	wet_
wets	7	59	4029	2	wets
which	16	39	1008	2	which
whish	14	45	1292	2	whish
whit	10	48	3417	2	whit_
white	11	49	2030	2	white
whits	11	59	2382	2	whits
whity	14	55	1347	2	whity
wick	13	57	2630	2	wick
wide	8	52	3541	2	wide
widths	13	3	512	2	widths
wife	10	52	2802	2	wife
wifty	14	42	1209	2	wifty
wig	7	67	4038	2	wi_g
wight	12	37	2557	2	wight
wigs	8	49	3125	2	wigs
wild	8	51	2651	2	wild
wile	7	59	4437	2	wile
will	7	57	3751	2	will
wilt	7	62	4629	2	wilt
wilts	8	50	2350	2	wilts
wily	10	64	2881	2	wily
wimp	11	55	2152	2	wimp
win	6	64	5629	2	wi_n
winch	13	50	1666	2	winch
wind	8	55	3385	2	wind
wine	7	49	5342	2	wine
wing	8	63	3922	2	wing
wink	11	64	3502	2	wink
wino	7	59	3361	2	wino
wins	7	59	4917	2	wins
winy	10	70	3432	2	winy
wipe	9	48	3028	2	wipe
wire	7	58	3981	2	wire
wiry	10	64	2283	2	wiry
wis	6	65	5233	2	wi_s
wise	7	57	3734	2	wise
wisha	11	49	1085	2	wisha
wisp	9	71	2407	2	wisp
wiss	7	56	3054	2	wiss
wist	7	80	4929	2	wist
wists	8	67	2852	2	wists
witan	8	38	1650	2	witan
witchy	17	46	859	2	witchy
wited	9	47	2714	2	wited
wites	8	55	3696	2	wites
withal	12	3	893	2	withal
withed	13	44	1623	2	withed
wither	12	43	2135	2	wither
withes	12	46	2084	2	withes
within	12	36	1138	2	within
witty	11	47	1701	2	witty
wive	10	59	3175	2	wive
wiz	15	64	3415	2	wi_z
worth	11	71	2052	2	worth
wot	6	104	6748	2	wot_
wots	7	63	4289	2	wots
wraith	12	5	860	2	wraith
wrath	11	57	1587	2	wrath
writ	7	55	3791	2	writ_
write	8	55	2283	2	write
writhe	12	53	1070	2	writhe
writs	8	66	2438	2	writs
wroth	11	68	1588	2	wroth
wych	15	40	1188	2	wych
wyte	10	60	1864	2	wyte
yirth	11	65	1375	2	yirth
zit	12	60	4999	2	zit_
ziti	13	60	2237	2	ziti
zits	13	60	3029	2	zits

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	29872	0.313	570897.8
2	DLD Change Limit	29872	212	0.813	36742.9
3	Display Results	212	212	0.060	3533.3
	(SQL Overall)	178691	212	1.186	150666.9