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

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

97 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
zipper	19	38	1312	(None)
dipper	11	40	1779	1	dipper
gipper	11	42	1530	1	gipper
hipper	13	38	1802	1	hipper
kipper	14	34	1421	1	kipper
lipper	10	42	1963	1	lipper
nipper	10	37	1571	1	nipper
ripper	10	35	1865	1	ripper
sipper	10	39	2099	1	sipper
tipper	10	39	1841	1	tipper
zapper	19	34	1402	1	zapper
zipped	20	36	1298	1	zipped
zippers	20	33	1038	1	zippers
zippier	20	30	819	1	zippier
bopper	12	38	1383	2	bopper
capper	12	44	2198	2	capper
chipper	16	39	1258	2	chipper
cipher	13	37	1026	2	cipher
clipper	13	37	1032	2	clipper
copper	12	43	2189	2	copper
cupper	12	43	1386	2	cupper
dapper	11	40	1663	2	dapper
diaper	9	45	1311	2	diaper
dipped	12	35	1749	2	dipped
dippers	12	36	1518	2	dippers
dippier	12	31	1139	2	dippier
dripper	12	34	923	2	dripper
flipper	14	38	914	2	flipper
gipped	12	48	1590	2	gipped
gippers	12	32	1208	2	gippers
gripper	12	44	1071	2	gripper
gypper	14	34	729	2	gypper
hepper	13	34	1266	2	hepper
hipped	14	43	1769	2	hipped
hippier	14	32	1210	2	hippier
hopper	13	42	1848	2	hopper
jimper	17	38	986	2	jimper
kipped	15	31	1457	2	kipped
kippen	14	29	901	2	kippen
kippers	15	32	1143	2	kippers
lapper	10	43	1995	2	lapper
limper	10	41	1785	2	limper
lipped	11	44	1954	2	lipped
lippen	10	39	1140	2	lippen
lippers	11	34	1644	2	lippers
lippier	11	27	1057	2	lippier
lisper	8	41	1443	2	lisper
lopper	10	37	1720	2	lopper
mapper	12	45	1609	2	mapper
mopper	12	62	1500	2	mopper
napper	10	37	1828	2	napper
nipped	11	36	1585	2	nipped
nippers	11	30	1262	2	nippers
nippier	11	31	983	2	nippier
pepper	9	35	1294	2	pepper
piper	9	65	2319	2	pi_per
pipier	10	49	1398	2	pipier
pipped	10	45	1654	2	pipped
popper	9	36	1596	2	popper
quipper	20	9	582	2	quipper
rapper	10	46	2157	2	rapper
riper	7	43	2840	2	ri_per
ripped	11	44	1901	2	ripped
rippers	11	41	1503	2	rippers
rippler	11	32	1010	2	rippler
sapper	10	38	2235	2	sapper
shipper	14	35	1404	2	shipper
simper	10	36	1629	2	simper
sipped	11	37	2063	2	sipped
sippers	11	31	1775	2	sippers
sippet	10	35	1939	2	sippet
skipper	15	33	957	2	skipper
slipper	11	37	1298	2	slipper
snipper	11	39	1133	2	snipper
supper	10	41	1543	2	supper
tapper	10	44	1961	2	tapper
tipped	11	44	1826	2	tipped
tippers	11	34	1435	2	tippers
tippet	10	39	1787	2	tippet
tippier	11	32	1054	2	tippier
tippler	11	34	834	2	tippler
topper	10	38	1760	2	topper
tripper	11	37	1192	2	tripper
upper	9	37	1426	2	_upper
viper	10	50	1730	2	vi_per
whipper	17	36	1138	2	whipper
wiper	10	54	2129	2	wi_per
yapper	13	37	1451	2	yapper
yipped	14	36	1328	2	yipped
yippee	13	28	1074	2	yippee
zapped	20	42	1352	2	zapped
zappers	20	39	1163	2	zappers
zappier	20	45	837	2	zappier
zinger	16	38	1670	2	zinger
zippered	22	24	482	2	zippered
zippy	21	51	874	2	zipp_y
zither	18	38	1308	2	zither

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	82551	0.326	548131.9
2	DLD Change Limit	82551	97	2.470	33421.5
3	Display Results	97	97	0.030	3233.3
	(SQL Overall)	178691	97	2.826	63231.1