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

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

79 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
flour	8	49	1645	(None)
clour	7	66	1728	1	clour
floor	8	42	1523	1	floor
flours	9	44	1405	1	flours
floury	12	44	957	1	floury
flout	8	62	2620	1	flout
fluor	8	45	1277	1	fluor
four	7	62	2686	1	f_our
lour	4	54	3068	1	_lour
aloud	6	50	1807	2	aloud
amour	7	50	1485	2	amour
blur	6	60	2053	2	bl_ur
cloud	8	67	1642	2	cloud
clours	8	52	1509	2	clours
clout	7	53	3046	2	clout
colour	8	59	1509	2	colour
dolour	7	57	1013	2	dolour
dour	5	63	3043	2	_dour
favour	12	43	833	2	favour
femur	10	3	868	2	femur
flair	8	61	1412	2	flair
flavour	13	3	463	2	flavour
fleer	8	60	2077	2	fleer
fleury	12	41	735	2	fleury
flier	8	60	2340	2	flier
flir	7	64	2220	2	fl_ir
float	8	59	2857	2	float
floc	9	59	2212	2	flo_c
flock	14	47	1742	2	flock
flocs	10	55	1923	2	flocs
floe	7	61	2977	2	flo_e
floes	8	55	2814	2	floes
flog	8	55	2389	2	flo_g
flogs	9	59	1996	2	flogs
flong	9	58	1568	2	flong
flood	9	52	1560	2	flood
floors	9	41	1235	2	floors
flop	9	69	2545	2	flo_p
flops	10	59	2014	2	flops
flora	8	53	1710	2	flora
floss	8	51	1826	2	floss
flota	8	53	1564	2	flota
floured	11	28	987	2	floured
flouter	10	43	1134	2	flouter
flouts	9	43	1527	2	flouts
flow	10	59	2492	2	flo_w
flower	12	48	1550	2	flower
flown	11	62	1399	2	flown
flows	11	58	2236	2	flows
flu	6	65	3021	2	fl_u_
flub	9	57	2188	2	fl_ub
flue	7	53	2985	2	fl_ue
fluors	9	43	1137	2	fluors
flus	7	56	2654	2	fl_us
flux	14	56	1774	2	fl_ux
flyer	11	49	1625	2	flyer
for	6	69	5207	2	f_o_r
fou	6	67	4378	2	f_ou_
foul	7	70	2758	2	f_oul
fours	8	55	2149	2	f_ours
fur	6	66	3732	2	f__ur
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	1049	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	3038	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.313	570897.8
2	DLD Change Limit	53800	79	1.953	27547.4
3	Display Results	79	79	0.016	4937.5
	(SQL Overall)	178691	79	2.282	78304.6