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

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

82 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
sappy	12	54	1347	(None)
gappy	13	62	1203	1	gappy
happy	15	58	1353	1	happy
nappy	12	63	1233	1	nappy
pappy	11	47	1380	1	pappy
snappy	13	6	610	1	snappy
soppy	12	51	1352	1	soppy
zappy	21	54	894	1	zappy
app	7	68	2760	2	_app_
apply	12	51	1139	2	_apply
apps	8	63	1969	2	_apps
buppy	14	48	1007	2	buppy
campy	14	51	1618	2	campy
crappy	15	44	680	2	crappy
cuppy	14	47	1038	2	cuppy
dippy	13	51	1154	2	dippy
flappy	16	5	448	2	flappy
gapy	10	63	2091	2	ga_py
guppy	13	52	1127	2	guppy
haply	13	59	1506	2	haply
harpy	13	64	1820	2	harpy
hippy	15	51	1279	2	hippy
hoppy	15	49	1235	2	hoppy
kappa	13	46	974	2	kappa
lippy	12	45	1190	2	lippy
loppy	12	59	1166	2	loppy
nappa	9	85	1186	2	nappa
nappe	9	61	1499	2	nappe
nippy	12	49	1111	2	nippy
pappi	8	48	1089	2	pappi
peppy	11	43	1036	2	peppy
poppy	11	48	1319	2	poppy
puppy	11	49	1241	2	puppy
raspy	10	65	1170	2	raspy
sadly	9	45	1912	2	sadly
saggy	10	59	1746	2	saggy
sagy	8	53	2708	2	sa_gy
sally	8	51	2971	2	sally
salp	6	45	3409	2	salp_
salpa	7	50	1835	2	salpa
salps	7	44	2324	2	salps
salty	8	55	2438	2	salty
samp	8	57	3359	2	samp_
samps	9	61	2467	2	samps
sandy	9	42	2113	2	sandy
sap	5	64	6323	2	sa_p_
sapid	8	47	2093	2	sapid
sapor	7	51	1925	2	sapor
sapped	11	44	2201	2	sapped
sapper	10	38	2235	2	sapper
sappily	14	3	716	2	sappily
saps	6	53	4637	2	sa_ps
sarky	12	55	2178	2	sarky
sassy	8	58	1381	2	sassy
satay	8	47	1846	2	satay
saucy	10	46	1516	2	saucy
saury	8	43	1722	2	saury
savoy	11	47	1388	2	savoy
savvy	14	49	750	2	savvy
say	6	72	6476	2	sa__y
scrappy	16	23	447	2	scrappy
seepy	10	47	1797	2	seepy
sepoy	10	3	1430	2	sepoy
sharpy	14	52	1103	2	sharpy
slippy	13	7	584	2	slippy
sloppy	13	9	530	2	sloppy
snippy	13	7	484	2	snippy
soapy	10	61	1478	2	soapy
sophy	13	66	1176	2	sophy
soupy	10	61	1540	2	soupy
spacy	12	54	1562	2	spacy
spay	9	66	3166	2	s_pay
spry	9	68	1912	2	s_pry
spy	8	60	2374	2	s__py
strappy	14	20	526	2	strappy
supply	13	4	689	2	supply
swampy	16	43	723	2	swampy
tippy	12	54	1179	2	tippy
vampy	15	53	940	2	vampy
waspy	13	54	1099	2	waspy
yuppy	15	48	791	2	yuppy
zippy	21	51	874	2	zippy

Search took 3 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.093	1921408.6
2	DLD Change Limit	53800	82	2.080	25865.4
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	2.219	80527.7