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

Here are the results of your fuzzy-string dictionary search for “clours” with Change Limit: [1] [2] [3]

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.

87 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
clours	8	52	1509	(None)
clouds	9	46	1235	1	clouds
clour	7	66	1728	1	clour_
clouts	8	70	1720	1	clouts
colours	9	59	1344	1	colours
flours	9	44	1405	1	flours
lours	5	51	2529	1	_lours
amours	8	35	1266	2	amours
blurs	7	46	1908	2	bl_urs
choirs	11	49	1188	2	choirs
chorus	11	50	1477	2	chorus
clamours	12	5	599	2	clamours
clears	8	41	1656	2	clears
cloaks	12	44	1126	2	cloaks
clocks	14	49	1623	2	clocks
clods	8	53	2086	2	clo_ds
clogs	8	55	1955	2	clo_gs
clomps	12	52	1223	2	clomps
cloners	9	45	1482	2	cloners
clones	8	45	2656	2	clones
clonks	12	50	1347	2	clonks
clons	7	52	2813	2	clo_ns
clonus	8	52	1241	2	clonus
cloots	8	51	1369	2	cloots
clops	9	59	2485	2	clo_ps
cloques	18	26	856	2	cloques
closers	9	44	1532	2	closers
closes	8	54	2559	2	closes
closure	9	27	848	2	closure
closures	10	22	895	2	closures
cloths	11	55	1248	2	cloths
clots	7	56	2764	2	clo_ts
cloture	9	23	845	2	cloture
clotures	10	29	902	2	clotures
cloud	8	67	1642	2	clou_d
cloudy	12	51	780	2	cloudy
clough	12	53	913	2	clough
cloughs	13	51	705	2	cloughs
cloured	10	31	1154	2	cloured
clout	7	53	3046	2	clou_t
clouters	10	39	980	2	clouters
clovers	12	51	1466	2	clovers
cloves	11	49	1882	2	cloves
clowns	11	48	1011	2	clowns
cloys	10	49	1694	2	clo_ys
clozes	17	49	1556	2	clozes
clubs	9	54	1510	2	cl_ubs
clues	7	46	2303	2	cl_ues
coirs	7	52	2105	2	c_oirs
colors	8	66	2237	2	colors
colour	8	59	1509	2	colour_
colure	8	3	1416	2	colure
colures	9	3	1514	2	colures
cooers	8	43	2456	2	cooers
cors	6	66	5644	2	c_o_rs
coups	9	55	2247	2	c_oups
course	8	51	1778	2	c_ourse
court	7	55	3277	2	c_ourt
courts	8	42	1617	2	c_ourts
croups	10	43	1255	2	croups
cruors	8	3	864	2	cruors
curs	6	56	4554	2	c__urs
dolours	8	43	882	2	dolours
floors	9	41	1235	2	floors
flour	8	49	1645	2	flour_
floury	12	44	957	2	floury
flouts	9	43	1527	2	flouts
fluors	9	43	1137	2	fluors
fours	8	55	2149	2	_fours
glouts	7	44	1471	2	glouts
hours	8	54	2239	2	_hours
louis	5	73	2232	2	_louis
loups	7	53	1962	2	_loups
lour	4	54	3068	2	_lour_
loury	8	57	1675	2	_loury
louts	5	63	3027	2	_louts
odours	7	41	825	2	odours
ours	4	72	3756	2	__ours
pours	7	46	2318	2	_pours
scours	8	49	1359	2	scours
slurs	5	41	2337	2	sl_urs
sours	5	52	3050	2	_sours
stours	6	50	1563	2	stours
tours	5	53	2589	2	_tours
valours	10	24	874	2	valours
velours	10	27	808	2	velours
yours	8	52	1788	2	_yours

Search took 3 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	82551	0.330	541487.9
2	DLD Change Limit	82551	87	2.343	35233.0
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	2.703	66108.4