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

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

105 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
grumes	9	44	1555	(None)
brumes	10	64	1707	1	brumes
glumes	9	45	1681	1	glumes
grimes	9	46	1903	1	grimes
grues	6	57	2196	1	gru_es
grume	8	62	1816	1	grume_
grumps	11	45	1057	1	grumps
arames	8	46	2257	2	arames
arums	7	55	1783	2	arum_s
blumes	10	59	1779	2	blumes
bromes	10	47	1976	2	bromes
brume	9	58	1798	2	brume_
brutes	8	61	1868	2	brutes
bruxes	15	48	1102	2	bruxes
cremes	10	45	1799	2	cremes
crimes	10	55	2158	2	crimes
cruces	10	51	1754	2	cruces
crudes	9	62	1862	2	crudes
crumbs	12	40	923	2	crumbs
crumps	12	45	1434	2	crumps
cruses	8	81	2771	2	cruses
cruxes	15	49	1156	2	cruxes
drums	8	54	1587	2	drum_s
drupes	9	49	1265	2	drupes
druses	7	55	1725	2	druses
flumes	11	51	1973	2	flumes
frames	11	51	1986	2	frames
frumps	13	47	978	2	frumps
fumes	10	52	2470	2	_fumes
games	8	62	3855	2	g_ames
gauges	8	59	1599	2	gauges
gaumed	10	46	1032	2	gaumed
gaums	8	62	1707	2	gaum_s
gauzes	16	47	1063	2	gauzes
geums	8	54	1411	2	geum_s
gimmes	11	30	1090	2	gimmes
glimes	9	47	1752	2	glimes
glues	6	51	2568	2	glu_es
glume	8	51	2046	2	glume_
glums	8	46	2142	2	glum_s
glutes	7	45	1767	2	glutes
gnomes	9	38	1297	2	gnomes
gouges	8	63	1869	2	gouges
graces	9	45	2349	2	graces
grades	8	49	2631	2	grades
gramas	9	43	1720	2	gramas
grammes	12	36	1132	2	grammes
gramps	11	41	1427	2	gramps
grams	8	53	2731	2	gram_s
grapes	9	51	2312	2	grapes
grates	7	54	2988	2	grates
graves	10	46	2400	2	graves
grazes	16	45	1964	2	grazes
grebes	9	38	1361	2	grebes
grees	6	51	3247	2	gr_ees
grides	8	44	2236	2	grides
grime	8	50	2132	2	grime_
grimed	10	47	1409	2	grimed
gripes	9	46	1987	2	gripes
gropes	9	52	2040	2	gropes
grouses	8	46	1654	2	grouses
groves	10	43	1810	2	groves
grubs	8	63	1260	2	gru_bs
grudges	10	34	942	2	grudges
grue	5	58	2571	2	gru_e_
gruel	6	60	1474	2	gru_el
gruels	7	39	1015	2	gruels
gruffs	13	33	745	2	gruffs
grum	7	56	2508	2	grum__
grumbles	13	28	887	2	grumbles
grummer	12	33	878	2	grummer
grummest	13	28	636	2	grummest
grummet	12	29	887	2	grummet
grummets	13	27	503	2	grummets
grumose	10	3	572	2	grumose
grumous	10	8	660	2	grumous
grump	10	51	1531	2	grum_p
grumped	13	33	733	2	grumped
grumpy	14	49	815	2	grumpy
grunges	9	33	1040	2	grunges
grunts	7	55	1185	2	grunts
gudes	7	45	2081	2	g_udes
gules	6	48	3104	2	g_ules
gums	7	50	3094	2	g_um_s
gurges	8	47	1686	2	gurges
neumes	8	31	1262	2	neumes
plumes	10	43	1813	2	plumes
primes	10	42	2526	2	primes
prudes	9	42	1544	2	prudes
prunes	8	34	1906	2	prunes
rimes	7	56	3454	2	_rimes
rubes	7	49	2841	2	_rubes
rues	4	60	4448	2	_ru_es
rules	5	52	3425	2	_rules
rumen	7	44	1950	2	_rumen
rumens	8	36	1181	2	_rumens
rumps	9	59	2229	2	_rumps
rums	6	48	3347	2	_rum_s
runes	5	55	3022	2	_runes
ruses	5	61	3658	2	_ruses
spumes	10	213	1488	2	spumes
truces	8	49	1633	2	truces
trues	5	49	2532	2	tru_es
trumps	10	46	1188	2	trumps
uruses	6	36	1650	2	uruses

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	105	2.763	29877.3
3	Display Results	105	105	0.033	3181.8
	(SQL Overall)	178691	105	2.906	61490.4