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

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

108 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
denser	7	41	1519	(None)
censer	8	45	1658	1	censer
denier	7	44	2069	1	denier
dense	6	59	2350	1	dense_
tenser	6	49	1943	1	tenser
bender	9	52	2330	2	bender
cense	7	51	2140	2	cense_
censed	9	40	1632	2	censed
censers	9	43	1390	2	censers
censes	8	37	2180	2	censes
censor	8	40	1129	2	censor
center	8	44	2141	2	center
dancer	9	48	1761	2	dancer
dander	8	112	2299	2	dander
danger	8	37	2282	2	danger
danker	11	43	1966	2	danker
danseur	8	3	366	2	danseur
deader	8	42	2047	2	deader
deafer	10	41	1481	2	deafer
dealer	7	41	2214	2	dealer
dearer	7	48	2280	2	dearer
debaser	10	35	1041	2	debaser
decker	13	52	1599	2	decker
deeper	9	36	1350	2	deeper
deer	5	67	3902	2	de__er
defer	9	46	1975	2	de_fer
deffer	13	44	1130	2	deffer
defier	10	51	1865	2	defier
defter	10	42	1592	2	defter
defuser	11	51	1050	2	defuser
deicer	9	41	1441	2	deicer
delver	10	49	1349	2	delver
denar	6	52	2329	2	den_ar
dene	5	66	4341	2	den_e_
denes	6	56	3972	2	den_es
denied	8	43	1863	2	denied
deniers	8	45	1518	2	deniers
denies	7	47	2964	2	denies
denned	8	42	1563	2	denned
dens	5	59	4507	2	dens__
densely	11	4	671	2	densely
densest	8	31	1247	2	densest
dented	8	41	2051	2	dented
denuder	9	16	760	2	denuder
deposer	10	40	1184	2	deposer
dernier	8	30	1194	2	dernier
desert	7	27	2549	2	de_sert
desex	13	3	1198	2	de_sex
dessert	8	29	1645	2	dessert
deter	6	50	2804	2	de_ter
deviser	11	42	1239	2	deviser
dewier	10	40	1346	2	dewier
dexter	14	38	1089	2	dexter
diner	6	56	3290	2	din_er
dinger	8	53	2367	2	dinger
dinner	7	42	1716	2	dinner
dorser	7	48	1918	2	dorser
doser	6	62	2856	2	d_oser
dosser	7	44	1797	2	dosser
douser	7	56	2163	2	douser
dowser	10	47	1608	2	dowser
dresser	8	36	1195	2	dresser
dunker	11	36	1646	2	dunker
dunner	7	39	1382	2	dunner
ender	6	43	2586	2	_ender
enserf	9	3	1076	2	_enserf
enter	5	47	2638	2	_enter
fencer	11	46	1353	2	fencer
fender	10	37	1872	2	fender
flenser	10	3	678	2	flenser
gender	8	35	1793	2	gender
geyser	10	3	651	2	geyser
leaser	6	53	2267	2	leaser
lender	7	39	2127	2	lender
lense	5	45	2343	2	lense_
lensed	7	40	1547	2	lensed
lenses	6	46	2089	2	lenses
lesser	6	35	1485	2	lesser
mender	9	35	2079	2	mender
mense	7	50	2563	2	mense_
mensed	9	39	1654	2	mensed
menses	8	42	2245	2	menses
penner	8	46	1666	2	penner
pensee	8	4	1731	2	pensee
penster	9	28	1195	2	penster
render	7	40	2414	2	render
renter	6	45	2741	2	renter
rinser	6	43	1721	2	rinser
seiser	6	53	1834	2	seiser
sender	7	38	2441	2	sender
sense	5	55	2682	2	sense_
sensed	7	39	1816	2	sensed
sensei	6	47	1259	2	sensei
senses	6	39	2394	2	senses
sensor	6	38	1384	2	sensor
teaser	6	54	2152	2	teaser
tender	7	41	2184	2	tender
tenner	6	41	1710	2	tenner
tense	5	52	2584	2	tense_
tensed	7	48	1783	2	tensed
tenses	6	47	2255	2	tenses
tensor	6	38	1267	2	tensor
tenter	6	46	2393	2	tenter
terser	6	73	1782	2	terser
vender	10	34	1842	2	vender
veneer	9	45	1169	2	veneer
venter	9	42	1872	2	venter
verser	9	45	1696	2	verser

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.343	520965.0
2	DLD Change Limit	82551	108	2.330	35429.6
3	Display Results	108	108	0.030	3600.0
	(SQL Overall)	178691	108	2.703	66108.4