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

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

80 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
beaten	8	46	1706	(None)
beater	8	47	2939	1	beater
eaten	5	53	2305	1	_eaten
neaten	6	42	1454	1	neaten
bate	6	65	5242	2	b_ate_
bated	8	59	3553	2	b_ated
bates	7	58	4634	2	b_ates
batmen	10	44	1430	2	b_atmen
baton	7	58	2242	2	b_aton
batten	8	52	1712	2	batten
beacon	10	5	1137	2	beacon
beaded	10	49	2242	2	beaded
beader	9	46	2379	2	beader
beadmen	12	29	945	2	beadmen
beaked	13	59	1949	2	beaked
beaker	12	55	2069	2	beaker
beamed	11	57	2073	2	beamed
bean	6	64	4386	2	bea__n
beaned	9	56	2147	2	beaned
bearer	8	53	2391	2	bearer
beat	6	61	6830	2	beat__
beaters	9	49	2504	2	beaters
beating	10	43	2687	2	beating
beats	7	60	4224	2	beat_s
beaver	11	48	1925	2	beaver
been	6	53	3578	2	be__en
belated	10	35	2001	2	belated
belted	9	40	2063	2	belted
belter	8	47	2096	2	belter
berate	8	47	2902	2	berate_
berated	10	44	2213	2	berated
berates	9	41	2687	2	berates
bested	9	49	2275	2	bested
betaken	13	43	828	2	betaken
betel	7	44	1990	2	be_tel
beton	7	60	2206	2	be_ton
betted	9	47	2116	2	betted
better	8	47	2370	2	better
bitten	8	47	1512	2	bitten
blate	7	59	3378	2	blate_
bleated	10	40	1597	2	bleated
bleater	9	45	1530	2	bleater
boated	9	42	2197	2	boated
boatel	8	43	1409	2	boatel
boater	8	46	2209	2	boater
boatmen	11	4	691	2	boatmen
brazen	17	48	1245	2	brazen
deaden	8	37	1432	2	deaden
deafen	10	38	967	2	deafen
eater	5	46	3984	2	_eater
feater	9	52	2405	2	feater
greaten	8	36	1064	2	greaten
hearten	10	24	1175	2	hearten
heated	10	45	2559	2	heated
heater	9	48	2830	2	heater
heathen	13	34	1089	2	heathen
heaven	12	39	1260	2	heaven
laten	5	43	2834	2	_laten
leaden	7	45	1522	2	leaden
leaven	9	50	1307	2	leaven
lenten	6	3	1288	2	lenten
meated	9	42	2240	2	meated
meatmen	11	3	824	2	meatmen
neatens	7	33	1040	2	neatens
neater	6	44	2431	2	neater
oaten	5	52	2240	2	_oaten
paten	7	48	2734	2	_paten
peahen	11	34	1013	2	peahen
peasen	8	48	1596	2	peasen
pecten	10	27	1110	2	pecten
platen	8	45	1820	2	platen
seamen	8	45	1856	2	seamen
seated	7	51	3106	2	seated
seater	6	45	3416	2	seater
teated	7	49	2402	2	teated
unbeaten	10	3	801	2	unbeaten
uneaten	7	4	1254	2	uneaten
weaken	13	34	960	2	weaken
wheaten	13	3	640	2	wheaten
zeatin	15	4	1282	2	zeatin

Search took 4 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.360	496363.9
2	DLD Change Limit	82551	80	2.623	31472.0
3	Display Results	80	80	0.016	5000.0
	(SQL Overall)	178691	80	2.999	59583.5