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

Here are the results of your fuzzy-string dictionary search for “scent” 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
scent	7	58	3162	(None)
ascent	8	45	1965	1	ascent
cent	6	74	5101	1	_cent
scant	7	97	3507	1	scant
scena	7	48	1578	1	scena
scend	8	55	1629	1	scend
scene	7	72	2057	1	scene
scents	8	53	1702	1	scents
sent	4	69	6301	1	s_ent
shent	8	59	3350	1	shent
spent	7	55	3283	1	spent
stent	5	56	3451	1	stent
accent	10	51	1627	2	accent
agent	6	58	2964	2	agent
ament	7	60	3654	2	ament
anent	5	49	3184	2	anent
ascend	9	42	973	2	ascend
ascents	9	38	1255	2	ascents
assent	6	51	1995	2	assent
bent	6	77	5991	2	_bent
blent	7	62	3095	2	blent
brent	7	57	3413	2	brent
cant	6	63	6203	2	_cant
celt	6	56	4671	2	_celt
cento	7	66	2517	2	_cento
cents	7	47	3033	2	_cents
centu	7	61	1941	2	_centu
cunt	6	62	4367	2	_cunt
decent	9	40	2370	2	decent
dent	5	71	5841	2	_dent
descent	10	26	1629	2	descent
docent	9	29	1868	2	docent
event	8	59	2444	2	event
gent	5	69	5439	2	_gent
hent	7	66	5638	2	_hent
incent	8	33	2072	2	incent
kent	8	68	4697	2	_kent
lent	4	63	6053	2	_lent
lucent	8	3	1382	2	lucent
nascent	9	6	1052	2	nascent
nocent	8	32	1741	2	nocent
pent	6	65	5907	2	_pent
pschent	14	3	741	2	pschent
recent	8	36	3085	2	recent
rent	4	66	6124	2	_rent
saint	5	51	4707	2	saint
scan	6	55	3045	2	scan_
scans	7	46	2510	2	scans
scants	8	52	1972	2	scants
scanty	11	40	1466	2	scanty
scart	7	61	3977	2	scart
scat	6	58	4837	2	sc_at
scatt	7	60	3009	2	scatt
scenas	8	41	1470	2	scenas
scends	9	52	1300	2	scends
scenes	8	45	2035	2	scenes
scenic	10	5	1051	2	scenic
scented	10	28	1189	2	scented
scone	7	46	2183	2	scone
scoot	7	57	2915	2	scoot
scot	6	62	4261	2	sc_ot
scout	7	50	3145	2	scout
scut	6	58	3554	2	sc_ut
seat	4	75	7556	2	s_eat
secant	8	40	2329	2	secant
sect	6	74	4362	2	s_ect
seen	4	69	4312	2	seen_
sen	3	60	5852	2	s_en_
send	5	52	3729	2	s_end
sene	4	68	4805	2	s_ene
sente	5	64	3288	2	s_ente
senti	5	62	2670	2	s_enti
sept	6	58	4436	2	s_ept
set	3	66	8125	2	s_e_t
sett	4	59	4905	2	s_ett
sext	11	73	3809	2	s_ext
sheet	8	48	3696	2	sheet
shend	9	47	1997	2	shend
shunt	8	52	2651	2	shunt
silent	6	41	2584	2	silent
skeet	9	54	2918	2	skeet
skene	9	61	1812	2	skene
skint	9	56	2923	2	skint
sklent	10	36	1435	2	sklent
slant	5	52	3870	2	slant
sleet	5	56	3913	2	sleet
slept	7	57	2810	2	slept
smelt	7	47	2678	2	smelt
spelt	7	54	3019	2	spelt
spend	8	56	1933	2	spend
splent	8	47	2019	2	splent
sprent	8	45	2238	2	sprent
steno	5	47	1686	2	steno
stents	6	50	1945	2	stents
stet	4	59	4732	2	ste_t
stint	5	70	3766	2	stint
stunt	5	53	2817	2	stunt
suet	4	67	5482	2	sue_t
suint	5	56	3818	2	suint
sweat	8	56	2840	2	sweat
sweet	8	53	3052	2	sweet
swept	10	57	2060	2	swept
tent	4	61	5986	2	_tent
vent	7	60	4905	2	_vent
went	7	60	5187	2	_went

Search took 2 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.296	603685.8
2	DLD Change Limit	53800	105	1.546	34799.5
3	Display Results	105	105	0.030	3500.0
	(SQL Overall)	178691	105	1.872	95454.6