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

Here are the results of your fuzzy-string dictionary search for “flower” 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
flower	12	48	1550	(None)
blower	11	53	1657	1	blower
flowed	13	35	1376	1	flowed
flowers	13	34	1317	1	flowers
flowery	16	32	778	1	flowery
glower	10	51	1493	1	glower
lower	8	58	3041	1	_lower
plower	11	43	1506	1	plower
slower	9	40	1615	1	slower
avower	12	3	682	2	avower
beflower	16	16	627	2	beflower
blowed	12	50	1669	2	blowed
blowers	12	43	1359	2	blowers
blowier	12	4	894	2	blowier
bower	10	73	2818	2	_bower
clawer	11	45	1278	2	clawer
cloner	8	44	1809	2	cloner
closer	8	49	1820	2	closer
clover	11	46	1712	2	clover
clowder	13	36	794	2	clowder
cower	10	45	3177	2	_cower
crower	11	41	1756	2	crower
deflower	15	12	607	2	deflower
dower	9	50	2770	2	_dower
eloper	8	54	1415	2	eloper
fewer	11	52	1612	2	f_ewer
flaker	13	49	1617	2	flaker
flamer	11	49	1912	2	flamer
flawed	13	47	1272	2	flawed
flawier	13	37	873	2	flawier
flayer	12	47	1356	2	flayer
fleer	8	60	2077	2	fl_eer
flier	8	60	2340	2	fl_ier
floater	10	44	1335	2	floater
floe	7	61	2977	2	flo_e_
floes	8	55	2814	2	flo_es
flogger	12	44	946	2	flogger
flooder	11	25	846	2	flooder
flooey	12	39	1017	2	flooey
floor	8	42	1523	2	flo_or
floorer	10	24	807	2	floorer
flopper	14	32	847	2	flopper
floret	9	3	2112	2	floret
flosser	10	33	969	2	flosser
flour	8	49	1645	2	flo_ur
flouter	10	43	1134	2	flouter
flow	10	59	2492	2	flow__
flowered	15	4	601	2	flowered
flowerer	14	3	545	2	flowerer
floweret	14	4	808	2	floweret
flown	11	62	1399	2	flow_n
flows	11	58	2236	2	flow_s
fluter	9	53	1686	2	fluter
flyer	11	49	1625	2	fl_yer
flyover	16	3	351	2	flyover
folder	10	43	1754	2	folder
follower	14	13	707	2	follower
footer	9	43	2077	2	footer
fowler	12	37	1258	2	f_owler
foyer	11	64	1655	2	f_oyer
frowner	13	42	968	2	frowner
glover	10	45	1353	2	glover
glowed	11	49	1383	2	glowed
glowers	11	34	1209	2	glowers
grower	10	46	1493	2	grower
knower	13	3	708	2	knower
loner	5	54	3104	2	_loner
loper	7	51	2923	2	_loper
loser	5	47	2867	2	_loser
lover	8	55	2645	2	_lover
lowe	7	54	3531	2	_lowe_
lowed	9	52	3390	2	_lowed
lowers	9	46	2492	2	_lowers
lowery	12	41	1271	2	_lowery
lowes	8	57	3246	2	_lowes
mower	10	45	2345	2	_mower
plover	11	53	1261	2	plover
plowed	12	42	1320	2	plowed
plowers	12	38	1224	2	plowers
power	10	53	2595	2	_power
prower	11	42	1812	2	prower
reflower	14	12	684	2	reflower
rower	8	54	3049	2	_rower
shower	12	43	1511	2	shower
sloper	8	46	1591	2	sloper
slowed	10	46	1707	2	slowed
sower	8	52	2931	2	_sower
tower	8	57	2920	2	_tower
vower	11	52	2079	2	_vower

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.343	520965.0
2	DLD Change Limit	82551	89	2.220	37185.1
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	2.593	68912.8