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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

78 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
scend	8	55	1629	(None)
ascend	9	42	973	1	ascend
scena	7	48	1578	1	scena
scends	9	52	1300	1	scends
scene	7	72	2057	1	scene
scent	7	58	3162	1	scent
send	5	52	3729	1	s_end
shend	9	47	1997	1	shend
spend	8	56	1933	1	spend
aced	7	95	4088	2	ace_d
acned	8	75	2067	2	acned
amend	8	57	1775	2	amend
ascends	10	38	820	2	ascends
ascent	8	45	1965	2	ascent
bend	7	64	3526	2	_bend
blend	8	53	1745	2	blend
cent	6	74	5101	2	_cent
descend	11	24	815	2	descend
emend	8	62	1489	2	emend
end	4	68	3435	2	__end
fend	8	48	3297	2	_fend
fiend	9	53	1298	2	fiend
iced	7	87	2189	2	ice_d
lend	5	62	3367	2	_lend
mend	7	53	3403	2	_mend
pend	7	59	3453	2	_pend
rend	5	61	3657	2	_rend
sand	5	53	3847	2	s_and
saned	6	56	3627	2	saned
scad	7	57	2577	2	sc_ad
scald	8	48	1812	2	scald
scan	6	55	3045	2	scan_
scans	7	46	2510	2	scans
scant	7	97	3507	2	scant
scenas	8	41	1470	2	scenas
scended	11	32	987	2	scended
scenes	8	45	2035	2	scenes
scenic	10	5	1051	2	scenic
scented	10	28	1188	2	scented
scents	8	53	1702	2	scents
scold	8	54	1486	2	scold
scone	7	46	2183	2	scone
screed	9	57	1893	2	screed
scrod	8	51	1507	2	scrod
scud	7	62	2128	2	sc_ud
second	9	4	1115	2	second
secund	9	3	710	2	secund
seed	5	55	4948	2	s_eed
seen	4	69	4312	2	seen_
sen	3	60	5852	2	s_en_
sends	6	55	2824	2	s_ends
sene	4	68	4805	2	s_ene
sent	4	69	6301	2	s_ent
shed	8	65	3615	2	she_d
shends	10	53	1377	2	shends
shent	8	59	3350	2	shent
sherd	9	63	2115	2	sherd
skeed	10	50	1898	2	skeed
skene	9	61	1812	2	skene
sled	5	53	3437	2	sle_d
sned	5	60	2605	2	sne_d
sound	6	44	2002	2	sound
sped	7	60	3149	2	spe_d
speed	8	55	2662	2	speed
spends	9	47	1447	2	spends
spendy	12	49	1114	2	spendy
spent	7	55	3283	2	spent
stand	6	59	2328	2	stand
stead	6	55	2027	2	stead
steed	6	60	2494	2	steed
steno	5	47	1686	2	steno
stent	5	56	3451	2	stent
sued	5	65	3793	2	sue_d
tend	5	64	3377	2	_tend
trend	6	48	1745	2	trend
upend	8	50	1104	2	upend
vend	8	66	2642	2	_vend
wend	8	53	3045	2	_wend

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	78	1.423	37807.4
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	1.735	102991.9