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

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

89 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
clour	7	66	1728	(None)
cloud	8	67	1642	1	cloud
clours	8	52	1508	1	clours
clout	7	53	3046	1	clout
colour	8	59	1508	1	colour
flour	8	49	1645	1	flour
lour	4	54	3068	1	_lour
aloud	6	50	1806	2	aloud
amour	7	50	1485	2	amour
blur	6	60	2053	2	bl_ur
choir	10	53	1359	2	choir
clamour	11	9	632	2	clamour
clear	7	62	1905	2	clear
cloak	11	52	1401	2	cloak
clock	13	49	1798	2	clock
clod	7	61	2461	2	clo_d
clods	8	53	2086	2	clods
clog	7	61	2324	2	clo_g
clogs	8	55	1955	2	clogs
clomb	11	57	1470	2	clomb
clomp	11	56	1570	2	clomp
clon	6	62	3248	2	clo_n
clone	7	57	2816	2	clone
cloner	8	44	1809	2	cloner
clonk	11	44	1744	2	clonk
clons	7	52	2813	2	clons
clonus	8	52	1241	2	clonus
cloot	7	61	2705	2	cloot
clop	8	69	2989	2	clo_p
clops	9	59	2485	2	clops
cloque	17	28	874	2	cloque
close	7	64	2522	2	close
closer	8	49	1820	2	closer
closure	9	27	847	2	closure
clot	6	65	4242	2	clo_t
cloth	10	58	1754	2	cloth
clots	7	56	2764	2	clots
cloture	9	23	845	2	cloture
clouds	9	46	1235	2	clouds
cloudy	12	51	780	2	cloudy
clough	12	53	913	2	clough
cloured	10	31	1154	2	cloured
clouter	9	35	1168	2	clouter
clouts	8	70	1720	2	clouts
clove	10	56	1944	2	clove
clover	11	46	1712	2	clover
clown	10	52	1473	2	clown
cloy	9	66	2383	2	clo_y
cloys	10	49	1694	2	cloys
cloze	16	55	1754	2	cloze
club	8	58	1947	2	cl_ub
clue	6	53	2453	2	cl_ue
coir	6	63	2724	2	c_oir
color	7	61	2374	2	color
colours	9	59	1341	2	colours
colure	8	3	1415	2	colure
cooer	7	48	3101	2	cooer
cor	5	99	6094	2	c_o_r
coup	8	67	2979	2	c_oup
court	7	55	3276	2	c_ourt
croup	9	56	1678	2	croup
cruor	7	3	1044	2	cruor
cur	5	68	4198	2	c__ur
dolour	7	57	1013	2	dolour
dour	5	63	3043	2	_dour
floor	8	42	1523	2	floor
flours	9	44	1405	2	flours
floury	12	44	957	2	floury
flout	8	62	2620	2	flout
fluor	8	45	1277	2	fluor
four	7	62	2686	2	_four
glout	6	59	2581	2	glout
hour	7	58	2731	2	_hour
loud	5	52	2804	2	_loud
loup	6	60	2843	2	_loup
lours	5	51	2529	2	_lours
loury	8	57	1675	2	_loury
lout	4	59	5214	2	_lout
odour	6	47	1047	2	odour
our	3	60	4289	2	__our
pour	6	115	2747	2	_pour
scour	7	53	1553	2	scour
slur	4	55	2515	2	sl_ur
sour	4	59	3589	2	_sour
stour	5	49	1674	2	stour
tour	4	55	3037	2	_tour
valour	9	30	1037	2	valour
velour	9	32	876	2	velour
your	7	86	2343	2	_your

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	53800	0.096	1861364.6
2	DLD Change Limit	53800	89	2.576	20885.1
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	2.718	65743.6