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

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

65 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
biggies	11	38	1352	(None)
baggies	11	38	1485	1	baggies
biggie	10	38	1093	1	biggie_
biggins	11	34	1069	1	biggins
buggies	11	46	1381	1	buggies
piggies	11	38	1348	1	piggies
aggies	8	35	1551	2	_aggies
baggie	10	29	1219	2	baggie_
baggier	11	36	1164	2	baggier
baggiest	12	30	1175	2	baggiest
bialies	9	36	1841	2	bialies
biddies	11	35	1449	2	biddies
biffies	15	27	1085	2	biffies
bigamies	13	3	736	2	bigamies
bigeyes	13	3	565	2	bigeyes
bigger	10	43	1506	2	bigg_er
biggest	11	3	814	2	bigg_est
biggin	10	37	1060	2	biggi_n
bigging	12	28	1588	2	bigging
biggings	13	32	747	2	biggings
biggish	14	24	750	2	biggish
biggity	14	3	501	2	biggity
bigoses	10	3	907	2	bigoses
bigwigs	14	4	300	2	bigwigs
bikies	12	45	1516	2	bi_kies
bilbies	11	47	1233	2	bilbies
bilges	9	49	1563	2	bilg_es
bilgier	10	35	853	2	bilgier
bilgiest	11	30	988	2	bilgiest
billies	9	39	2350	2	billies
binges	9	39	2312	2	bing_es
bingoes	10	40	1397	2	bingoes
birdies	10	40	1621	2	birdies
birkies	13	37	1243	2	birkies
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
budgies	11	53	1251	2	budgies
buggier	11	36	1134	2	buggier
buggiest	12	34	1036	2	buggiest
dingies	9	36	1824	2	dingies
doggies	10	36	1302	2	doggies
giggles	10	33	1293	2	giggles
higgles	12	39	1180	2	higgles
jaggies	16	33	1108	2	jaggies
jiggier	16	37	782	2	jiggier
jiggiest	17	27	769	2	jiggiest
jiggles	16	41	1143	2	jiggles
luggies	9	30	1121	2	luggies
miggles	11	35	1203	2	miggles
moggies	11	31	1172	2	moggies
niggles	9	35	1220	2	niggles
piggie	10	32	1077	2	piggie_
piggier	11	35	1000	2	piggier
piggiest	12	25	966	2	piggiest
piggins	11	30	1047	2	piggins
pigmies	12	26	1099	2	pigmies
raggies	9	32	1473	2	raggies
veggies	12	3	755	2	veggies
wiggier	12	41	886	2	wiggier
wiggiest	13	26	901	2	wiggiest
wiggles	12	33	1246	2	wiggles

Search took 7 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	65	5.516	19519.8
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	5.892	30327.7