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

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

76 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
wimpy	15	59	1192	(None)
gimpy	13	52	1223	1	gimpy
jimpy	19	52	1082	1	jimpy
wimp	11	55	2152	1	wimp_
wimps	12	52	1380	1	wimps
wispy	13	72	1097	1	wispy
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
gimp	9	61	2404	2	gimp_
gimps	10	59	1520	2	gimps
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
swampy	16	43	723	2	swampy
swimmy	16	23	435	2	swimmy
tippy	12	54	1179	2	tippy
vampy	15	53	940	2	vampy
waspy	13	54	1099	2	waspy
weepy	13	42	1259	2	weepy
whimsy	17	37	522	2	whimsy
whippy	19	38	584	2	whippy
wicopy	16	3	403	2	wicopy
widdy	13	61	1218	2	widdy
wifey	14	49	1367	2	wifey
wifty	14	42	1209	2	wifty
wiggy	13	45	1073	2	wiggy
willy	11	53	2191	2	willy
wily	10	64	2881	2	wi_ly
wimped	14	42	1151	2	wimped
wimple	13	36	1136	2	wimple
windy	12	61	1810	2	windy
winey	11	53	2543	2	winey
wingy	12	65	2103	2	wingy
winy	10	70	3432	2	wi_ny
wipe	9	48	3028	2	wi_pe
wiry	10	64	2283	2	wi_ry
wisp	9	71	2407	2	wisp_
wisps	10	52	1418	2	wisps
withy	14	48	1376	2	withy
witty	11	47	1701	2	witty
womby	15	59	1009	2	womby
zippy	21	51	874	2	zippy

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	53800	0.626	285448.9
2	DLD Change Limit	53800	76	3.263	16487.9
3	Display Results	76	76	0.046	1652.2
	(SQL Overall)	178691	76	3.935	45410.7