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

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

71 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
swagger	12	38	933	(None)
sagger	8	43	2107	1	s_agger
stagger	9	42	1239	1	stagger
swager	10	40	1361	1	swa_ger
swagged	13	41	915	1	swagged
swaggers	13	40	722	1	swaggers
swigger	12	33	845	1	swigger
wagger	11	36	1601	1	_wagger
agger	7	64	2089	2	__agger
bagger	10	46	1920	2	_bagger
bragger	11	38	1004	2	bragger
dagger	9	50	1730	2	_dagger
dragger	10	30	917	2	dragger
flagger	12	46	935	2	flagger
gagger	9	50	1651	2	_gagger
jagger	15	40	1600	2	_jagger
lagger	8	59	1983	2	_lagger
nagger	8	40	1612	2	_nagger
sager	6	54	3205	2	s_a_ger
saggar	8	40	1085	2	s_aggar
sagged	9	41	2001	2	s_agged
saggers	9	40	1708	2	s_aggers
saggier	9	29	1206	2	s_aggier
sagier	7	37	1716	2	s_agier
sanger	7	45	2456	2	s_anger
sauger	7	43	1625	2	s_auger
shagged	13	42	1013	2	shagged
shaggier	13	11	605	2	shaggier
slagged	10	43	1277	2	slagged
slaggier	10	12	695	2	slaggier
slogger	9	43	1048	2	slogger
slugger	9	36	1068	2	slugger
smugger	11	32	705	2	smugger
snagged	10	40	1067	2	snagged
snaggier	10	13	630	2	snaggier
snigger	9	32	837	2	snigger
snugger	9	31	831	2	snugger
sparger	10	36	1308	2	sparger
stager	7	48	2134	2	sta_ger
stagged	10	42	1208	2	stagged
staggers	10	37	984	2	staggers
staggery	13	34	624	2	staggery
staggier	10	16	751	2	staggier
stagier	8	35	1344	2	stagier
swabber	14	29	796	2	swabber
swage	9	49	1956	2	swa_ge_
swaged	11	42	1225	2	swa_ged
swagers	11	42	1102	2	swa_gers
swages	10	44	1707	2	swa_ges
swaggered	15	4	319	2	swaggered
swaggerer	14	4	294	2	swaggerer
swaggie	12	13	578	2	swaggie
swaggies	13	13	669	2	swaggies
swagmen	13	3	497	2	swagmen
swamper	14	34	931	2	swamper
swanker	14	36	948	2	swanker
swapper	14	35	970	2	swapper
swarmer	12	4	780	2	swarmer
swasher	13	40	1151	2	swasher
swather	13	42	1360	2	swather
swatter	10	41	1332	2	swatter
swayer	12	52	1097	2	swa_yer
swigged	13	32	718	2	swigged
swiggers	13	33	712	2	swiggers
swinger	11	38	1256	2	swinger
tagger	8	40	1770	2	_tagger
twanger	11	32	743	2	twanger
wager	9	59	2505	2	_wa_ger
wagged	12	46	1612	2	_wagged
waggers	12	46	1308	2	_waggers
waggery	15	27	690	2	_waggery

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.390	458182.1
2	DLD Change Limit	107671	71	3.000	35890.3
3	Display Results	71	71	0.033	2151.5
	(SQL Overall)	178691	71	3.423	52203.0