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

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

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.

66 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
summands	13	4	471	(None)
summand	12	3	626	1	summand_
commands	15	31	882	2	commands
summas	10	43	1316	2	summa__s
summates	12	26	1049	2	summates
summons	11	5	800	2	summon_s
sunlands	9	3	638	2	sunlands
armbands	13	5	514	3	armbands
bummalos	14	4	287	3	bummalos
command	14	39	921	3	command_
commando	15	27	575	3	commando
commandos	16	24	596	3	commandos
commends	15	30	846	3	commends
cummins	13	5	896	3	cummin_s
demands	11	43	1141	3	_demands
gormands	12	6	656	3	gormands
gourmands	13	4	331	3	gourmands
gummas	11	48	1051	3	gumma__s
humans	11	23	1243	3	hu_man_s
husbands	14	4	476	3	husbands
outlands	9	8	856	3	outlands
outmans	9	24	1328	3	outman_s
remands	10	49	1488	3	_remands
rimlands	11	4	524	3	rimlands
rummages	13	4	493	3	rummages
sampans	11	24	1100	3	sampan_s
sands	6	52	2858	3	s___ands
shamans	12	36	1090	3	shaman_s
siamangs	11	4	406	3	siamangs
simians	9	5	920	3	simian_s
solands	8	44	1234	3	s_olands
somans	8	46	1930	3	s_oman_s
stands	7	51	1805	3	s__tands
strands	8	37	1195	3	s_trands
submenus	12	4	590	3	submenus
subtends	11	3	617	3	subtends
suldans	8	29	972	3	suldan_s
sultanas	8	23	715	3	sultanas
sultans	7	24	1183	3	sultan_s
sumachs	14	45	735	3	su_machs
sumacs	10	55	1210	3	su_ma_cs
summa	9	47	1331	3	summa___
summable	14	3	690	3	summable
summae	10	39	1101	3	summa__e
summaries	13	11	818	3	summaries
summarise	13	11	573	3	summarise
summarist	13	11	676	3	summarist
summary	14	29	735	3	summa_ry
summate	11	36	1166	3	summa_te
summated	13	29	883	3	summated
summed	11	40	1404	3	summ_ed_
summers	11	36	1650	3	summ_ers
summing	12	29	1238	3	summin_g
summits	11	3	798	3	summ_its
summon	10	3	762	3	summon__
summoned	13	4	572	3	summoned
summoner	12	4	553	3	summoner
summoners	13	4	473	3	summoners
summonses	13	4	454	3	summonses
sunland	8	3	747	3	sunland_
suntans	7	21	1173	3	suntan_s
sunwards	12	3	644	3	sunwards
suspends	11	4	514	3	suspends
unhands	11	3	777	3	_unhands
unmans	8	22	1199	3	_unman_s
uplands	10	3	694	3	_uplands

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	66	6.576	22226.6
3	Display Results	66	66	0.016	4125.0
	(SQL Overall)	178691	66	7.015	25472.7