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

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

56 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
flogged	13	52	880	(None)
clogged	12	52	865	1	clogged
flagged	13	45	963	1	flagged
flogger	12	44	946	1	flogger
fogged	12	55	1837	1	f_ogged
frogged	13	40	849	1	frogged
logged	9	66	2294	1	_logged
slogged	10	49	1047	1	slogged
blogger	11	44	831	2	blogger
bogged	11	60	1928	2	_bogged
clagged	12	74	923	2	clagged
clogger	11	43	880	2	clogger
cogged	11	64	1661	2	_cogged
dogged	10	60	1770	2	_dogged
fagged	12	47	1770	2	f_agged
figged	12	40	1389	2	f_igged
flagger	12	46	935	2	flagger
flanged	12	38	1084	2	flanged
fledged	13	41	786	2	fledged
floated	11	33	1270	2	floated
flocced	15	36	548	2	flocced
flocked	17	45	1025	2	flocked
floggers	13	38	786	2	floggers
flooded	12	30	793	2	flooded
floored	11	26	868	2	floored
flopped	15	33	876	2	flopped
flossed	11	38	853	2	flossed
floured	11	28	987	2	floured
flouted	11	32	1081	2	flouted
flowed	13	35	1376	2	flo_wed
fogger	11	44	1478	2	f_ogger
forged	11	55	1932	2	f_orged
fragged	13	40	1016	2	fragged
frigged	13	43	905	2	frigged
frugged	13	38	729	2	frugged
fugged	12	46	1538	2	f_ugged
glugged	11	39	662	2	glugged
hogged	12	58	1777	2	_hogged
jogged	16	60	1592	2	_jogged
lagged	9	55	2013	2	_lagged
legged	9	57	1309	2	_legged
lodged	9	138	1571	2	_lodged
logger	8	64	2000	2	_logger
longed	8	71	2137	2	_longed
lugged	9	44	1706	2	_lugged
mogged	11	52	1539	2	_mogged
nogged	9	57	1633	2	_nogged
plugged	12	40	804	2	plugged
progged	12	40	980	2	progged
shogged	13	39	796	2	shogged
slagged	10	43	1277	2	slagged
slogger	9	43	1048	2	slogger
slugged	10	44	1038	2	slugged
snogged	10	41	797	2	snogged
sogged	9	55	1852	2	_sogged
togged	9	51	1751	2	_togged

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	56	2.983	36094.9
3	Display Results	56	56	0.016	3500.0
	(SQL Overall)	178691	56	3.375	52945.5