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

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

83 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
netty	8	58	1676	(None)
jetty	15	62	1258	1	jetty
natty	8	57	1914	1	natty
nett	4	66	4323	1	nett_
nettly	9	45	945	1	nettly
netts	5	53	2072	1	netts
nitty	8	54	1831	1	nitty
nutty	8	48	1687	1	nutty
petty	10	53	2029	1	petty
batty	10	54	2224	2	batty
betta	7	49	1684	2	betta
bitty	10	61	1917	2	bitty
butty	10	40	2011	2	butty
catty	10	45	2041	2	catty
cutty	10	54	1722	2	cutty
deity	9	43	1677	2	deity
ditty	9	50	1929	2	ditty
dotty	9	45	1610	2	dotty
entity	9	3	1205	2	entity
entry	8	24	1426	2	entry
fatty	11	51	1741	2	fatty
fretty	12	4	922	2	fretty
gnatty	10	33	648	2	gnatty
gutty	9	45	1699	2	gutty
hefty	14	61	1213	2	hefty
jotty	15	50	1260	2	jotty
jutty	15	49	1464	2	jutty
kitty	12	46	1456	2	kitty
knotty	13	31	522	2	knotty
lefty	11	56	1356	2	lefty
meaty	10	70	2131	2	meaty
melty	10	49	1836	2	melty
nasty	8	57	1728	2	nasty
neat	4	63	5678	2	neat_
neath	8	60	2028	2	neath
neatly	9	38	1248	2	neatly
neats	5	59	3190	2	neats
neddy	10	47	987	2	neddy
needy	9	46	1469	2	needy
nelly	8	46	1881	2	nelly
nerdy	9	50	1470	2	nerdy
nerts	5	59	2498	2	nerts
nertz	14	51	1745	2	nertz
nervy	11	46	1086	2	nervy
nest	4	55	4873	2	nest_
nests	5	57	2800	2	nests
net	3	66	7029	2	ne_t_
netop	7	3	1234	2	netop
nets	4	59	4153	2	ne_ts
netted	7	41	1871	2	netted
netter	6	37	2202	2	netter
nettle	6	45	1458	2	nettle
newly	11	46	1020	2	newly
newsy	11	48	939	2	newsy
newt	7	69	3374	2	newt_
newts	8	60	1528	2	newts
next	11	66	3108	2	next_
nifty	11	52	1163	2	nifty
nutsy	8	57	1150	2	nutsy
patty	10	47	2361	2	patty
peaty	10	57	2569	2	peaty
pesty	10	64	2171	2	pesty
petti	7	51	1945	2	petti
petto	7	60	2104	2	petto
potty	10	56	2100	2	potty
pretty	11	5	1087	2	pretty
putty	10	47	2140	2	putty
ratty	8	48	1959	2	ratty
retry	8	47	1808	2	retry
rutty	8	56	1780	2	rutty
sett	4	59	4905	2	sett_
setts	5	51	2432	2	setts
snotty	9	48	920	2	snotty
tatty	8	47	2018	2	tatty
tenty	8	61	2160	2	tenty
testy	8	54	1906	2	testy
titty	8	53	1665	2	titty
tutty	8	52	1702	2	tutty
wetly	11	45	1171	2	wetly
witty	11	47	1701	2	witty
yett	7	64	3449	2	yett_
yetts	8	67	1513	2	yetts
zesty	17	65	1216	2	zesty

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	83	1.450	37103.4
3	Display Results	83	83	0.033	2515.2
	(SQL Overall)	178691	83	1.579	113167.2