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

Here are the results of your fuzzy-string dictionary search for “swanherd” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

133 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
swanherd	15	3	348	(None)
swanherds	16	4	254	1	swanherds
swanked	15	35	954	2	swanke_d
swanker	14	36	948	2	swanker_
swanned	11	35	817	2	swanne_d
swannery	14	3	355	2	swannery
swashed	14	43	1136	2	swashe_d
swasher	13	40	1151	2	swasher_
swashers	14	38	953	2	swashers
swathed	14	46	1193	2	swathe_d
swather	13	42	1360	2	swather_
swathers	14	45	1208	2	swathers
swineherd	16	8	225	2	swineherd
goatherd	13	3	526	3	goatherd
neatherd	12	10	719	3	neatherd
sanded	8	49	2061	3	s_ande_d
sander	7	48	2853	3	s_ander_
sanders	8	40	2594	3	s_anders
saned	6	56	3627	3	s_an_e_d
saner	5	43	3432	3	s_an_er_
sanger	7	45	2456	3	s_anger_
sangers	8	44	2194	3	s_angers
santera	7	3	1130	3	s_antera
santero	7	3	1113	3	s_antero
saphead	13	5	777	3	s_aphead
sashed	10	56	2294	3	s_ashe_d
scanned	10	41	1089	3	scanne_d
scanner	9	44	1181	3	scanner_
scanners	10	37	970	3	scanners
scanted	10	41	1439	3	scante_d
scanter	9	42	1518	3	scanter_
scathed	13	40	1264	3	scathe_d
shanked	15	32	1212	3	shanke_d
shepherd	17	4	437	3	shepherd
sherd	9	63	2115	3	s___herd
skanked	11	33	810	3	skanke_d
skanker	10	26	848	3	skanker_
skankers	11	31	648	3	skankers
skinhead	16	4	306	3	skinhead
slander	8	40	1544	3	slander_
slandered	11	3	747	3	slandered
slanders	9	40	1401	3	slanders
slanged	9	41	1285	3	slange_d
slanted	8	35	1474	3	slante_d
slashed	11	41	1485	3	slashe_d
slasher	10	45	1533	3	slasher_
slashers	11	33	1361	3	slashers
slather	10	38	1608	3	slather_
slathered	13	14	855	3	slathered
slathers	11	39	1478	3	slathers
smashed	13	37	1122	3	smashe_d
smasher	12	39	1102	3	smasher_
smashers	13	33	959	3	smashers
spanked	14	31	1173	3	spanke_d
spanker	13	36	1235	3	spanker_
spankers	14	36	986	3	spankers
spanned	10	41	1122	3	spanne_d
spanner	9	43	1256	3	spanner_
spanners	10	37	1077	3	spanners
spathed	13	40	1318	3	spathe_d
stanched	14	20	890	3	stanche_d
stancher	13	19	881	3	stancher_
stanchers	14	20	681	3	stanchers
standard	10	4	625	3	standard
stander	8	43	1616	3	stander_
standers	9	35	1430	3	standers
staned	7	48	2464	3	stan_e_d
stanged	9	41	1384	3	stange_d
stashed	11	38	1249	3	stashe_d
swabbed	15	36	740	3	swabbe_d
swabber	14	29	796	3	swabber_
swabbers	15	31	674	3	swabbers
swacked	17	31	1052	3	swacke_d
swaged	11	42	1225	3	swa_ge_d
swager	10	40	1361	3	swa_ger_
swagers	11	42	1102	3	swa_gers
swagged	13	41	915	3	swagge_d
swagger	12	38	933	3	swagger_
swaggered	15	4	319	3	swaggered
swaggers	13	40	722	3	swaggers
swamped	15	49	844	3	swampe_d
swamper	14	34	931	3	swamper_
swampers	15	31	747	3	swampers
swankest	15	10	593	3	swankest
swankier	15	22	550	3	swankier_
swapped	15	42	914	3	swappe_d
swapper	14	35	970	3	swapper_
swappers	15	35	808	3	swappers
sward	9	42	2146	3	swa___rd
swarded	12	3	815	3	swarde_d
swarmed	13	6	748	3	swarme_d
swarmer	12	4	780	3	swarmer_
swarmers	13	4	632	3	swarmers
swashes	13	47	1440	3	swashe_s
swathe	12	55	1411	3	swathe__
swathes	13	41	1551	3	swathe_s
swatted	11	41	1069	3	swatte_d
swatter	10	41	1332	3	swatter_
swatters	11	39	1179	3	swatters
swayed	13	35	1026	3	swa_ye_d
swayer	12	52	1097	3	swa_yer_
swayers	13	39	885	3	swa_yers
swineherds	17	9	177	3	swineherds
swinged	12	38	1079	3	swinge_d
swinger	11	38	1256	3	swinger_
swingers	12	37	1042	3	swingers
swinked	15	34	903	3	swinke_d
swished	14	41	884	3	swishe_d
swisher	13	36	952	3	swisher_
swishers	14	32	805	3	swishers
swither	13	37	1099	3	swither_
swithered	16	13	546	3	swithered
swithers	14	43	1053	3	swithers
twanged	12	38	727	3	twange_d
twanger	11	32	743	3	twanger_
twangers	12	22	606	3	twangers
wander	10	44	2371	3	_wander_
wandered	13	21	1079	3	_wandered
wanders	11	42	2133	3	_wanders
waned	9	58	3178	3	_wan_e_d
wanier	9	39	2068	3	_wanier_
wanked	14	45	1715	3	_wanke_d
wanker	13	42	1997	3	_wanker_
wankers	14	45	1471	3	_wankers
wanned	10	43	1801	3	_wanne_d
wanner	9	40	1962	3	_wanner_
wanted	10	43	1972	3	_wante_d
wanter	9	44	2305	3	_wanter_
wanters	10	44	2009	3	_wanters
warhead	14	3	660	3	_warhead
washed	13	55	2150	3	_washe_d
washer	12	47	2039	3	_washer_
washers	13	45	1752	3	_washers

Search took 9 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	146162	0.423	422437.4
2	DLD Change Limit	146162	133	7.923	18447.8
3	Display Results	133	133	0.063	2111.1
	(SQL Overall)	178691	133	8.409	21250.0