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

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

78 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
colormen	12	4	724	(None)
colorman	12	4	789	1	colorman
colored	10	3	1347	2	color_ed
colorer	9	3	1252	2	color_er
doormen	10	3	675	2	do_ormen
motormen	12	4	570	2	motormen
bookmen	15	12	626	3	bo_okmen
calomel	11	3	807	3	calo_mel
calorie	9	27	1689	3	calorie_
calories	10	29	1955	3	calories
carmen	10	40	1934	3	c__armen
chairmen	15	10	547	3	chairmen
chlordan	14	4	549	3	chlordan
chlorin	12	31	1300	3	chlor_in
chlorine	13	30	1330	3	chlorine
choremen	15	9	760	3	c_horemen
chorten	12	28	1130	3	c_horten
cloven	11	42	1151	3	c_lo_ven
clubmen	13	3	425	3	c_lubmen
coachmen	17	4	501	3	coachmen
coarsen	9	32	1032	3	co_arsen
coelome	11	3	969	3	coelo_me_
coelomes	12	3	929	3	coelo_mes
cognomen	13	4	608	3	cognomen
collagen	11	33	857	3	collagen
colleen	9	3	954	3	col_leen
cologne	10	3	936	3	cologne_
cologned	12	3	715	3	cologned
colognes	11	3	1060	3	colognes
colon	7	86	3019	3	colo___n
colone	8	54	2500	3	colo_ne_
colonel	9	42	1328	3	colo_nel
colones	9	61	2443	3	colo_nes
colonies	10	36	2001	3	colonies
colophon	15	4	557	3	colophon
color	7	61	2374	3	color___
colorado	11	4	593	3	colorado
colorant	10	4	1472	3	colorant
colorbred	14	4	395	3	colorbred
coloreds	11	3	809	3	coloreds
colorers	10	3	1218	3	colorers
colorful	13	4	441	3	colorful
coloring	11	4	1484	3	coloring
colorism	12	21	1243	3	colorism
colorist	10	28	1899	3	colorist
colorize	19	23	1420	3	colorize
colorized	21	22	1177	3	colorized
colorizer	20	24	1062	3	colorizer
colorizes	20	30	1452	3	colorizes
colorless	11	4	568	3	colorless
colors	8	66	2237	3	color__s
colorway	16	4	449	3	colorway
coloured	11	4	831	3	coloured
colourer	10	3	756	3	colourer
columel	11	3	627	3	col_umel
column	10	3	810	3	col_um_n
colure	8	3	1416	3	colur_e_
colures	9	3	1514	3	colur_es
conformed	17	6	746	3	conformed
conformer	16	6	746	3	conformer
cormel	10	38	1560	3	c__ormel
cornermen	13	4	573	3	cornermen
corpsmen	14	4	562	3	corpsmen
cowmen	13	8	1092	3	c__owmen
coworker	17	4	468	3	coworker
dolmen	9	39	1137	3	dol__men
doorman	10	3	706	3	do_orman
ealdormen	12	11	259	3	ealdormen
footmen	12	4	658	3	fo_otmen
goodmen	11	3	562	3	go_odmen
moorhen	12	3	602	3	mo_orhen
motorman	12	4	614	3	motorman
overmen	12	3	1180	3	_overmen
plowmen	14	3	488	3	_plowmen
sonarmen	10	4	525	3	sonarmen
tollmen	9	3	573	3	tol_lmen
woodmen	13	5	605	3	wo_odmen
woolmen	12	3	497	3	wo_olmen

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.423	422437.4
2	DLD Change Limit	146162	78	8.390	17421.0
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	8.843	20207.1