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

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

160 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
quaggy	20	8	468	(None)
quagga	17	5	414	1	quagga
baggy	12	56	1568	2	_baggy
braggy	13	33	717	2	braggy
buggy	12	46	1348	2	bu_ggy
craggy	13	39	660	2	craggy
draggy	12	34	682	2	draggy
faggy	13	65	1437	2	_faggy
flaggy	14	41	592	2	flaggy
fuggy	13	54	1167	2	fu_ggy
jaggy	17	59	1314	2	_jaggy
muggy	12	56	1237	2	mu_ggy
naggy	10	66	1282	2	_naggy
puggy	12	46	1232	2	pu_ggy
quacky	24	37	696	2	quacky
quag	14	48	1594	2	qua_g_
quaggas	18	9	370	2	quaggas
quags	15	46	1325	2	qua_gs
quaigh	19	3	546	2	quaigh
quaky	21	43	1074	2	qua_ky
qualmy	20	28	580	2	qualmy
quango	16	3	649	2	quango
quarry	18	3	747	2	quarry
quay	16	46	1835	2	qua__y
raggy	10	61	1657	2	_raggy
saggy	10	59	1746	2	_saggy
shaggy	14	47	804	2	shaggy
slaggy	11	43	879	2	slaggy
snaggy	11	48	805	2	snaggy
staggy	11	55	1039	2	staggy
vuggy	13	58	948	2	vu_ggy
agly	8	68	2180	3	__agly
anagogy	12	17	444	3	anagogy
biggy	12	44	1313	3	_biggy
boggy	12	61	1607	3	_boggy
bulgy	11	52	1410	3	bu_lgy
cadgy	12	52	1078	3	_cadgy
cagey	11	59	1782	3	_cagey
cagy	10	63	2199	3	_ca_gy
cloggy	13	4	487	3	cloggy
dagga	8	3	954	3	_dagga
doggy	11	52	1487	3	_doggy
dreggy	12	36	463	3	dreggy
druggy	12	34	474	3	druggy
dually	10	32	1006	3	dually
dungy	10	47	1364	3	du_ngy
eggy	9	66	1185	3	__eggy
equably	21	3	618	3	equably
equally	19	3	687	3	equally
eulogy	10	3	563	3	eulogy
foggy	13	67	1454	3	_foggy
froggy	14	3	449	3	froggy
groggy	12	3	480	3	groggy
guanay	10	3	791	3	guanay
hoagy	12	47	1047	3	hoa_gy
hungry	13	3	497	3	hungry
jagg	13	61	1531	3	_jagg_
jaggs	14	81	1149	3	_jaggs
jiggy	17	54	914	3	_jiggy
jungly	17	40	769	3	jungly
leggy	10	52	1024	3	_leggy
loggy	10	57	1419	3	_loggy
mangy	11	50	2124	3	_mangy
moggy	12	52	1216	3	_moggy
mugg	8	63	1601	3	mu_gg_
muggs	9	49	1232	3	mu_ggs
orangy	10	51	1123	3	orangy
otalgy	10	3	535	3	otalgy
piggy	12	40	1143	3	_piggy
plaguy	12	38	641	3	plaguy
pudgy	12	49	1116	3	pu_dgy
puggry	13	37	482	3	puggry
qua	12	48	2197	3	qua___
quack	20	38	1250	3	qua_ck
quacks	21	47	1010	3	quacks
quad	14	46	1870	3	qua__d
quads	15	45	1584	3	qua_ds
quaere	15	41	1067	3	quaere
quaff	20	13	1135	3	qua_ff
quaffs	21	12	569	3	quaffs
quaggier	19	3	385	3	quaggier
quagmiry	23	4	172	3	quagmiry
quahog	19	4	410	3	quahog
quahogs	20	4	316	3	quahogs
quai	13	44	2039	3	qua__i
quaich	20	4	769	3	quaich
quaighs	20	4	349	3	quaighs
quail	14	43	1436	3	qua_il
quails	15	34	1264	3	quails
quaint	15	4	1517	3	quaint
quais	14	46	1839	3	qua_is
quake	18	41	1464	3	qua_ke
quaked	20	39	1003	3	quaked
quaker	19	38	1162	3	quaker
quakes	19	40	1334	3	quakes
quakily	23	3	669	3	quakily
quale	14	36	1785	3	qua_le
qualia	15	5	956	3	qualia
qualify	22	3	547	3	qualify
quality	19	3	856	3	quality
qualm	16	35	1118	3	qua_lm
qualms	17	31	724	3	qualms
quangos	17	3	465	3	quangos
quant	14	36	2481	3	qua_nt
quanta	15	39	1133	3	quanta
quants	15	36	1414	3	quants
quare	14	39	2054	3	qua_re
quark	18	46	1412	3	qua_rk
quarks	19	38	1091	3	quarks
quart	14	40	2785	3	qua_rt
quarte	15	41	1532	3	quarte
quarto	15	35	1112	3	quarto
quarts	15	47	1593	3	quarts
quartz	24	42	1210	3	quartz
quasar	15	3	683	3	quasar
quash	17	45	1216	3	qua_sh
quasi	14	40	1502	3	qua_si
quass	14	44	1376	3	qua_ss
quate	14	45	2141	3	qua_te
quatre	15	35	1235	3	quatre
quaver	18	30	931	3	quaver
quavery	22	22	548	3	quavery
quayage	20	4	457	3	quayage
quays	17	46	1204	3	qua_ys
queasy	18	5	517	3	queasy
queazy	27	4	357	3	queazy
query	17	42	1208	3	qu_ery
quey	16	46	1647	3	qu__ey
quinsy	18	38	635	3	quinsy
quippy	22	38	426	3	quippy
quirky	22	43	553	3	quirky
ragg	6	56	2269	3	_ragg_
raggs	7	52	1647	3	_raggs
rangy	9	53	2038	3	_rangy
rugby	11	44	813	3	ru_gby
sagy	8	53	2708	3	_sa_gy
saughy	13	50	746	3	saughy
scraggy	14	30	458	3	scraggy
slangy	10	54	1139	3	slangy
smoggy	13	5	428	3	smoggy
soggy	10	54	1390	3	_soggy
squabby	23	4	328	3	squabby
squally	19	3	767	3	squally
squashy	22	3	384	3	squashy
squatly	19	4	643	3	squatly
squatty	19	6	482	3	squatty
squiggly	22	4	250	3	squiggly
stagey	10	59	1558	3	stagey
stagy	9	66	1889	3	sta_gy
suably	11	28	1453	3	suably
sugary	10	3	901	3	sugary
surgy	9	51	1852	3	su_rgy
tangy	9	45	1993	3	_tangy
twangy	13	38	698	3	twangy
twiggy	14	3	293	3	twiggy
ugly	8	60	1238	3	_u_gly
vugg	9	56	1271	3	vu_gg_
vuggs	10	57	913	3	vu_ggs
waggly	14	34	729	3	_waggly
wiggy	13	45	1073	3	_wiggy

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	112716	0.373	479064.3
2	DLD Change Limit	112716	160	6.720	16773.2
3	Display Results	160	160	0.063	2539.7
	(SQL Overall)	178691	160	7.156	24970.8