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

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

103 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
cupper	12	43	1386	(None)
capper	12	44	2198	1	capper
copper	12	43	2189	1	copper
crupper	13	33	856	1	crupper
cupped	13	44	1398	1	cupped
cuppers	13	37	1221	1	cuppers
cuppier	13	6	832	1	cuppier
scupper	13	6	742	1	scupper
supper	10	41	1543	1	supper
upper	9	37	1426	1	_upper
bopper	12	38	1383	2	bopper
bumper	12	37	1434	2	bumper
camper	12	47	2221	2	camper
caper	9	48	3162	2	c_aper
capped	13	47	2185	2	capped
cappers	13	44	1940	2	cappers
carper	10	49	2363	2	carper
chipper	16	39	1258	2	chipper
chopper	16	36	1189	2	chopper
cipher	13	37	1026	2	cipher
clapper	13	40	1186	2	clapper
clipper	13	37	1032	2	clipper
cooper	10	42	2112	2	cooper
coper	9	53	3609	2	c_oper
copier	10	37	2289	2	copier
copped	13	52	2125	2	copped
coppers	13	35	1975	2	coppers
coppery	16	40	939	2	coppery
copter	10	98	2201	2	copter
coupler	11	47	1301	2	coupler
crapper	13	39	1319	2	crapper
cropper	13	33	1296	2	cropper
cruppers	14	31	732	2	cruppers
cuber	9	52	2253	2	cu_ber
culler	8	43	2225	2	culler
culver	11	30	1063	2	culver
cumber	12	40	1670	2	cumber
cummer	12	44	1459	2	cummer
cunner	8	39	1500	2	cunner
cupel	9	5	1430	2	cu_pel
cupeler	11	7	748	2	cupeler
cuppa	11	39	852	2	cupp_a
cuppas	12	45	859	2	cuppas
cuppy	14	47	1038	2	cupp_y
curber	10	45	1705	2	curber
curer	7	50	3075	2	cu_rer
curler	8	52	2132	2	curler
curser	8	47	2147	2	curser
curter	8	53	2008	2	curter
cusped	11	43	1204	2	cusped
cusser	8	60	1609	2	cusser
cuter	7	47	2823	2	cu_ter
cutler	8	47	1803	2	cutler
cutter	8	45	2100	2	cutter
cypher	16	30	659	2	cypher
dapper	11	40	1663	2	dapper
dipper	11	40	1779	2	dipper
dumper	11	46	1521	2	dumper
duper	8	55	1900	2	du_per
dupped	12	44	1164	2	dupped
gipper	11	42	1530	2	gipper
gulper	9	34	1021	2	gulper
gypper	14	34	729	2	gypper
hepper	13	34	1266	2	hepper
hipper	13	38	1802	2	hipper
hopper	13	42	1848	2	hopper
humper	13	41	1588	2	humper
jumper	17	36	1237	2	jumper
kipper	14	34	1421	2	kipper
lapper	10	43	1995	2	lapper
lipper	10	42	1963	2	lipper
lopper	10	37	1720	2	lopper
lumper	10	38	1665	2	lumper
mapper	12	45	1609	2	mapper
mopper	12	62	1500	2	mopper
mumper	12	35	1352	2	mumper
napper	10	37	1828	2	napper
nipper	10	37	1571	2	nipper
pepper	9	35	1294	2	pepper
popper	9	36	1596	2	popper
pulper	10	35	1327	2	pulper
pumper	12	44	1555	2	pumper
pupped	10	50	1327	2	pupped
puppet	9	35	1459	2	puppet
quipper	20	9	582	2	quipper
rapper	10	46	2157	2	rapper
ripper	10	35	1865	2	ripper
sapper	10	38	2235	2	sapper
scuppers	14	4	654	2	scuppers
sipper	10	39	2099	2	sipper
super	7	49	2448	2	su_per
supped	11	44	1570	2	supped
suppers	11	33	1470	2	suppers
suppler	11	4	843	2	suppler
tapper	10	44	1961	2	tapper
tipper	10	39	1841	2	tipper
topper	10	38	1760	2	topper
tupped	11	40	1323	2	tupped
upped	10	37	1516	2	_upped
uppers	10	29	1229	2	_uppers
yapper	13	37	1451	2	yapper
zapper	19	34	1402	2	zapper
zipper	19	38	1312	2	zipper

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.356	501941.0
2	DLD Change Limit	82551	103	2.486	33206.4
3	Display Results	103	103	0.030	3433.3
	(SQL Overall)	178691	103	2.872	62218.3