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

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

82 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
pointmen	12	4	542	(None)
pointman	12	4	480	1	pointman
ointment	10	6	923	2	_ointment
pitmen	10	25	1079	2	p_i_tmen
pointe	8	46	1931	2	point_e_
pointed	10	38	1398	2	point_ed
pointer	9	38	1493	2	point_er
pointes	9	32	1675	2	point_es
pointier	10	3	830	2	pointier
postmen	11	31	1042	2	po_stmen
potmen	10	27	1309	2	po__tmen
anointment	12	5	646	3	anointment
appointment	17	5	349	3	appointment
boatmen	11	4	691	3	bo_atmen
bondmen	12	3	789	3	bo_ndmen
cognomen	13	4	608	3	cognomen
cointer	9	36	1672	3	coint_er
contemn	11	3	780	3	co_ntemn
foilsmen	13	5	410	3	foilsmen
footmen	12	4	658	3	fo_otmen
frontmen	13	4	442	3	frontmen
gownsmen	14	4	337	3	gownsmen
hitmen	11	23	919	3	_hi_tmen
jointed	15	37	850	3	joint_ed
jointer	14	37	971	3	joint_er
kinsmen	13	3	565	3	_kinsmen
liftmen	12	3	423	3	_liftmen
linemen	9	3	863	3	_linemen
linkmen	13	3	536	3	_linkmen
moisten	9	31	1014	3	moist_en
nonmen	8	4	1283	3	no_n_men
oilmen	8	4	831	3	_oi_lmen
oinomel	9	4	635	3	_oinomel
ointments	11	6	665	3	_ointments
painted	10	42	1463	3	paint_ed
painter	9	38	1456	3	paint_er
paintier	10	4	879	3	paintier
penmen	10	3	1149	3	p_en_men
pikemen	15	3	533	3	p_ikemen
pinken	12	45	1328	3	p_in_ken
pintle	8	38	1826	3	p_intle_
pintles	9	41	1872	3	p_intles
pintoes	9	51	1771	3	p_intoes
pitman	10	24	1212	3	p_i_tman
pivotmen	15	4	265	3	pivotmen
plainsmen	13	4	346	3	plainsmen
plantsmen	13	4	414	3	plantsmen
poinded	11	35	897	3	poin_ded
point	7	53	3873	3	point___
pointers	10	30	1372	3	pointers
pointiest	11	3	962	3	pointiest
pointing	11	28	1368	3	pointing
pointless	11	3	570	3	pointless
points	8	56	1853	3	point__s
pointy	11	49	1328	3	point__y
poitrel	9	3	619	3	poi_trel
policemen	15	4	378	3	policemen
pontes	8	36	2785	3	po_nt_es
pontine	9	24	1905	3	po_ntine
ponton	8	32	1764	3	po_nt_on
pontoon	9	30	1070	3	po_ntoon
posteen	9	35	1262	3	po_steen
postman	11	24	1004	3	po_stman
postteen	10	5	569	3	postteen
poteen	8	35	1426	3	po__teen
potman	10	28	1357	3	po__tman
potteen	9	31	967	3	po_tteen
prenomen	12	4	963	3	prenomen
printed	10	40	1637	3	print_ed
printer	9	39	1730	3	print_er
reinsmen	10	4	707	3	reinsmen
roentgen	9	4	298	3	roentgen
rontgen	8	3	517	3	ro_ntgen
soundmen	11	4	523	3	soundmen
spoilsmen	13	4	242	3	spoilsmen
stuntmen	10	5	370	3	stuntmen
swingmen	14	4	349	3	swingmen
tinmen	8	23	1040	3	_tin_men
titmen	8	23	988	3	_ti_tmen
tongmen	10	3	712	3	to_ngmen
townsmen	13	4	407	3	townsmen
wingmen	13	3	611	3	_wingmen

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.406	440125.6
2	DLD Change Limit	146162	82	7.156	20425.1
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.592	23536.7