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

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

92 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
swagers	11	42	1102	(None)
stagers	8	41	1667	1	stagers
swager	10	40	1361	1	swager_
swages	10	44	1707	1	swage_s
swaggers	13	40	722	1	swaggers
swayers	13	39	885	1	swayers
wagers	10	51	2220	1	_wagers
agers	6	50	2785	2	__agers
cagers	9	56	2419	2	_cagers
dowagers	13	3	489	2	dowagers
eagers	7	45	2368	2	_eagers
gagers	8	40	2133	2	_gagers
imagers	10	10	776	2	imagers
jagers	14	44	1572	2	_jagers
laagers	8	34	1125	2	laagers
lagers	7	48	2614	2	_lagers
onagers	8	3	810	2	onagers
pagers	9	44	2325	2	_pagers
sabers	8	52	2473	2	s_abers
sager	6	54	3205	2	s_ager_
sages	6	53	3906	2	s_age_s
saggers	9	40	1708	2	saggers
sakers	10	41	2543	2	s_akers
sangers	8	44	2194	2	sangers
saugers	8	39	1405	2	saugers
savers	9	38	2592	2	s_avers
sawers	9	46	2016	2	s_awers
sawyers	13	31	753	2	sawyers
sayers	9	42	2159	2	s_ayers
scalers	9	38	1726	2	scalers
scarers	9	46	1850	2	scarers
sealers	7	43	2355	2	sealers
seamers	9	47	1943	2	seamers
seaters	7	40	2894	2	seaters
sergers	8	38	1563	2	sergers
sewages	11	3	975	2	sewage_s
shaders	11	59	1555	2	shaders
shakers	14	40	1556	2	shakers
shapers	12	40	1689	2	shapers
sharers	10	47	2062	2	sharers
shavers	13	41	1509	2	shavers
singers	8	38	2470	2	singers
skaters	11	35	1295	2	skaters
slakers	11	41	1575	2	slakers
slaters	7	31	2373	2	slaters
slavers	10	37	1650	2	slavers
slayers	10	45	1332	2	slayers
snarers	7	42	1666	2	snarers
soakers	11	41	1495	2	soakers
soapers	9	37	1592	2	soapers
soarers	7	41	1809	2	soarers
socagers	11	9	636	2	socagers
spacers	11	38	1387	2	spacers
spaders	10	42	1447	2	spaders
sparers	9	45	1961	2	sparers
spargers	11	38	973	2	spargers
stager	7	48	2134	2	stager_
stages	7	56	2949	2	stage_s
staggers	10	37	984	2	staggers
starers	7	45	2231	2	starers
staters	7	39	2234	2	staters
stayers	10	38	1363	2	stayers
surgers	8	35	1748	2	surgers
swabbers	15	31	674	2	swabbers
swage	9	49	1956	2	swage__
swaged	11	42	1225	2	swage_d
swagger	12	38	933	2	swagger_
swags	9	49	2125	2	swag__s
swales	9	39	2076	2	swale_s
swampers	15	31	747	2	swampers
swappers	15	35	808	2	swappers
swarmers	13	4	632	2	swarmers
swashers	14	38	953	2	swashers
swathers	14	45	1208	2	swathers
swatters	11	39	1179	2	swatters
swayer	12	52	1097	2	swayer_
swearers	11	32	858	2	swearers
sweaters	11	38	1106	2	sweaters
swiggers	13	33	712	2	swiggers
swingers	12	37	1042	2	swingers
twangers	12	22	606	2	twangers
waders	10	91	2064	2	_waders
wafers	12	43	1614	2	_wafers
wager	9	59	2505	2	_wager_
wages	9	53	3093	2	_wage_s
waggers	12	46	1308	2	_waggers
wakers	13	48	2249	2	_wakers
walers	9	48	2446	2	_walers
waters	9	50	3063	2	_waters
wavers	12	50	2247	2	_wavers
waxers	16	40	1430	2	_waxers
yagers	10	51	1453	2	_yagers

Search took 5 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.123	1452772.4
2	DLD Change Limit	107671	92	3.830	28112.5
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	3.983	44863.4