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

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

81 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
boatsmen	12	4	528	(None)
batsmen	11	4	688	1	b_atsmen
boatmen	11	4	691	1	boat_men
boatsman	12	4	570	1	boatsman
batmen	10	44	1430	2	b_at_men
batsman	11	5	799	2	b_atsman
beadsmen	13	8	588	2	beadsmen
boardmen	13	4	407	2	boardmen
boatman	11	4	705	2	boat_man
bondsmen	13	4	547	2	bondsmen
oarsmen	9	3	809	2	_oarsmen
badmen	11	46	1383	3	b_a_dmen
bagmen	11	54	1253	3	b_a_gmen
bailsmen	12	4	462	3	bailsmen
bandsmen	13	5	645	3	bandsmen
barmen	10	54	1853	3	b_a_rmen
basemen	11	3	908	3	b_asemen
batman	10	52	1406	3	b_at_man
batten	8	52	1712	3	b_at_ten
baymen	13	42	1200	3	b_a_ymen
beadmen	12	29	945	3	bea_dmen
beadsman	13	5	561	3	beadsman
beaten	8	46	1706	3	beat__en
bedesmen	13	5	571	3	bedesmen
bitumen	11	3	450	3	b_itumen
blastment	13	4	716	3	blastment
bluesmen	12	4	415	3	bluesmen
boardman	13	4	439	3	boardman
boasted	10	41	1374	3	boa_sted
boaster	9	46	1643	3	boa_ster
boated	9	42	2197	3	boat__ed
boatel	8	43	1409	3	boat__el
boater	8	46	2209	3	boat__er
boats	7	56	3515	3	boats___
boatswain	14	5	192	3	boatswain
bogeymen	16	4	363	3	bogeymen
bogymen	15	3	476	3	bo_gymen
bondmen	12	3	789	3	bo_ndmen
bondsman	13	4	569	3	bondsman
boogymen	16	4	310	3	boogymen
bookmen	15	12	626	3	bo_okmen
bottomed	13	4	467	3	bottomed
bottomer	12	4	510	3	bottomer
bowmen	13	9	985	3	bo__wmen
brakemen	16	4	484	3	brakemen
busmen	10	3	989	3	b__usmen
clansmen	12	4	572	3	clansmen
coachmen	17	4	501	3	coachmen
coarsen	9	32	1032	3	coars_en
corpsmen	14	4	562	3	corpsmen
craftsmen	16	7	291	3	craftsmen
cragsmen	13	4	476	3	cragsmen
daysmen	13	3	508	3	_daysmen
deathsmen	15	4	303	3	deathsmen
draftsmen	15	5	267	3	draftsmen
foilsmen	13	5	410	3	foilsmen
footmen	12	4	658	3	foot_men
gasmen	9	31	1156	3	_ga_smen
gatemen	10	4	760	3	_gatemen
glassmen	11	4	539	3	glassmen
goatskin	13	4	277	3	goatskin
gownsmen	14	4	337	3	gownsmen
grantsmen	12	9	464	3	grantsmen
headsmen	14	6	598	3	headsmen
hoarsen	10	36	799	3	hoars_en
huntsmen	13	4	327	3	huntsmen
leadsmen	11	5	479	3	leadsmen
meatmen	11	3	824	3	meat_men
oarsman	9	3	773	3	_oarsman
oaten	5	52	2240	3	_oat__en
outseen	7	27	1233	3	_outseen
plantsmen	13	4	414	3	plantsmen
postmen	11	31	1042	3	post_men
potmen	10	27	1309	3	po_t_men
raftsmen	13	4	395	3	raftsmen
rodsmen	10	3	583	3	ro_dsmen
routemen	10	10	581	3	routemen
sportsmen	13	4	354	3	sportsmen
statesmen	11	4	416	3	statesmen
townsmen	13	4	407	3	townsmen
woodsmen	14	4	463	3	woodsmen

Search took 9 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.310	576422.6
2	DLD Change Limit	146162	81	8.220	17781.3
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	8.563	20867.8