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

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

106 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
grunt	6	55	2354	(None)
brunt	7	57	2875	1	brunt
gaunt	6	54	3040	1	gaunt
grant	6	48	4002	1	grant
grunts	7	55	1185	1	grunts
runt	4	66	4799	1	_runt
aunt	4	65	5365	2	_aunt
blunt	7	55	2502	2	blunt
brant	7	47	4217	2	brant
brent	7	57	3413	2	brent
bruit	7	61	2672	2	bruit
brunet	8	44	1929	2	brunet
brung	8	46	1391	2	brung
brunts	8	52	1545	2	brunts
brut	6	65	3796	2	bru_t
bunt	6	58	5085	2	_bunt
burnt	7	52	3033	2	burnt
count	7	49	3205	2	count
cruet	7	48	3184	2	cruet
crust	7	58	2766	2	crust
cunt	6	62	4367	2	_cunt
daunt	6	59	2908	2	daunt
drunk	10	54	984	2	drunk
dunt	5	57	4687	2	_dunt
eruct	7	40	2235	2	eruct
erupt	7	42	2006	2	erupt
fount	8	47	2703	2	fount
front	8	50	2922	2	front
fruit	8	51	2222	2	fruit
gault	6	51	2848	2	gault
gaun	5	64	2771	2	gaun_
gent	5	69	5439	2	g_ent
gerent	7	32	2310	2	gerent
gerund	8	3	616	2	gerund
giant	6	54	3059	2	giant
glint	6	68	3018	2	glint
glut	5	63	3129	2	glu_t
gout	5	66	4600	2	gou_t
graft	9	53	2720	2	graft
gran	5	63	3501	2	gran_
grana	6	57	2209	2	grana
grand	7	51	2269	2	grand
grans	6	48	3254	2	grans
grants	7	37	2247	2	grants
grat	5	56	5128	2	gr_at
great	6	60	3424	2	great
greet	6	58	3532	2	greet
grift	9	59	2446	2	grift
grin	5	57	3372	2	grin_
grind	7	59	1756	2	grind
grins	6	54	2722	2	grins
griot	6	53	2841	2	griot
gript	8	51	2617	2	gript
grist	6	55	2987	2	grist
grit	5	52	4724	2	gr_it
groat	6	55	3197	2	groat
grot	5	59	4205	2	gr_ot
ground	8	23	1027	2	ground
grout	6	53	3042	2	grout
grub	7	72	2008	2	gru_b
grubs	8	63	1260	2	grubs
grue	5	58	2571	2	gru_e
gruel	6	60	1474	2	gruel
grues	6	57	2196	2	grues
gruff	12	47	1214	2	gruff
grum	7	56	2508	2	gru_m
grume	8	62	1816	2	grume
grump	10	51	1531	2	grump
grunge	8	35	958	2	grunge
grungy	11	34	597	2	grungy
grunted	9	33	928	2	grunted
grunter	8	31	1078	2	grunter
gruntle	8	25	705	2	gruntle
gun	4	72	4080	2	g_un_
gunk	9	54	2357	2	g_unk
guns	5	55	3348	2	g_uns
gurnet	7	49	2087	2	gurnet
gust	5	52	4070	2	g_ust
gut	4	67	5385	2	g_u_t
haunt	8	52	2913	2	haunt
hunt	7	64	4549	2	_hunt
jaunt	12	50	2527	2	jaunt
lunt	4	61	4884	2	_lunt
mount	7	41	2806	2	mount
print	7	48	3746	2	print
prune	7	51	1963	2	prune
punt	6	57	4720	2	_punt
rant	4	58	6468	2	_rant
rent	4	66	6124	2	_rent
run	3	62	4499	2	_run_
rune	4	52	3630	2	_rune
rung	5	64	2998	2	_rung
runs	4	64	3808	2	_runs
runts	5	59	2763	2	_runts
runty	8	61	1904	2	_runty
rust	4	55	4491	2	_rust
rut	3	55	6052	2	_ru_t
shunt	8	52	2651	2	shunt
strunt	6	49	1891	2	strunt
stunt	5	53	2817	2	stunt
taunt	5	55	3228	2	taunt
truant	6	3	1578	2	truant
trunk	9	47	1304	2	trunk
trust	5	54	2685	2	trust
vaunt	8	59	2531	2	vaunt
wrung	9	54	980	2	wrung

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	53800	0.356	501941.0
2	DLD Change Limit	53800	106	3.096	17377.3
3	Display Results	106	106	0.310	341.9
	(SQL Overall)	178691	106	3.762	47498.9