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

Here are the results of your fuzzy-string dictionary search for “buggery” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

317 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
buggery	14	36	793	(None)
bugger	10	44	1872	1	bugger_
buggers	11	43	1566	1	buggers
bagger	10	46	1920	2	bagger_
baggers	11	39	1569	2	baggers
beggary	14	31	615	2	beggary
bigger	10	43	1506	2	bigger_
biggety	14	3	443	2	biggety
budger	10	46	1770	2	budger_
budgers	11	43	1492	2	budgers
bugged	11	43	1840	2	bugge_d
buggered	13	3	562	2	buggered
buggier	11	36	1134	2	buggier_
buggy	12	46	1348	2	bugg__y
bugler	9	47	1772	2	bugler_
buglers	10	51	1532	2	buglers
bulger	9	49	1735	2	bulger_
bulgers	10	52	1514	2	bulgers
burger	9	40	2079	2	burger_
burgers	10	39	1857	2	burgers
butlery	12	36	942	2	butlery
buttery	12	43	1119	2	buttery
doggery	13	44	826	2	doggery
hugger	11	47	1312	2	hugger_
huggers	12	42	1159	2	huggers
jaggery	19	33	690	2	jaggery
jugglery	20	30	381	2	jugglery
lugger	8	39	1655	2	lugger_
luggers	9	37	1348	2	luggers
mugger	10	39	1470	2	mugger_
muggers	11	36	1193	2	muggers
nuggety	12	3	431	2	nuggety
piggery	14	26	619	2	piggery
puggry	13	37	482	2	pugg_ry
rugger	8	44	1451	2	rugger_
ruggers	9	46	1231	2	ruggers
snuggery	13	25	397	2	snuggery
surgery	11	31	920	2	surgery
thuggery	16	4	256	2	thuggery
toggery	12	50	592	2	toggery
tugger	8	40	1310	2	tugger_
tuggers	9	37	1144	2	tuggers
waggery	15	27	690	2	waggery
wiggery	15	29	587	2	wiggery
agger	7	64	2089	3	_agger_
aggers	8	58	1779	3	_aggers
auger	6	49	2247	3	au_ger_
augers	7	38	1870	3	au_gers
augury	10	36	666	3	au_gury
badger	10	54	1507	3	badger_
badgerly	15	4	328	3	badgerly
badgers	11	48	1264	3	badgers
bagged	11	45	1990	3	bagge_d
baggier	11	36	1164	3	baggier_
baggily	14	3	604	3	baggily
baggy	12	56	1568	3	bagg__y
bakery	15	59	1100	3	b_akery
banger	9	44	2363	3	banger_
bangers	10	40	2035	3	bangers
battery	12	49	1181	3	battery
beanery	12	3	756	3	beanery
beery	10	52	2012	3	b__eery
beggar	10	32	822	3	beggar_
beggarly	15	29	339	3	beggarly
beggars	11	37	822	3	beggars
begged	11	50	1380	3	begge_d
bergere	10	6	891	3	bergere
bibbery	13	42	654	3	bibbery
biggest	11	3	814	3	biggest
biggity	14	3	501	3	biggity
biggy	12	44	1313	3	bigg__y
bigotry	13	4	452	3	bigotry
bindery	13	45	983	3	bindery
binger	9	49	2345	3	binger_
bingers	10	45	1999	3	bingers
biogeny	13	3	602	3	biogeny
blogger	11	44	831	3	blogger_
bloggers	12	39	740	3	bloggers
blubbery	14	29	478	3	blubbery
bludger	11	41	956	3	bludger_
bludgers	12	39	785	3	bludgers
blunger	10	41	1201	3	blunger_
blungers	11	46	984	3	blungers
blustery	13	36	800	3	blustery
bobbery	13	43	835	3	bobbery
bogey	11	52	2023	3	b_oge_y
bogged	11	60	1928	3	bogge_d
boggier	11	37	1158	3	boggier_
boggler	11	39	1008	3	boggler_
bogglers	12	34	760	3	bogglers
boggy	12	61	1607	3	bogg__y
booger	9	48	1655	3	booger_
boogers	10	45	1463	3	boogers
boogey	12	47	1152	3	booge_y
bootery	12	3	898	3	bootery
bouldery	14	29	501	3	bouldery
bowery	14	60	1211	3	b_owery
bragger	11	38	1004	3	bragger_
braggers	12	32	790	3	braggers
bravery	15	42	813	3	bravery
brewery	15	37	695	3	brewery
bribery	14	42	648	3	bribery
briery	11	45	1077	3	b_riery
broguery	14	4	331	3	broguery
bucker	14	54	2046	3	bucker_
buckers	15	35	1745	3	buckers
budder	10	43	1481	3	budder_
budders	11	38	1210	3	budders
budge	9	46	1987	3	budge__
budged	11	45	1723	3	budge_d
budges	10	48	2012	3	budge_s
budget	10	46	1811	3	budge_t
budgetary	16	5	180	3	budgetary
budgets	11	48	986	3	budgets
buffer	14	45	1268	3	buffer_
buffers	15	33	1079	3	buffers
bugbear	12	3	395	3	bugbear
bugbears	13	3	369	3	bugbears
bugeye	12	3	653	3	bu_geye
buggeries	13	4	708	3	buggeries
buggering	14	3	519	3	buggering
buggies	11	46	1381	3	buggies
buggiest	12	34	1036	3	buggiest
bugging	12	35	1518	3	bugging
bugle	8	47	2194	3	bugle__
bugled	10	49	1813	3	bugle_d
bugles	9	48	2244	3	bugle_s
bugseed	11	3	617	3	bugseed
bulge	8	64	1987	3	bulge__
bulged	10	51	1712	3	bulge_d
bulges	9	59	1932	3	bulge_s
bulgier	10	39	1121	3	bulgier_
bulgur	9	38	753	3	bulgur_
bulgurs	10	39	711	3	bulgurs
bulgy	11	52	1410	3	bulg__y
bummer	12	40	1410	3	bummer_
bummers	13	37	1244	3	bummers
bumper	12	37	1434	3	bumper_
bumpers	13	39	1205	3	bumpers
bunged	10	52	1879	3	bunge_d
bungee	9	63	1977	3	bunge_e
bungees	10	45	1310	3	bungees
bungler	10	46	1148	3	bungler_
bunglers	11	39	848	3	bunglers
bunker	12	45	1937	3	bunker_
bunkers	13	37	1595	3	bunkers
bunter	8	50	2038	3	bunter_
bunters	9	47	1711	3	bunters
burgee	9	71	2059	3	burge_e
burgees	10	49	1589	3	burgees
burgeon	10	3	643	3	burgeon
burgess	10	40	934	3	burgess
burgher	13	3	700	3	burgher_
burghers	14	3	563	3	burghers
burglary	14	7	313	3	burglary
burier	8	43	2465	3	burier_
buriers	9	40	1719	3	buriers
burker	12	52	2117	3	burker_
burkers	13	37	1662	3	burkers
burler	8	47	2383	3	burler_
burlers	9	41	2027	3	burlers
burley	11	47	1575	3	burle_y
burner	8	38	1920	3	burner_
burners	9	41	1567	3	burners
burrer	8	37	1847	3	burrer_
burrers	9	38	1449	3	burrers
burry	10	52	2156	3	bu__rry
bursary	12	39	758	3	bursary
bursera	9	3	676	3	bursera
bury	9	56	3359	3	bu___ry
busgirl	10	4	414	3	busgirl
busher	11	49	2220	3	busher_
bushers	12	40	1880	3	bushers
busier	8	52	1972	3	busier_
busker	12	55	1783	3	busker_
buskers	13	34	1408	3	buskers
buster	8	47	2649	3	buster_
busters	9	47	2412	3	busters
butchery	18	32	625	3	butchery
butler	8	42	2003	3	butler_
butlers	9	45	1805	3	butlers
butter	8	47	2423	3	butter_
butters	9	45	2171	3	butters
buyer	10	50	1309	3	bu_yer_
buyers	11	45	1100	3	bu_yers
buzzer	16	37	911	3	buzzer_
buzzers	17	34	717	3	buzzers
chugger	14	4	537	3	chugger_
chuggers	15	5	485	3	chuggers
cutlery	12	44	839	3	cutlery
dagger	9	50	1730	3	dagger_
daggers	10	37	1491	3	daggers
debugger	13	4	312	3	debugger_
debuggers	14	4	271	3	debuggers
digger	9	46	1608	3	digger_
diggers	10	44	1338	3	diggers
dodgery	13	62	778	3	dodgery
dogger	9	52	1678	3	dogger_
doggers	10	44	1343	3	doggers
drudgery	14	27	363	3	drudgery
dupery	12	37	874	3	du_pery
egger	7	44	1440	3	_egger_
eggers	8	46	1258	3	_eggers
fogger	11	44	1478	3	fogger_
foggers	12	41	1201	3	foggers
forgery	14	41	930	3	forgery
fugged	12	46	1538	3	fugge_d
fuggier	12	34	896	3	fuggier_
fuggily	15	3	496	3	fuggily
fuggy	13	54	1167	3	fugg__y
fullery	13	33	797	3	fullery
gagger	9	50	1651	3	gagger_
gaggers	10	34	1366	3	gaggers
gingery	12	36	890	3	gingery
groggery	14	3	351	3	groggery
gunnery	11	37	637	3	gunnery
guttery	11	42	775	3	guttery
hogger	11	46	1508	3	hogger_
hoggers	12	45	1248	3	hoggers
hugely	13	3	680	3	hu_gely
huger	9	49	1487	3	hu_ger_
hugged	12	41	1364	3	hugge_d
humbuggery	22	5	123	3	~~hum~~buggery
hunger	10	40	1520	3	hunger_
hungers	11	40	1330	3	hungers
hungry	13	3	497	3	hung_ry
imagery	13	12	420	3	imagery
jaggary	19	30	486	3	jaggary
jagger	15	40	1600	3	jagger_
jaggers	16	40	1289	3	jaggers
jagghery	23	5	180	3	jagghery
jigger	15	53	1305	3	jigger_
jiggers	16	40	1017	3	jiggers
jogger	15	47	1316	3	jogger_
joggers	16	41	1069	3	joggers
judger	15	44	1144	3	judger_
judgers	16	36	904	3	judgers
jugged	16	38	1393	3	jugge_d
juggler	16	41	887	3	juggler_
jugglers	17	36	652	3	jugglers
kegger	12	38	806	3	kegger_
keggers	13	35	703	3	keggers
lagger	8	59	1983	3	lagger_
laggers	9	42	1624	3	laggers
logger	8	64	2000	3	logger_
loggers	9	46	1613	3	loggers
luger	6	53	2208	3	lu_ger_
lugers	7	46	1702	3	lu_gers
lugged	9	44	1705	3	lugge_d
lunger	7	57	2042	3	lunger_
lungers	8	38	1709	3	lungers
muggar	10	31	644	3	muggar_
muggars	11	31	664	3	muggars
mugged	11	41	1383	3	mugge_d
muggee	10	36	1283	3	mugge_e
muggees	11	33	888	3	muggees
muggier	11	28	894	3	muggier_
muggily	14	3	510	3	muggily
muggur	10	32	559	3	muggur_
muggurs	11	31	510	3	muggurs
muggy	12	56	1237	3	mugg__y
mummery	13	33	666	3	mummery
nagger	8	40	1612	3	nagger_
naggers	9	38	1265	3	naggers
nigger	8	97	1357	3	nigger_
niggers	9	31	1131	3	niggers
nudger	8	51	1163	3	nudger_
nudgers	9	47	937	3	nudgers
nugget	8	3	1172	3	nugge_t
nuggets	9	3	638	3	nuggets
nunnery	10	35	530	3	nunnery
nursery	10	39	602	3	nursery
plugger	11	37	842	3	plugger_
pluggers	12	29	702	3	pluggers
priggery	15	4	399	3	priggery
puckery	18	30	626	3	puckery
puffery	18	23	511	3	puffery
pugged	11	43	1452	3	pugge_d
puggier	11	30	938	3	puggier_
puggree	11	17	611	3	puggree
puggy	12	46	1232	3	pugg__y
purger	9	47	1723	3	purger_
purgers	10	47	1400	3	purgers
quavery	22	22	548	3	quavery
query	17	42	1208	3	qu__ery
quivery	22	26	545	3	quivery
raggedy	13	33	466	3	raggedy
rigger	8	56	1671	3	rigger_
riggers	9	36	1383	3	riggers
roguery	11	3	489	3	roguery
rubbery	14	33	759	3	rubbery
rudery	10	41	903	3	ru_dery
rugged	9	42	1537	3	rugge_d
ruggedly	14	18	297	3	ruggedly
sagger	8	43	2107	3	sagger_
saggers	9	40	1708	3	saggers
slugger	9	36	1067	3	slugger_
sluggers	10	34	848	3	sluggers
smugger	11	32	705	3	smugger_
snugger	9	31	831	3	snugger_
staggery	13	34	624	3	staggery
sugary	10	3	901	3	su_gary
suggest	9	3	1086	3	suggest
summery	14	32	941	3	summery
surger	7	43	2009	3	surger_
surgers	8	35	1748	3	surgers
tagger	8	40	1770	3	tagger_
taggers	9	35	1419	3	taggers
tugged	9	38	1352	3	tugge_d
turnery	10	35	742	3	turnery
tushery	13	3	563	3	tushery
urger	6	41	1647	3	_urger_
urgers	7	33	1362	3	_urgers
vuggier	12	29	681	3	vuggier_
vuggy	13	58	948	3	vugg__y
wagger	11	36	1601	3	wagger_
waggers	12	46	1308	3	waggers

Search took 8 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	134027	0.140	1276364.3
2	DLD Change Limit	134027	317	7.143	18763.4
3	Display Results	317	317	0.123	2577.2
	(SQL Overall)	178691	317	7.406	24127.9