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

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

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

155 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
bather	11	53	2251	(None)
basher	11	51	2381	1	basher
batcher	14	44	1485	1	batcher
bathe	10	58	2288	1	bathe_
bathed	12	55	1874	1	bathed
bathers	12	47	2036	1	bathers
bathes	11	65	2483	1	bathes
batter	8	49	2887	1	batter
blather	12	53	1420	1	blather
bother	11	52	1806	1	bother
father	12	51	1671	1	father
gather	10	41	1585	1	gather
lather	9	51	2435	1	lather
rather	9	43	1973	1	rather
abater	8	55	1812	2	abat_er
aether	9	42	1367	2	aether
anther	9	37	1506	2	anther
babier	10	35	1556	2	babier
bached	14	55	1989	2	bached
baches	13	54	2694	2	baches
backer	14	45	2552	2	backer
badder	10	38	1751	2	badder
badger	10	54	1507	2	badger
bagger	10	46	1920	2	bagger
bailer	8	54	2525	2	bailer
baiter	8	44	2255	2	baiter
baker	11	56	2954	2	ba_ker
balder	9	53	1886	2	balder
baler	7	56	3527	2	ba_ler
balker	12	45	1916	2	balker
baller	8	38	2520	2	baller
bander	9	39	2822	2	bander
banger	9	44	2363	2	banger
banker	12	42	2273	2	banker
banner	8	44	2150	2	banner
banter	8	48	2533	2	banter
barber	10	44	1932	2	barber
barer	7	45	3580	2	ba_rer
barker	12	48	2286	2	barker
barter	8	55	2537	2	barter
baser	7	48	2892	2	ba_ser
bashed	12	62	2570	2	bashed
bashers	12	48	2083	2	bashers
bashes	11	56	3139	2	bashes
baster	8	53	3359	2	baster
batched	15	41	1424	2	batched
batchers	15	36	1327	2	batchers
batches	14	40	1961	2	batches
bate	6	65	5242	2	bat_e_
bated	8	59	3553	2	bat_ed
bates	7	58	4634	2	bat_es
bath	9	59	4008	2	bath__
bathos	11	62	1563	2	bathos
baths	10	59	2292	2	bath_s
batmen	10	44	1430	2	batmen
batted	9	56	2365	2	batted
batten	8	52	1712	2	batten
batters	9	46	2601	2	batters
battery	12	49	1181	2	battery
battier	9	35	1571	2	battier
battler	9	41	1338	2	battler
bawler	11	43	1505	2	bawler
beater	8	47	2939	2	beat_er
bethel	11	6	964	2	bethel
better	8	47	2370	2	better
biter	7	50	3003	2	bit_er
bitter	8	46	2267	2	bitter
blathers	13	47	1379	2	blathers
blatter	9	44	1565	2	blatter
blether	12	45	991	2	blether
blither	12	48	1217	2	blither
boater	8	46	2209	2	boat_er
botcher	14	36	1322	2	botcher
bothers	12	43	1775	2	bothers
brasher	12	45	1523	2	brasher
breather	13	36	1059	2	breather
brother	12	33	1133	2	brother
busher	11	49	2220	2	busher
butcher	14	34	1116	2	butcher
butler	8	42	2003	2	butler
butter	8	47	2423	2	butter
catcher	14	31	1582	2	catcher
cater	7	48	4070	2	cat_er
cither	11	46	1668	2	cither
dasher	10	43	1898	2	dasher
dater	6	53	3231	2	dat_er
dither	10	44	1768	2	dither
eater	5	46	3984	2	eat_er
either	9	45	1742	2	either
ether	8	45	1877	2	_ether
farther	13	4	834	2	farther
fathers	13	39	1650	2	fathers
fatter	9	45	2321	2	fatter
feather	13	36	1350	2	feather
gasher	10	43	2037	2	gasher
gater	6	45	3364	2	gat_er
gathers	11	43	1506	2	gathers
hatcher	15	33	1472	2	hatcher
hater	8	50	3475	2	hat_er
hatter	9	47	2487	2	hatter
heather	13	39	1485	2	heather
hither	12	44	1725	2	hither
ither	8	46	1760	2	_ither
kasher	13	49	1503	2	kasher
lasher	9	48	2453	2	lasher
later	5	48	4392	2	lat_er
lathe	8	56	2671	2	lathe_
lathed	10	47	1845	2	lathed
lathers	10	43	2188	2	lathers
lathery	13	39	1112	2	lathery
lathes	9	51	2749	2	lathes
lathier	10	3	1083	2	lathier
latter	6	50	2789	2	latter
leather	10	38	1578	2	leather
lither	9	45	2095	2	lither
loather	10	37	1100	2	loather
masher	11	41	2320	2	masher
matcher	14	32	1428	2	matcher
mater	7	44	3886	2	mat_er
matier	8	43	2152	2	matier
matter	8	43	2534	2	matter
mither	11	42	1856	2	mither
mother	11	37	1864	2	mother
natter	6	44	2074	2	natter
nether	9	40	1416	2	nether
nother	9	38	1596	2	nother
oater	5	54	3373	2	oat_er
other	8	42	1910	2	_other
panther	12	6	1144	2	panther
patcher	14	35	1514	2	patcher
pater	7	47	4072	2	pat_er
patter	8	46	2826	2	patter
patzer	17	31	1164	2	patzer
pother	11	38	1885	2	pother
rasher	9	50	2411	2	rasher
rater	5	49	4328	2	rat_er
rathe	8	58	2192	2	rathe_
ratter	6	43	2631	2	ratter
slather	10	38	1606	2	slather
swather	13	42	1359	2	swather
tater	5	41	3861	2	tat_er
tatter	6	40	2457	2	tatter
tether	9	37	1610	2	tether
tither	9	49	2028	2	tither
tother	9	41	1714	2	tother
washer	12	47	2039	2	washer
watcher	15	31	1340	2	watcher
water	8	47	3331	2	wat_er
watter	9	32	2198	2	watter
weather	13	35	1322	2	weather
wether	12	33	1539	2	wether
wither	12	43	2135	2	wither
wuther	12	45	1161	2	wuther
yatter	9	41	1621	2	yatter
zither	18	38	1308	2	zither

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	82551	0.123	1452772.4
2	DLD Change Limit	82551	155	3.626	22766.4
3	Display Results	155	155	0.093	1666.7
	(SQL Overall)	178691	155	3.842	46509.9