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

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

86 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
tethers	10	38	1531	(None)
aethers	10	36	1494	1	aethers
ethers	9	45	1841	1	_ethers
teethers	11	32	871	1	teethers
tether	9	37	1610	1	tether_
tetters	7	43	2047	1	tetters
tithers	10	42	1673	1	tithers
wethers	13	52	1469	1	wethers
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	1577	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	1507	2	gathers
getters	8	42	1610	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
taters	6	49	3220	2	tat_ers
tatters	7	45	2048	2	tatters
teachers	13	32	1239	2	teachers
tearers	7	52	1823	2	tearers
teasers	7	53	1724	2	teasers
tedders	9	40	1023	2	tedders
teemers	9	50	1290	2	teemers
teeners	7	44	1545	2	teeners
teeters	7	40	1830	2	teeters
teether	10	34	969	2	teether_
teethes	10	36	1165	2	teethe_s
telfers	10	29	907	2	telfers
tellers	7	37	1759	2	tellers
telphers	13	3	547	2	telphers
tempers	11	35	1301	2	tempers
tenders	8	37	1972	2	tenders
tenners	7	40	1492	2	tenners
tenters	7	39	2110	2	tenters
termers	9	54	1450	2	termers
testers	7	41	2454	2	testers
tethered	12	3	849	2	tethered
teths	8	54	1851	2	teth__s
tetter	6	43	2245	2	tetter_
titers	6	45	2641	2	tit_ers
titfers	10	31	893	2	titfers
tither	9	49	2028	2	tither_
tithes	9	47	2021	2	tithe_s
titters	7	42	1962	2	titters
tochers	12	34	1309	2	tochers
toters	6	50	2636	2	tot_ers
tother	9	41	1714	2	tother_
totters	7	46	1873	2	totters
tythes	12	41	970	2	tythe_s
untethers	12	4	415	2	untethers
vetoers	10	35	947	2	vetoers
vetters	10	40	1632	2	vetters
weathers	14	34	1283	2	weathers
wether	12	33	1539	2	wether_
wetters	10	38	1775	2	wetters
withers	13	44	1775	2	withers
wuthers	13	37	1152	2	wuthers
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.393	454684.5
2	DLD Change Limit	107671	86	3.810	28260.1
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	4.236	42183.9