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

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

77 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
swayers	13	39	885	(None)
sawyers	13	31	753	1	sawyers
sayers	9	42	2159	1	s_ayers
slayers	10	45	1332	1	slayers
stayers	10	38	1363	1	stayers
swagers	11	42	1102	1	swagers
swayer	12	52	1097	1	swayer_
assayers	11	4	484	2	assayers
brayers	12	45	1190	2	brayers
essayers	11	3	356	2	essayers
flayers	13	39	1203	2	flayers
hayers	12	44	1594	2	_hayers
lawyers	13	37	715	2	lawyers
layers	9	39	2118	2	_layers
payers	11	46	2182	2	_payers
players	12	43	1376	2	players
prayers	12	42	1285	2	prayers
sabers	8	52	2473	2	s_abers
sakers	10	41	2543	2	s_akers
savers	9	38	2592	2	s_avers
sawers	9	46	2016	2	s_awers
sawyer	12	43	804	2	sawyer_
sayeds	10	46	925	2	s_ayeds
sayer	8	49	2655	2	s_ayer_
scalers	9	38	1726	2	scalers
scarers	9	46	1851	2	scarers
sealers	7	43	2355	2	sealers
seamers	9	47	1943	2	seamers
seaters	7	40	2894	2	seaters
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
shyers	12	47	1220	2	s_hyers
skaters	11	35	1296	2	skaters
slakers	11	41	1575	2	slakers
slaters	7	31	2373	2	slaters
slavers	10	37	1650	2	slavers
slayer	9	39	1633	2	slayer_
snarers	7	42	1666	2	snarers
soakers	11	41	1495	2	soakers
soapers	9	37	1592	2	soapers
soarers	7	41	1809	2	soarers
spacers	11	38	1387	2	spacers
spaders	10	42	1447	2	spaders
sparers	9	45	1961	2	sparers
sprayers	13	36	705	2	sprayers
stagers	8	41	1667	2	stagers
starers	7	45	2231	2	starers
staters	7	39	2234	2	staters
stayer	9	45	1648	2	stayer_
strayers	11	35	1014	2	strayers
swabbers	15	31	674	2	swabbers
swager	10	40	1361	2	swager_
swages	10	44	1707	2	swage_s
swaggers	13	40	722	2	swaggers
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
swayed	13	35	1026	2	swaye_d
sways	11	55	1846	2	sway__s
swearers	11	32	858	2	swearers
sweaters	11	38	1106	2	sweaters
twyers	12	49	741	2	tw_yers
waders	10	91	2064	2	_waders
wafers	12	43	1614	2	_wafers
wagers	10	51	2220	2	_wagers
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

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.423	422437.4
2	DLD Change Limit	107671	77	2.906	37051.3
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	3.359	53197.7