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

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

88 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
cuppers	13	37	1221	(None)
cappers	13	44	1940	1	cappers
coppers	13	35	1975	1	coppers
cruppers	14	31	732	1	cruppers
cupper	12	43	1386	1	cupper_
scuppers	14	4	654	1	scuppers
suppers	11	33	1470	1	suppers
uppers	10	29	1229	1	_uppers
boppers	13	39	1192	2	boppers
bumpers	13	39	1205	2	bumpers
campers	13	42	2029	2	campers
capers	10	54	2814	2	c_apers
capper	12	44	2198	2	capper_
carpers	11	45	2125	2	carpers
chippers	17	35	1088	2	chippers
choppers	17	41	1046	2	choppers
ciphers	14	37	999	2	ciphers
clappers	14	33	1083	2	clappers
clippers	14	36	884	2	clippers
coopers	11	40	1948	2	coopers
copers	10	46	2984	2	c_opers
copiers	11	42	1596	2	copiers
copper	12	43	2189	2	copper_
copperas	14	30	857	2	copperas
coppery	16	40	939	2	coppery
copters	11	36	2128	2	copters
couplers	12	33	1132	2	couplers
crappers	14	40	1102	2	crappers
croppers	14	33	1148	2	croppers
crupper	13	33	856	2	crupper_
cubers	10	53	1835	2	cu_bers
cullers	9	34	1885	2	cullers
culvers	12	32	983	2	culvers
cumbers	13	45	1541	2	cumbers
cummers	13	37	1348	2	cummers
cunners	9	39	1347	2	cunners
cupelers	12	6	673	2	cupelers
cupels	10	3	1020	2	cu_pels
cuppas	12	45	859	2	cupp_as
cupped	13	44	1398	2	cuppe_d
cuppier	13	6	832	2	cuppier_
curbers	11	55	1438	2	curbers
curers	8	49	2319	2	cu_rers
curlers	9	42	1807	2	curlers
cursers	9	43	1716	2	cursers
cussers	9	42	1340	2	cussers
cutlers	9	42	1700	2	cutlers
cutters	9	42	1896	2	cutters
cyphers	17	31	675	2	cyphers
dippers	12	36	1518	2	dippers
dumpers	12	34	1266	2	dumpers
dupers	9	46	1560	2	du_pers
gippers	12	32	1208	2	gippers
gulpers	10	29	901	2	gulpers
gyppers	15	23	550	2	gyppers
hoppers	14	31	1514	2	hoppers
humpers	14	27	1352	2	humpers
jumpers	18	39	984	2	jumpers
kippers	15	32	1143	2	kippers
lappers	11	37	1746	2	lappers
lippers	11	34	1644	2	lippers
loppers	11	30	1410	2	loppers
lumpers	11	35	1448	2	lumpers
mappers	13	33	1378	2	mappers
moppers	13	34	1246	2	moppers
mumpers	13	33	1137	2	mumpers
nappers	11	42	1486	2	nappers
nippers	11	30	1262	2	nippers
peppers	10	33	1144	2	peppers
poppers	10	34	1486	2	poppers
pulpers	11	46	1228	2	pulpers
pumpers	13	31	1367	2	pumpers
puppets	10	31	701	2	puppets
quippers	21	8	481	2	quippers
rappers	11	36	1844	2	rappers
rippers	11	41	1503	2	rippers
sappers	11	35	1890	2	sappers
scupper	13	6	742	2	scupper_
sippers	11	31	1775	2	sippers
supers	8	46	2240	2	su_pers
supper	10	41	1543	2	supper_
tappers	11	34	1654	2	tappers
tippers	11	34	1435	2	tippers
toppers	11	39	1460	2	toppers
upper	9	37	1426	2	_upper_
yappers	14	40	1225	2	yappers
zappers	20	39	1163	2	zappers
zippers	20	33	1038	2	zippers

Search took 4 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	107671	0.126	1418182.5
2	DLD Change Limit	107671	88	3.466	31064.9
3	Display Results	88	88	0.033	2666.7
	(SQL Overall)	178691	88	3.625	49294.1