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

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

65 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
choreman	15	11	760	(None)
choremen	15	9	760	1	choremen
chorea	11	52	1609	2	chore_a_
choreal	12	44	1222	2	chore_al
choreas	12	44	1420	2	chore_as
foreman	12	3	1236	2	_foreman
horseman	13	4	683	2	_horseman
anchorman	16	4	446	3	anchor_man
carman	10	39	2074	3	c_ar_man
caveman	14	3	707	3	c_aveman
chainman	15	8	519	3	chainman
chairman	15	10	638	3	chairman
chapman	16	3	789	3	ch_apman
charwoman	19	4	467	3	charwoman
chessman	15	4	482	3	chessman
chlordan	14	4	549	3	chlor_dan
cholera	12	40	909	3	cholera_
choleras	13	28	904	3	choleras
choral	11	51	1849	3	chor__al
chordal	13	44	988	3	chor_dal
chore	10	51	2676	3	chore___
chored	12	53	2188	3	chore__d
choregi	13	4	456	3	chore_gi
choregus	14	8	421	3	choregus
choreic	14	3	870	3	chore_ic
choreoid	14	4	792	3	choreoid
chores	11	48	2802	3	chore__s
chorial	12	42	1414	3	chor_ial
choriamb	17	4	416	3	choriamb
chorion	12	3	1177	3	chor_ion
chorten	12	28	1130	3	chor_ten
chosen	11	60	1413	3	chose__n
chroma	13	29	1247	3	ch_roma_
chromas	14	25	1269	3	ch_romas
churchman	21	5	300	3	churchman
colorman	12	4	789	3	color_man
corban	10	3	1469	3	c_or_ban
coreign	10	3	734	3	c_oreign
coremia	11	3	1036	3	c_oremia
cornerman	13	4	536	3	c_ornerman
corpsman	14	4	513	3	c_orpsman
cowman	13	9	1037	3	c_o_wman
crewman	14	3	575	3	c__rewman
doorman	10	3	706	3	door_man
fireman	12	4	933	3	_fireman
foeman	11	3	1123	3	_fo_eman
foremen	12	4	1292	3	_foremen
foreran	10	3	1179	3	_foreran
herdman	13	23	842	3	_herdman
horsemen	13	4	748	3	_horsemen
hotelman	13	4	410	3	_hotelman
houseman	13	4	658	3	_houseman
preman	10	41	1745	3	__preman
reman	7	57	3015	3	___reman
schoolman	16	4	299	3	schoolman
shopman	14	24	726	3	sho_pman
shoran	9	40	1604	3	shor__an
showman	15	25	729	3	sho_wman
sokeman	13	3	726	3	_sokeman
swordman	14	4	340	3	swordman
theremin	13	10	728	3	theremin
whaleman	16	4	397	3	whaleman
whoreson	14	4	401	3	whoreson
wireman	12	3	784	3	_wireman
workman	16	3	561	3	_workman

Search took 7 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	65	6.500	22486.5
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	6.939	25751.7