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

Here are the results of your fuzzy-string dictionary search for “glimpser” with Change Limit: [1] [2] [3] [4]

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.

83 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
glimpser	13	4	266	(None)
glimpse	12	3	376	1	glimpse_
glimpsed	14	4	277	1	glimpsed
glimpsers	14	4	219	1	glimpsers
glimpses	13	4	395	1	glimpses
gimpier	12	24	794	2	g_impier
glimmer	12	43	771	2	glim_mer
glumpier	13	3	487	2	glumpier
limper	10	41	1785	2	_limp_er
limpsey	14	36	509	2	_limpsey
limpsier	12	3	443	2	_limpsier
slimpsier	13	4	302	2	slimpsier
aglimmer	13	4	234	3	aglim_mer
blimps	12	58	815	3	blimps__
clamper	13	40	1299	3	clamp_er
climber	13	44	913	3	clim_ber
clipper	13	37	1032	3	cli_pper
clumpier	14	3	558	3	clumpier
crimper	13	65	1042	3	crimp_er
crimpier	14	28	732	3	crimpier
eclipser	12	4	279	3	ecli_pser
flimsier	13	4	413	3	flimsier
flipper	14	38	914	3	fli_pper
gimped	12	39	1147	3	g_imp_ed
gimps	10	59	1520	3	g_imps__
gipper	11	42	1530	3	g_i_pper
glibber	12	3	516	3	gli_bber
glider	8	46	1426	3	gli__der
glime	8	56	2019	3	glim__e_
glimed	10	53	1228	3	glim__ed
glimes	9	47	1752	3	glim__es
glimmers	13	39	615	3	glim_mers
glimpsing	15	4	259	3	glimpsing
glims	8	74	1767	3	glim_s__
glintier	9	4	570	3	glintier
glister	8	40	1334	3	gli_ster
glitter	8	42	1180	3	gli_tter
glitzier	18	3	359	3	glitzier
gloppier	13	5	467	3	gloppier
glosser	8	34	1081	3	gl_osser
glummer	12	41	798	3	glum_mer
grimacer	13	6	396	3	grimacer
grimier	10	32	1043	3	grim_ier
grimmer	12	35	1009	3	grim_mer
griper	9	41	1461	3	gri_p_er
gripier	10	32	1032	3	gri_pier
gripper	12	44	1071	3	gri_pper
grippier	13	5	520	3	grippier
grumpier	13	3	480	3	grumpier
guimpe	11	3	472	3	guimp_e_
guimpes	12	4	507	3	guimp_es
imposer	11	33	1010	3	__imposer
jimper	17	38	986	3	_jimp_er
lapser	8	41	1314	3	_l_apser
limber	10	43	1679	3	_lim_ber
limbier	11	34	911	3	_limbier
limier	8	35	1872	3	_lim_ier
limiter	9	27	1085	3	_limiter
limmer	10	43	1479	3	_lim_mer
limner	8	41	1287	3	_lim_ner
limped	11	48	1712	3	_limp_ed
limpers	11	38	1522	3	_limp_ers
limpest	11	37	1231	3	_limpest
limpet	10	35	1863	3	_limp_et
limps	9	55	2267	3	_limps__
limpsy	13	51	684	3	_limps_y
lipper	10	42	1963	3	_li_pper
lippier	11	27	1057	3	_lippier
lisper	8	41	1443	3	_lisp_er
lumper	10	38	1665	3	_lump_er
lumpier	11	34	1014	3	_lumpier
plumper	13	31	877	3	plump_er
simper	10	36	1629	3	_simp_er
simpler	11	29	1086	3	_simpler
skimpier	16	3	429	3	skimpier
slimier	9	32	1201	3	slim_ier
slimmer	11	42	1134	3	slim_mer
slimpsy	14	6	333	3	slimps_y
slimsier	10	8	521	3	slimsier
slipper	11	37	1298	3	sli_pper
slippier	12	5	654	3	slippier
whimper	17	29	772	3	whimp_er
wimpier	14	24	805	3	_wimpier

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	83	7.016	20832.7
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	7.469	23924.4