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

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

84 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
wethers	13	52	1469	(None)
aethers	10	36	1494	1	aethers
ethers	9	45	1841	1	_ethers
tethers	10	38	1531	1	tethers
weathers	14	34	1283	1	weathers
wether	12	33	1539	1	wether_
wetters	10	38	1775	1	wetters
withers	13	44	1775	1	withers
wuthers	13	37	1152	1	wuthers
aether	9	42	1367	2	aether_
anthers	10	37	1520	2	anthers
bathers	12	47	2036	2	bathers
bethels	12	3	853	2	bethels
betters	9	44	2209	2	betters
blethers	13	42	961	2	blethers
bothers	12	43	1775	2	bothers
cithers	12	43	1575	2	cithers
deters	7	47	2468	2	det_ers
diethers	12	5	745	2	diethers
dithers	11	40	1615	2	dithers
etchers	12	34	1129	2	_etchers
ether	8	45	1877	2	_ether_
fathers	13	39	1650	2	fathers
feathers	14	35	1324	2	feathers
fetchers	16	32	886	2	fetchers
fetters	10	35	1790	2	fetters
gathers	11	43	1506	2	gathers
getters	8	42	1609	2	getters
heathers	14	39	1473	2	heathers
lathers	10	43	2188	2	lathers
leathers	11	42	1508	2	leathers
lechers	12	33	1396	2	lechers
lethes	9	48	1808	2	lethe_s
letters	7	38	1985	2	letters
meters	8	56	2583	2	met_ers
metiers	9	33	1284	2	metiers
mithers	12	35	1673	2	mithers
mothers	12	37	1762	2	mothers
nether	9	40	1416	2	nether_
netters	7	36	1858	2	netters
others	9	39	1800	2	_others
peters	8	66	2459	2	pet_ers
petters	9	37	2236	2	petters
pothers	12	38	1862	2	pothers
setters	7	38	2206	2	setters
swathers	14	45	1207	2	swathers
swithers	14	43	1053	2	swithers
teethers	11	32	871	2	teethers
tether	9	37	1610	2	tether_
tetters	7	43	2047	2	tetters
tithers	10	42	1673	2	tithers
vetoers	10	35	947	2	vetoers
vetters	10	40	1631	2	vetters
washers	13	45	1752	2	washers
watchers	16	35	1179	2	watchers
waters	9	50	3062	2	wat_ers
weaners	10	46	1383	2	weaners
wearers	10	46	1590	2	wearers
weather	13	35	1322	2	weather_
weavers	13	37	1446	2	weavers
webers	11	3	1094	2	we_bers
wedders	12	36	1072	2	wedders
weeders	11	34	1293	2	weeders
weepers	12	35	1197	2	weepers
weevers	13	37	999	2	weevers
weighers	15	13	567	2	weighers
weiners	10	39	1306	2	weiners
welchers	16	33	805	2	welchers
welders	11	33	1341	2	welders
welshers	14	24	681	2	welshers
welters	10	35	1606	2	welters
wenchers	16	31	921	2	wenchers
westers	10	52	2196	2	westers
wetness	10	27	772	2	wetness
wetter	9	39	1944	2	wetter_
whether	16	34	662	2	whether_
whetters	14	24	665	2	whetters
wishers	13	32	1521	2	wishers
wither	12	43	2135	2	wither_
withes	12	46	2084	2	withe_s
wreathers	15	25	748	2	wreathers
writhers	14	39	898	2	writhers
wuther	12	45	1161	2	wuther_
zithers	19	39	1197	2	zithers

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.236	757165.3
2	DLD Change Limit	107671	84	4.156	25907.4
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	4.422	40409.5