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

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

45 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
gyppers	15	23	550	(None)
gippers	12	32	1208	1	gippers
gypper	14	34	729	1	gypper_
boppers	13	39	1192	2	boppers
cappers	13	44	1940	2	cappers
coppers	13	35	1975	2	coppers
cuppers	13	37	1221	2	cuppers
cyphers	17	31	675	2	cyphers
dippers	12	36	1518	2	dippers
gapers	9	45	2047	2	g_apers
gaspers	10	50	1413	2	gaspers
gawpers	13	44	831	2	gawpers
gipper	11	42	1530	2	gipper_
gophers	13	3	898	2	gophers
gripers	10	40	1146	2	gripers
grippers	13	35	813	2	grippers
gropers	10	48	1385	2	gropers
gulpers	10	29	901	2	gulpers
gypped	15	37	711	2	gyppe_d
gypsters	14	3	402	2	gypsters
hoppers	14	31	1514	2	hoppers
hypers	14	48	1191	2	hy_pers
kippers	15	32	1143	2	kippers
lappers	11	37	1746	2	lappers
lippers	11	34	1644	2	lippers
loppers	11	30	1410	2	loppers
mappers	13	33	1378	2	mappers
moppers	13	34	1246	2	moppers
nappers	11	42	1486	2	nappers
nippers	11	30	1262	2	nippers
peppers	10	33	1144	2	peppers
poppers	10	34	1486	2	poppers
rappers	11	36	1844	2	rappers
rippers	11	41	1503	2	rippers
sappers	11	35	1890	2	sappers
sippers	11	31	1775	2	sippers
suppers	11	33	1470	2	suppers
syphers	15	31	727	2	syphers
tappers	11	34	1654	2	tappers
tippers	11	34	1435	2	tippers
toppers	11	39	1460	2	toppers
uppers	10	29	1229	2	_uppers
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.360	496363.9
2	DLD Change Limit	107671	45	3.250	33129.5
3	Display Results	45	45	0.013	3461.5
	(SQL Overall)	178691	45	3.623	49321.3