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

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

81 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
gimpy	13	52	1223	(None)
gimp	9	61	2404	1	gimp_
gimps	10	59	1520	1	gimps
jimpy	19	52	1082	1	jimpy
wimpy	15	59	1192	1	wimpy
bumpy	14	47	1505	2	bumpy
campy	14	51	1618	2	campy
crimpy	15	48	939	2	crimpy
dimly	11	49	1348	2	dimly
dimply	14	33	974	2	dimply
dippy	13	51	1154	2	dippy
dumpy	13	54	1475	2	dumpy
gamay	11	64	1911	2	gamay
gamey	11	53	2055	2	gamey
gammy	13	55	1489	2	gammy
gamp	9	88	3321	2	gamp_
gamps	10	53	2371	2	gamps
gamy	10	54	2753	2	gam_y
gappy	13	62	1203	2	gappy
gapy	10	63	2091	2	g_apy
gemmy	13	52	1105	2	gemmy
giddy	11	58	1020	2	giddy
gilly	9	43	2163	2	gilly
gimel	8	3	1335	2	gimel
gimme	10	24	1134	2	gimme
gimped	12	39	1147	2	gimped
ginny	9	53	1457	2	ginny
gip	6	76	4536	2	gi_p_
gips	7	56	3292	2	gi_ps
gipsy	11	57	954	2	gipsy
girly	9	44	1529	2	girly
glumpy	14	52	719	2	glumpy
goopy	11	58	1662	2	goopy
grapy	11	54	1643	2	grapy
grimly	12	45	993	2	grimly
grimy	11	43	1260	2	grim_y
grippy	14	44	776	2	grippy
gripy	11	51	1525	2	gripy
grumpy	14	49	815	2	grumpy
guimpe	11	3	472	2	guimpe
gulpy	11	46	1276	2	gulpy
gummy	13	54	1365	2	gummy
guppy	13	52	1127	2	guppy
hempy	15	49	1276	2	hempy
hippy	15	51	1279	2	hippy
humpy	15	51	1567	2	humpy
immy	11	46	1183	2	_immy
imp	7	66	2697	2	_imp_
impi	8	54	1579	2	_impi
imply	12	49	1184	2	_imply
imps	8	62	2112	2	_imps
jimmy	19	53	850	2	jimmy
jimp	15	56	1846	2	jimp_
jimply	20	39	748	2	jimply
jumpy	19	57	1281	2	jumpy
limby	12	57	1407	2	limby
limey	10	47	2104	2	limey
limp	8	84	3249	2	limp_
limpa	9	70	1446	2	limpa
limply	13	38	1003	2	limply
limps	9	55	2267	2	limps
limpsy	13	51	684	2	limpsy
limy	9	57	2771	2	lim_y
lippy	12	45	1190	2	lippy
lumpy	12	66	1591	2	lumpy
nippy	12	49	1111	2	nippy
pimp	10	60	2490	2	pimp_
pimply	15	32	921	2	pimply
pimps	11	46	1698	2	pimps
pipy	11	54	2151	2	pi_py
rimy	9	66	2128	2	rim_y
simp	8	52	2877	2	simp_
simply	13	30	1052	2	simply
simps	9	47	1976	2	simps
skimpy	17	47	572	2	skimpy
tippy	12	54	1179	2	tippy
vampy	15	53	940	2	vampy
wimp	11	55	2152	2	wimp_
wimps	12	52	1380	2	wimps
wispy	13	72	1097	2	wispy
zippy	21	51	874	2	zippy

Search took 2 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.313	570897.8
2	DLD Change Limit	53800	81	1.360	39558.8
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	1.703	104927.2