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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

103 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
gramps	11	41	1427	(None)
cramps	12	56	1556	1	cramps
gamps	10	53	2371	1	g_amps
gramas	9	43	1720	1	gramas
gramp	10	62	1832	1	gramp_
grampa	11	50	1017	1	grampa
grampas	12	39	925	1	grampas
grampus	12	35	631	1	grampus
grams	8	53	2731	1	gram_s
grasps	9	48	925	1	grasps
grumps	11	45	1057	1	grumps
ramps	9	62	2463	1	_ramps
tramps	10	51	1445	1	tramps
abamps	12	3	625	2	abamps
amps	8	62	3034	2	__amps
arames	8	46	2257	2	arames
camps	11	63	3026	2	_camps
champs	15	49	1568	2	champs
clamps	12	45	1508	2	clamps
cramp	11	51	2069	2	cramp_
crampy	15	47	1099	2	crampy
crams	9	62	2915	2	cram_s
craps	9	53	2864	2	cra_ps
crimps	12	46	1345	2	crimps
crumps	12	45	1434	2	crumps
damps	10	52	2041	2	_damps
dramas	9	58	1465	2	dramas
drams	8	60	2583	2	dram_s
frames	11	51	1986	2	frames
fraps	10	56	2055	2	fra_ps
frumps	13	47	978	2	frumps
gamas	8	54	3135	2	g_amas
gambs	10	57	2112	2	g_ambs
games	8	62	3855	2	g_ames
gamp	9	88	3321	2	g_amp_
gams	7	66	4888	2	g_am_s
gaps	7	60	4297	2	g_a_ps
gasps	8	54	1548	2	g_asps
gawps	11	59	1101	2	g_awps
gimps	10	59	1520	2	g_imps
glams	8	58	2293	2	glam_s
graals	7	41	1291	2	graals
grabs	8	57	1969	2	gra_bs
graces	9	45	2349	2	graces
grades	8	49	2631	2	grades
grads	7	56	2575	2	gra_ds
gradus	8	44	1121	2	gradus
grafts	10	50	1325	2	grafts
grails	7	75	1878	2	grails
grains	7	42	2309	2	grains
gram	7	70	3458	2	gram__
grama	8	56	2028	2	gram_a
gramma	11	49	980	2	gramma
grammas	12	49	977	2	grammas
gramme	11	42	1033	2	gramme
grammes	12	36	1132	2	grammes
grands	8	42	1824	2	grands
grans	6	48	3254	2	gra_ns
grants	7	37	2247	2	grants
grape	8	48	2466	2	gra_pe
grapes	9	51	2312	2	grapes
graph	11	53	1561	2	gra_ph
graphs	12	45	1015	2	graphs
grappa	11	39	644	2	grappa
grappas	12	35	710	2	grappas
grapy	11	54	1643	2	gra_py
grasp	8	48	1448	2	grasp_
grass	6	61	2520	2	gra_ss
grates	7	54	2988	2	grates
gratis	7	48	1924	2	gratis
graves	10	46	2400	2	graves
grays	9	56	2133	2	gra_ys
grazes	16	45	1964	2	grazes
grimes	9	46	1903	2	grimes
grips	8	55	2013	2	gr_ips
groups	9	42	1051	2	groups
grumes	9	44	1555	2	grumes
grump	10	51	1531	2	grump_
grumpy	14	49	815	2	grumpy
lamps	9	56	2483	2	_lamps
prams	9	61	2551	2	pram_s
preamps	13	3	661	2	preamps
primps	12	47	1182	2	primps
ramp	8	59	3400	2	_ramp_
rams	6	59	5077	2	_ram_s
ramus	7	64	1828	2	_ramus
raps	6	62	4773	2	_ra_ps
rasps	7	43	1666	2	_rasps
romps	9	46	1754	2	_romps
rumps	9	59	2229	2	_rumps
samps	9	61	2467	2	_samps
scamps	12	50	1417	2	scamps
stamps	10	56	1402	2	stamps
swamps	13	59	1026	2	swamps
tamps	9	55	2408	2	_tamps
tramp	9	63	1977	2	tramp_
trampy	13	49	925	2	trampy
trams	7	53	2767	2	tram_s
traps	7	57	2748	2	tra_ps
tromps	10	49	1170	2	tromps
trumps	10	46	1188	2	trumps
vamps	12	54	1548	2	_vamps
wraps	10	56	1715	2	wra_ps

Search took 3 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.140	1276364.3
2	DLD Change Limit	82551	103	2.266	36430.3
3	Display Results	103	103	0.030	3433.3
	(SQL Overall)	178691	103	2.436	73354.3