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

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

79 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
soundmen	11	4	523	(None)
soundman	11	4	471	1	soundman
bondmen	12	3	789	2	bo_ndmen
bounden	10	38	945	2	bound_en
roundsmen	12	4	382	2	roundsmen
sandmen	10	3	941	2	s_andmen
sounded	9	32	1446	2	sound_ed
sounder	8	33	1538	2	sound_er
stuntmen	10	5	370	2	stuntmen
boardmen	13	4	407	3	boardmen
bondman	12	3	804	3	bo_ndman
bondsmen	13	4	547	3	bo_ndsmen
bounded	11	36	1376	3	bound_ed
bounder	10	42	1553	3	bound_er
cognomen	13	4	608	3	cognomen
condemn	12	3	711	3	co_ndemn
founded	12	40	1142	3	found_ed
founder	11	43	1257	3	found_er
goodmen	11	3	562	3	go_odmen
gownsmen	14	4	337	3	gownsmen
groundsmen	14	5	238	3	groundsmen
gunmen	9	34	872	3	_gun_men
hounded	12	33	1103	3	hound_ed
hounder	11	34	1223	3	hound_er
housemen	13	4	656	3	housemen
junkmen	20	3	363	3	_junkmen
landmen	10	3	855	3	_landmen
louden	7	37	1179	3	lou_d_en
mounded	11	37	1198	3	mound_ed
nonmen	8	4	1283	3	no_n_men
pointmen	12	4	542	3	pointmen
pounded	11	41	1279	3	pound_ed
pounder	10	33	1400	3	pound_er
rodmen	9	3	971	3	ro__dmen
rounded	9	30	1350	3	round_ed
roundel	8	30	885	3	round_el
rounder	8	35	1460	3	round_er
roundlet	9	20	922	3	roundlet
roundsman	12	4	342	3	roundsman
routemen	10	10	581	3	routemen
sandman	10	3	1017	3	s_andman
scoundrel	12	4	197	3	scoundrel
seedmen	10	3	768	3	s_eedmen
sockmen	15	3	545	3	so_ckmen
socmen	10	3	919	3	so__cmen
sodden	8	40	1151	3	so__dden
sokemen	13	3	705	3	so_kemen
sonarmen	10	4	525	3	sonarmen
sonde	6	46	2283	3	so_nd_e_
sonder	7	36	2352	3	so_nd_er
sondes	7	49	2287	3	so_nd_es
soudan	7	32	1035	3	sou_d_an
sound	6	44	2002	3	sound___
soundbox	18	4	241	3	soundbox
sounders	9	32	1411	3	sounders
soundest	9	5	1097	3	soundest
sounding	10	27	1287	3	sounding
soundless	10	3	553	3	soundless
soundly	11	3	668	3	sound_ly
soundness	10	3	696	3	soundness
sounds	7	46	1618	3	sound__s
sourdine	9	3	689	3	sourdine
stounded	10	27	621	3	stound_ed
stuntman	10	7	294	3	stuntman
sudden	8	33	1083	3	s_u_dden
sundae	7	3	1287	3	s_undae_
sundaes	8	3	1309	3	s_undaes
sunder	7	40	1982	3	s_und_er
sundew	10	36	969	3	s_und_ew
sundown	11	8	631	3	s_undown
sunken	10	35	1178	3	s_un_ken
surfmen	12	3	599	3	s_urfmen
swingmen	14	4	349	3	swingmen
swordmen	14	4	300	3	swordmen
swounded	13	31	456	3	swound_ed
tongmen	10	3	712	3	to_ngmen
townsmen	13	4	407	3	townsmen
woodmen	13	5	605	3	wo_odmen
wounded	12	32	976	3	wound_ed

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.466	383457.1
2	DLD Change Limit	146162	79	6.596	22159.2
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	7.108	25139.4