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

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

73 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
baggies	11	38	1485	(None)
aggies	8	35	1551	1	_aggies
baggie	10	29	1219	1	baggie_
baggier	11	36	1164	1	baggier
baggiest	12	30	1175	1	baggiest
biggies	11	38	1352	1	biggies
buggies	11	46	1381	1	buggies
jaggies	16	33	1108	1	jaggies
raggies	9	32	1473	1	raggies
aggie	7	34	1501	2	_aggie_
babies	10	61	2365	2	ba_bies
baddies	11	40	1787	2	baddies
badges	10	39	1737	2	badg_es
baffies	15	36	1294	2	baffies
baggages	13	3	544	2	baggages
bagged	11	45	1990	2	bagg_ed
bagger	10	46	1920	2	bagg_er
baggers	11	39	1569	2	baggers
baggily	14	3	604	2	baggily
bagginess	13	5	595	2	bagginess
bagging	12	33	1698	2	bagging
baggings	13	30	752	2	baggings
bagnios	10	3	607	2	bagnios
bagpipes	15	4	340	2	bagpipes
bagwigs	14	3	282	2	bagwigs
bailies	9	41	2020	2	bailies
baldies	10	53	1770	2	baldies
ballies	9	37	2574	2	ballies
bandies	10	41	2486	2	bandies
bangles	10	36	1741	2	bangles
banties	9	43	2476	2	banties
barbies	11	45	1959	2	barbies
bargees	10	54	1587	2	bargees
barges	9	45	2825	2	barg_es
bawdies	13	46	1339	2	bawdies
bawties	12	42	1431	2	bawties
biggie	10	38	1093	2	biggie_
biggins	11	34	1069	2	biggins
boggier	11	37	1158	2	boggier
boggiest	12	31	1093	2	boggiest
boggles	11	34	1182	2	boggles
bogies	9	47	2431	2	b_ogies
boogies	10	37	1901	2	boogies
bougies	10	37	1518	2	bougies
braggier	12	13	645	2	braggier
braggiest	13	11	678	2	braggiest
budgies	11	53	1251	2	budgies
buggier	11	36	1134	2	buggier
buggiest	12	34	1036	2	buggiest
daggles	10	36	1191	2	daggles
doggies	10	36	1302	2	doggies
faggier	12	30	984	2	faggier
faggiest	13	29	1018	2	faggiest
gaggles	10	35	1259	2	gaggles
haggis	11	20	951	2	haggi_s
haggises	13	3	588	2	haggises
haggles	12	33	1248	2	haggles
jaggier	16	33	918	2	jaggier
jaggiest	17	28	932	2	jaggiest
luggies	9	30	1121	2	luggies
magpies	12	3	1036	2	magpies
moggies	11	31	1172	2	moggies
naggier	9	30	915	2	naggier
naggiest	10	26	1001	2	naggiest
piggies	11	38	1348	2	piggies
raggees	9	37	1091	2	raggees
raggles	9	38	1328	2	raggles
saggier	9	29	1206	2	saggier
saggiest	10	28	1272	2	saggiest
staggies	10	12	1032	2	staggies
swaggies	13	13	669	2	swaggies
veggies	12	3	755	2	veggies
waggles	12	38	1200	2	waggles

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	107671	0.360	496363.9
2	DLD Change Limit	107671	73	3.173	33933.5
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	3.563	50151.8