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

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

72 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
beatings	11	41	1323	(None)
beadings	12	37	1178	1	beadings
bearings	11	39	1225	1	bearings
beastings	12	38	765	1	beastings
beating	10	43	2687	1	beating_
beltings	11	36	925	1	beltings
boatings	11	37	1011	1	boatings
eatings	8	46	1644	1	_eatings
seatings	9	36	1430	1	seatings
bakings	14	43	1202	2	b_akings
bastings	11	42	1469	2	bastings
bating	9	51	3225	2	b_ating_
battings	11	40	1057	2	battings
beading	11	32	2186	2	beading_
beaming	12	36	1880	2	beaming_
beaning	10	38	2068	2	beaning_
bearing	10	36	2477	2	bearing_
beatniks	14	4	404	2	beatniks
beddings	13	40	792	2	beddings
beestings	12	33	592	2	beestings
beings	9	46	1303	2	be__ings
bellings	11	38	1115	2	bellings
belting	10	41	1913	2	belting_
berating	11	32	2076	2	berating_
besting	10	49	2392	2	besting_
betaines	10	3	1329	2	betaines
betting	10	39	2140	2	betting_
biestings	12	26	603	2	biestings
bittings	11	33	929	2	bittings
bladings	12	33	775	2	bladings
blastings	12	34	791	2	blastings
bleating	11	35	1450	2	bleating_
boating	10	37	2130	2	boating_
bracings	13	36	929	2	bracings
breakings	16	29	706	2	breakings
breathings	16	23	431	2	breathings
buntings	11	34	877	2	buntings
coatings	11	38	1184	2	coatings
dealings	10	35	1070	2	dealings
earings	8	45	1771	2	_earings
eastings	9	34	1295	2	_eastings
eating	7	51	3440	2	_eating_
feltings	12	31	790	2	feltings
gatings	9	52	1282	2	_gatings
gearings	10	35	950	2	gearings
gratings	10	39	1076	2	gratings
headings	13	35	1049	2	headings
hearings	12	36	1185	2	hearings
heating	11	40	2432	2	heating_
jestings	16	36	802	2	jestings
leadings	10	35	1124	2	leadings
leanings	9	40	1018	2	leanings
leasings	9	37	984	2	leasings
leavings	12	40	749	2	leavings
matings	10	45	1621	2	_matings
meanings	11	32	916	2	meanings
meetings	11	28	741	2	meetings
nettings	9	28	810	2	nettings
pettings	11	34	970	2	pettings
platings	11	36	1136	2	platings
ratings	8	42	1741	2	_ratings
readings	10	35	1264	2	readings
seating	8	41	3068	2	seating_
settings	9	38	1007	2	settings
skatings	13	32	699	2	skatings
slatings	9	40	1172	2	slatings
vestings	12	35	914	2	vestings
weltings	12	38	820	2	weltings
westings	12	42	980	2	westings
wettings	12	34	840	2	wettings
yealings	12	25	770	2	yealings
zeatins	16	3	1173	2	zeatin_s

Search took 6 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	121059	0.766	233278.1
2	DLD Change Limit	121059	72	4.640	26090.3
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	5.439	32853.6