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

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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
Check this box to automatically increase the Change Limit after seconds.

96 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
undy	8	50	1516	(None)
unde	5	58	2548	1	unde
undo	5	56	2015	1	undo
and	4	72	4417	2	and_
ands	5	78	3361	2	ands
any	6	84	4049	2	an_y
aunty	8	59	1981	2	aunty
bandy	11	48	2418	2	bandy
bendy	11	50	1725	2	bendy
body	10	74	2567	2	body
buddy	12	48	1263	2	buddy
bund	7	55	3066	2	bund_
bunds	8	55	2354	2	bunds
bundt	8	58	2485	2	bundt
bunny	10	47	1580	2	bunny
candy	11	51	1982	2	candy
cuddy	12	51	1197	2	cuddy
curdy	11	59	1652	2	curdy
dandy	10	44	1670	2	dandy
didy	9	91	2151	2	didy
duddy	11	49	1103	2	duddy
dungy	10	47	1364	2	dungy
eddy	9	39	1209	2	eddy
end	4	68	3435	2	end_
ends	5	65	2852	2	ends
envy	10	4	1125	2	envy
fuddy	13	52	1115	2	fuddy
fund	8	56	2498	2	fund_
fundi	9	68	1491	2	fundi
funds	9	41	1925	2	funds
funky	15	43	1513	2	funky
funny	11	46	1483	2	funny
gunky	13	55	1411	2	gunky
gunny	9	44	1366	2	gunny
handy	12	55	2087	2	handy
hunky	15	54	1773	2	hunky
inby	9	53	1566	2	inby
inky	11	53	2158	2	inky
inly	7	56	2221	2	inly
junky	19	45	1323	2	junky
lady	8	65	2715	2	lady
lindy	9	69	1831	2	lindy
luny	7	73	2413	2	lun_y
maundy	12	50	678	2	maundy
muddy	12	38	1223	2	muddy
nay	6	69	5277	2	_nay
nude	5	66	2627	2	nude
oldy	8	53	1684	2	oldy
only	7	53	1972	2	only
pandy	11	50	2117	2	pandy
punky	14	44	1939	2	punky
punny	10	42	1771	2	punny
punty	10	60	2161	2	punty
puny	9	55	2699	2	pun_y
randy	9	50	2208	2	randy
rindy	9	57	1739	2	rindy
ruddy	10	45	1175	2	ruddy
runny	8	46	1348	2	runny
runty	8	61	1904	2	runty
sandy	9	42	2113	2	sandy
sundry	10	5	794	2	sundry
sunny	8	49	1774	2	sunny
tidy	8	68	2242	2	tidy
tody	8	63	2721	2	tody
tunny	8	65	1503	2	tunny
udo	4	90	2730	2	u_do
ugly	8	60	1238	2	ugly
un	2	83	4114	2	un__
unai	4	48	2478	2	unai
unary	8	3	1599	2	unary
unau	4	39	2415	2	unau
unbe	6	53	1927	2	unbe
unci	6	50	1946	2	unci
unco	6	60	2140	2	unco
uncoy	10	41	1141	2	uncoy
undee	6	53	2727	2	undee
under	6	46	2421	2	under
undid	7	24	1536	2	undid
undue	6	67	1555	2	undue
unduly	10	3	782	2	unduly
undyed	11	3	814	2	undyed
unify	11	36	1111	2	unify
unit	4	51	4007	2	unit
unity	8	49	1849	2	unity
unlay	8	46	1370	2	unlay
uns	3	59	3676	2	un_s
unsay	8	32	1284	2	unsay
untidy	10	5	915	2	untidy
unto	4	58	2428	2	unto
upby	11	3	906	2	upby
updo	7	67	1288	2	updo
updry	11	3	548	2	updry
urd	4	64	2705	2	urd_
urds	5	59	2243	2	urds
wady	11	53	2499	2	wady
windy	12	61	1810	2	windy

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.280	638182.1
2	DLD Change Limit	29872	96	0.876	34100.5
3	Display Results	96	96	0.030	3200.0
	(SQL Overall)	178691	96	1.186	150666.9