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

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

80 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
jimper	17	38	986	(None)
jumper	17	36	1237	1	jumper
limper	10	41	1785	1	limper
simper	10	36	1629	1	simper
aimer	7	59	2682	2	aim_er
bumper	12	37	1434	2	bumper
camper	12	47	2221	2	camper
crimper	13	65	1042	2	crimper
damper	11	41	1775	2	damper
diaper	9	45	1311	2	diaper
dimer	8	56	2560	2	dim_er
dimmer	11	41	1261	2	dimmer
dipper	11	40	1779	2	dipper
dumper	11	46	1521	2	dumper
gimped	12	39	1147	2	gimped
gimpier	12	24	794	2	gimpier
gipper	11	42	1530	2	gipper
hamper	13	45	1865	2	hamper
hipper	13	38	1802	2	hipper
humper	13	41	1588	2	humper
imped	10	51	1798	2	_imped
impel	9	57	1177	2	_impel
jammer	17	40	1413	2	jammer
japer	14	62	1888	2	j_aper
jasper	15	46	1038	2	jasper
jibber	17	41	1124	2	jibber
jiber	14	51	1570	2	ji_ber
jigger	15	53	1305	2	jigger
jilter	13	35	1251	2	jilter
jimp	15	56	1846	2	jimp__
jimpest	18	29	755	2	jimpest
jimply	20	39	748	2	jimply
jimpy	19	52	1082	2	jimp_y
jinker	17	40	1354	2	jinker
jitter	13	33	1499	2	jitter
jiver	15	51	1905	2	ji_ver
jivier	16	43	861	2	jivier
jumped	18	35	1155	2	jumped
jumpers	18	39	984	2	jumpers
jumpier	18	31	794	2	jumpier
kipper	14	34	1421	2	kipper
limber	10	43	1679	2	limber
limier	8	35	1872	2	limier
limmer	10	43	1479	2	limmer
limner	8	41	1287	2	limner
limped	11	48	1712	2	limped
limpers	11	38	1522	2	limpers
limpet	10	35	1863	2	limpet
lipper	10	42	1963	2	lipper
lisper	8	41	1443	2	lisper
lumper	10	38	1665	2	lumper
mimer	9	48	2576	2	mim_er
mumper	12	35	1352	2	mumper
nipper	10	37	1571	2	nipper
pamper	12	43	1666	2	pamper
pimped	13	49	1348	2	pimped
piper	9	65	2319	2	pi_per
pumper	12	44	1555	2	pumper
rimer	7	54	2924	2	rim_er
rimier	8	39	1627	2	rimier
rimmer	10	35	1603	2	rimmer
riper	7	43	2840	2	ri_per
ripper	10	35	1865	2	ripper
romper	10	42	1368	2	romper
simmer	10	41	1535	2	simmer
simpers	11	30	1412	2	simpers
simpler	11	29	1086	2	simpler
sipper	10	39	2099	2	sipper
tamper	10	46	1851	2	tamper
temper	10	39	1409	2	temper
timber	10	40	1268	2	timber
timer	7	56	2604	2	tim_er
tipper	10	39	1841	2	tipper
vamper	13	42	1265	2	vamper
viper	10	50	1730	2	vi_per
whimper	17	29	772	2	whimper
wimped	14	42	1151	2	wimped
wimpier	14	24	805	2	wimpier
wiper	10	54	2129	2	wi_per
zipper	19	38	1312	2	zipper

Search took 6 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.673	265514.1
2	DLD Change Limit	82551	80	4.813	17151.7
3	Display Results	80	80	0.060	1333.3
	(SQL Overall)	178691	80	5.546	32219.8