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

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

77 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
grimacer	13	6	396	(None)
grimace	12	5	508	1	grimace_
grimaced	14	6	331	1	grimaced
grimacers	14	6	355	1	grimacers
grimaces	13	5	538	1	grimaces
grimier	10	32	1043	2	grim_ier
grimmer	12	35	1009	2	grim_mer
animater	10	15	1239	3	animater
bracer	10	46	2058	3	br__acer
brimmer	13	34	880	3	brim_mer
crimmer	13	33	1077	3	crim_mer
crimper	13	65	1042	3	crim_per
crimpier	14	28	732	3	crimpier
geomancer	14	4	375	3	geomancer
gimpier	12	24	794	3	g_impier
glimmer	12	43	771	3	glim_mer
glimpser	13	4	266	3	glimpser
grace	8	51	2454	3	gr__ace_
graced	10	52	1790	3	gr__aced
graces	9	45	2349	3	gr__aces
grader	8	49	1969	3	gr__ader
grater	7	46	2544	3	gr__ater
graver	10	50	1859	3	gr__aver
grayer	10	60	1454	3	gr__ayer
grazer	16	48	1576	3	gr__azer
greaser	8	39	1308	3	gr_easer
greater	8	44	1649	3	gr_eater
gridder	10	36	776	3	gri_dder
griever	11	3	603	3	gri_ever
grifter	11	38	1049	3	gri_fter
griller	8	45	1335	3	gri_ller
grimacing	15	4	403	3	grimacing
grime	8	50	2132	3	grim__e_
grimed	10	47	1409	3	grim__ed
grimes	9	46	1903	3	grim__es
grinder	9	33	1239	3	gri_nder
grinner	8	32	923	3	gri_nner
griper	9	41	1461	3	gri__per
gripier	10	32	1032	3	gri_pier
gripper	12	44	1071	3	gri_pper
grippier	13	5	520	3	grippier
grislier	9	3	579	3	grislier
grister	8	39	1541	3	gri_ster
gritter	8	39	1335	3	gri_tter
grittier	9	31	626	3	grittier
grizzler	17	33	503	3	grizzler
groaner	8	25	1013	3	gr_oaner
grocer	9	42	1214	3	gr__ocer
grumbler	13	86	668	3	grumbler
grummer	12	33	878	3	grum_mer
grumpier	13	3	480	3	grumpier
imager	9	10	812	3	__imager
krimmer	15	37	687	3	krim_mer
macer	9	121	2694	3	___macer
prefacer	15	3	798	3	prefacer
pricer	10	39	1829	3	pri__cer
primacies	15	4	845	3	primacies
primacy	16	3	560	3	primac_y
primage	12	16	914	3	primage_
primages	13	15	927	3	primages
primate	11	15	1628	3	primate_
primates	12	15	1593	3	primates
primavera	16	4	240	3	primavera
primer	10	51	1868	3	prim__er
primmer	13	43	1016	3	prim_mer
privater	13	15	853	3	privater
racer	7	52	3302	3	_r__acer
remaker	13	38	1317	3	_remaker
ricer	7	47	2661	3	_ri__cer
rimer	7	54	2924	3	_rim__er
rimier	8	39	1627	3	_rim_ier
rimmer	10	35	1603	3	_rim_mer
romancer	12	4	729	3	_romancer
tracer	8	48	2023	3	tr__acer
trimer	8	57	1715	3	trim__er
trimeter	10	3	1008	3	trimeter
trimmer	11	36	1083	3	trim_mer

Search took 7 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.406	440125.6
2	DLD Change Limit	146162	77	6.530	22383.2
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.966	25651.9