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

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

95 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
leather	10	38	1578	(None)
feather	13	36	1350	1	feather
heather	13	39	1485	1	heather
lather	9	51	2436	1	l_ather
leacher	12	40	1484	1	leacher
leathern	11	39	891	1	leathern
leathers	11	42	1508	1	leathers
leathery	14	43	897	1	leathery
loather	10	37	1100	1	loather
pleather	13	5	665	1	pleather
weather	13	35	1322	1	weather
aether	9	42	1367	2	ae_ther
aweather	14	3	426	2	aweather
bather	11	53	2251	2	_bather
beater	8	47	2939	2	beat_er
blather	12	53	1421	2	blather
bleacher	15	35	888	2	bleacher
bleater	9	45	1530	2	bleat_er
blether	12	45	991	2	ble_ther
breather	13	36	1060	2	breather
eater	5	46	3984	2	_eat_er
either	9	45	1742	2	_either
elater	6	47	2420	2	elat_er
ether	8	45	1877	2	_e_ther
father	12	51	1671	2	_father
feater	9	52	2405	2	feat_er
feathers	14	35	1324	2	feathers
feathery	17	36	807	2	feathery
gather	10	41	1586	2	_gather
heater	9	48	2830	2	heat_er
heathen	13	34	1089	2	heathen
heathers	14	39	1473	2	heathers
heathery	17	34	908	2	heathery
heathier	14	3	834	2	heathier
lasher	9	48	2453	2	l_asher
later	5	48	4392	2	l_at_er
lathe	8	56	2672	2	l_athe_
lathed	10	47	1846	2	l_athed
lathers	10	43	2188	2	l_athers
lathery	13	39	1112	2	l_athery
lathes	9	51	2750	2	l_athes
lathier	10	3	1083	2	l_athier
latter	6	50	2789	2	l_atter
leached	13	37	1504	2	leached
leachers	13	37	1281	2	leachers
leaches	12	33	1934	2	leaches
leachier	13	3	725	2	leachier
leader	7	48	2465	2	lea_der
leadier	8	32	1272	2	leadier
leafier	10	32	983	2	leafier
leaguer	8	3	579	2	leaguer
leaker	10	46	2007	2	lea_ker
leakier	11	40	1099	2	leakier
leaner	6	40	2219	2	lea_ner
leaper	8	81	1894	2	lea_per
learier	7	34	1566	2	learier
learner	7	31	938	2	learner
leaser	6	53	2267	2	lea_ser
leashed	11	32	1116	2	leashed
leashes	10	35	1440	2	leashes
leathered	13	14	871	2	leathered
leaver	9	43	2151	2	lea_ver
leavier	10	31	999	2	leavier
lecher	11	34	1585	2	le_cher
lefter	9	36	1343	2	left_er
lethe	8	57	1730	2	le_the_
lethes	9	48	1808	2	le_thes
letter	6	37	2258	2	le_tter
lither	9	45	2095	2	l_ither
loathe	9	42	1138	2	loathe_
loathed	11	41	944	2	loathed
loathers	11	33	1044	2	loathers
loathes	10	35	1324	2	loathes
meatier	9	32	1461	2	meatier
neater	6	44	2431	2	neat_er
neatherd	12	10	719	2	neatherd
neither	10	3	757	2	neither
nether	9	40	1416	2	ne_ther
peacher	14	42	1607	2	peacher
peatier	9	40	1723	2	peatier
pleater	9	39	1633	2	pleat_er
pleathers	14	4	645	2	pleathers
rather	9	43	1974	2	_rather
reacher	12	37	1829	2	reacher
regather	12	3	673	2	regather
seater	6	45	3416	2	seat_er
sheather	14	5	823	2	sheather
slather	10	38	1608	2	slather
swather	13	42	1360	2	swather
teacher	12	37	1483	2	teacher
teether	10	34	969	2	teether
tether	9	37	1610	2	te_ther
weathers	14	34	1283	2	weathers
wether	12	33	1539	2	we_ther
wreather	14	26	860	2	wreather

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.436	409841.7
2	DLD Change Limit	107671	95	3.643	29555.6
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	4.109	43487.7