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

Here are the results of your fuzzy-string dictionary search for “colorants” 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
colorants	11	4	986	(None)
colorant	10	4	1472	1	colorant_
colorcasts	14	4	424	2	colorcasts
colorings	12	4	768	2	colorings
colorists	11	23	1359	2	colorists
coolants	10	3	994	2	co_olants
cormorants	14	4	534	2	cormorants
courants	10	3	1080	2	co_urants
odorants	9	4	604	2	_odorants
roborants	11	4	505	2	roborants
sonorants	9	4	708	2	sonorants
callants	10	41	1214	3	cal_lants
celebrants	14	4	416	3	celebrants
chloracnes	17	4	444	3	chloracnes
chlorals	13	14	803	3	chlora_ls
chlorate	13	31	1269	3	chlora_te
chlorates	14	25	1227	3	chlorates
chlordanes	16	4	451	3	chlordanes
chlordans	15	4	489	3	chlordan_s
chlorines	14	25	1235	3	chlorines
chlorins	13	26	1288	3	chlorin_s
cocoanuts	13	4	319	3	coco_anuts
cocomats	14	4	940	3	cocoma_ts
cohorts	12	34	1110	3	cohor__ts
collarets	11	32	733	3	collarets
colocate	12	3	1344	3	coloca_te
colocates	13	3	1285	3	colocates
colocynth	19	5	198	3	colocynth
colocynths	20	5	160	3	colocynths
colognes	11	3	1060	3	colo_gnes
colones	9	61	2443	3	colo__nes
colonists	11	25	1250	3	colonists
colons	8	60	2868	3	colo__n_s
colonus	9	44	1344	3	colo__nus
colorable	13	4	824	3	colorable
colorably	16	4	615	3	colorably
colorado	11	4	593	3	colora_do
colorcast	13	4	655	3	colorcast_
coloreds	11	3	809	3	color_eds
colorers	10	3	1218	3	color_ers
colorfast	14	4	503	3	colorfast_
coloring	11	4	1484	3	colorin_g
colorisms	13	28	1079	3	colorisms
colorist	10	28	1899	3	colorist_
colorizes	20	30	1452	3	colorizes
colorless	11	4	568	3	colorless
colorman	12	4	789	3	colorman__
colorpoints	15	5	278	3	colorpoints
colors	8	66	2237	3	color___s
colorways	17	4	372	3	colorways
confronts	14	4	706	3	confronts
congrats	11	3	1143	3	congra_ts
conodonts	12	4	606	3	conodonts
consonants	12	4	648	3	consonants
constants	11	4	1091	3	constants
contracts	13	22	1201	3	contracts
contrasts	11	22	1104	3	contrasts
coolant	9	3	1646	3	co_olant_
coparents	13	4	797	3	coparents
coranto	9	3	1189	3	c__oranto
corantos	10	3	1010	3	c__orantos
cormorant	13	4	857	3	cormorant_
corposants	14	4	464	3	corposants
corybants	16	4	443	3	corybants
cosecants	13	4	653	3	cosecants
cotenants	11	4	728	3	cotenants
courant	9	3	1797	3	co_urant_
courante	10	4	995	3	co_urante
courantes	11	4	888	3	co_urantes
couranto	10	4	690	3	co_uranto
courantos	11	4	579	3	co_urantos
covenants	14	4	589	3	covenants
currants	10	3	793	3	c_urrants
deodorants	12	5	293	3	deodorants
honorands	13	4	502	3	honorands
lorans	6	51	1760	3	__loran_s
odorant	8	4	1139	3	_odorant_
operants	10	3	948	3	_operants
roborant	10	4	838	3	roborant_
sonorant	8	4	1170	3	sonorant_
tolerant	8	4	1146	3	tolerant_

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	148641	0.420	425454.8
2	DLD Change Limit	148641	81	6.406	23203.4
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	6.859	26052.0