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

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

77 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
baggier	11	36	1164	(None)
bagger	10	46	1920	1	bagg_er
baggie	10	29	1219	1	baggie_
baggies	11	38	1485	1	baggies
boggier	11	37	1158	1	boggier
braggier	12	13	645	1	braggier
buggier	11	36	1134	1	buggier
faggier	12	30	984	1	faggier
jaggier	16	33	918	1	jaggier
naggier	9	30	915	1	naggier
saggier	9	29	1206	1	saggier
agger	7	64	2089	2	_agg_er
aggie	7	34	1501	2	_aggie_
aggies	8	35	1551	2	_aggies
babier	10	35	1557	2	ba_bier
badger	10	54	1508	2	badg_er
bagged	11	45	1990	2	bagg_ed
baggers	11	39	1569	2	bagg_ers
baggiest	12	30	1175	2	baggiest
baggily	14	3	604	2	baggily
bagging	12	33	1698	2	bagging
bagpiper	15	4	239	2	bagpiper
balkier	13	41	1198	2	balkier
balmier	11	38	1151	2	balmier
banger	9	44	2364	2	bang_er
barkier	13	38	1448	2	barkier
barmier	11	43	1304	2	barmier
barnier	9	32	1367	2	barnier
barrier	9	40	1775	2	barrier
battier	9	35	1572	2	battier
bawdier	13	37	820	2	bawdier
bigger	10	43	1506	2	bigg_er
biggie	10	38	1093	2	biggie_
biggies	11	38	1352	2	biggies
bilgier	10	35	853	2	bilgier
boggler	11	39	1008	2	boggler
bragger	11	38	1004	2	bragg_er
bugger	10	44	1872	2	bugg_er
buggies	11	46	1381	2	buggies
bulgier	10	39	1121	2	bulgier
cagier	9	37	1593	2	ca_gier
craggier	12	11	606	2	craggier
dagger	9	50	1730	2	dagg_er
doggier	10	38	1094	2	doggier
draggier	11	13	577	2	draggier
flaggier	13	10	520	2	flaggier
foggier	12	34	991	2	foggier
fuggier	12	34	896	2	fuggier
gagger	9	50	1651	2	gagg_er
haggler	12	32	893	2	haggler
jagger	15	40	1600	2	jagg_er
jaggies	16	33	1108	2	jaggies
jiggier	16	37	782	2	jiggier
lagger	8	59	1983	2	lagg_er
leggier	9	36	823	2	leggier
loggier	9	38	1114	2	loggier
mangier	10	41	1406	2	mangier
muggier	11	28	894	2	muggier
nagger	8	40	1612	2	nagg_er
piggier	11	35	1000	2	piggier
puggier	11	30	938	2	puggier
quaggier	19	3	385	2	quaggier
raggies	9	32	1473	2	raggies
rangier	8	37	1435	2	rangier
sagger	8	43	2107	2	sagg_er
sagier	7	37	1716	2	sa_gier
shaggier	13	11	605	2	shaggier
slaggier	10	12	695	2	slaggier
snaggier	10	13	630	2	snaggier
soggier	9	34	1088	2	soggier
staggier	10	16	751	2	staggier
tagger	8	40	1771	2	tagg_er
tangier	8	30	1391	2	tangier
vuggier	12	29	681	2	vuggier
wagger	11	36	1601	2	wagg_er
wagglier	13	4	432	2	wagglier
wiggier	12	41	886	2	wiggier

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.466	383457.1
2	DLD Change Limit	107671	77	3.406	31612.2
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	3.902	45794.7