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

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

322 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
gunnels	8	35	856	(None)
funnels	10	34	817	1	funnels
gunnel	7	34	1105	1	gunnel_
gunners	8	31	1173	1	gunners
gunsels	8	33	813	1	gunsels
runnels	7	32	915	1	runnels
tunnels	7	32	872	1	tunnels
cannels	9	34	1336	2	cannels
chunnels	13	30	455	2	chunnels
cunners	9	39	1347	2	cunners
dunness	8	29	898	2	dunness
fennels	10	38	790	2	fennels
funnel	9	36	1074	2	funnel_
gannets	8	38	1144	2	gannets
ginners	8	43	1422	2	ginners
guineas	8	3	675	2	guineas
gunless	8	29	963	2	gunless
gunned	8	35	1309	2	gunne_d
gunnen	7	33	871	2	gunne_n
gunner	7	38	1398	2	gunne_r
gunnery	11	37	637	2	gunnery
gunnies	8	34	1312	2	gunnies
gunsel	7	33	985	2	gunsel_
gurnets	8	40	1079	2	gurnets
gurneys	11	40	646	2	gurneys
kennels	11	38	719	2	kennels
punners	9	41	1423	2	punners
punnets	9	40	926	2	punnets
ronnels	7	31	861	2	ronnels
runnel	6	35	1066	2	runnel_
runners	7	42	1245	2	runners
trunnels	8	4	451	2	trunnels
tunnel	6	43	1063	2	tunnel_
aginners	9	5	462	3	aginners
angels	7	44	1617	3	_angels
annals	6	64	1592	3	_annals
anneals	7	44	994	3	_anneals
annuls	6	47	1173	3	_annuls
banners	9	40	1871	3	banners
bannets	9	40	1384	3	bannets
bennes	8	60	1901	3	benne_s
bennets	9	47	1216	3	bennets
bonnes	8	56	2145	3	bonne_s
bonnets	9	48	1280	3	bonnets
bulbels	11	39	801	3	bulbels
bundles	10	35	1577	3	bundles
bungees	10	45	1310	3	bungees
bungles	10	41	1676	3	bungles
bunkers	13	37	1595	3	bunkers
bunnies	9	44	1500	3	bunnies
bunns	7	47	1829	3	bunn__s
bunters	9	47	1712	3	bunters
burners	9	41	1567	3	burners
burnets	9	38	1326	3	burnets
bushels	12	41	1071	3	bushels
cancels	11	41	1331	3	cancels
cannel	8	42	1640	3	cannel_
canners	9	38	2266	3	canners
channels	13	38	849	3	channels
chunnel	12	39	530	3	chunnel_
conners	9	40	2311	3	conners
cornels	9	47	1666	3	cornels
counsels	10	3	758	3	counsels
crenels	9	37	1101	3	crenels
cudgels	11	3	533	3	cudgels
cunner	8	39	1500	3	cunne_r
cupels	10	3	1020	3	cu_pels
darnels	8	37	1043	3	darnels
dinners	8	39	1544	3	dinners
donnees	8	42	1036	3	donnees
donzels	17	3	539	3	donzels
duels	6	56	1923	3	du__els
dueness	8	23	1012	3	dueness
duffels	14	29	645	3	duffels
dulness	8	30	798	3	dulness
dunces	9	52	1575	3	dunce_s
dunes	6	53	3217	3	du_ne_s
dunkers	12	35	1219	3	dunkers
dunned	8	50	1552	3	dunne_d
dunner	7	39	1382	3	dunne_r
dunnest	8	33	1226	3	dunnest
dynels	10	53	681	3	_dynels
eupneas	9	3	523	3	eupneas
fanners	10	39	1465	3	fanners
fennecs	12	30	569	3	fennecs
fennel	9	42	947	3	fennel_
flannels	11	3	484	3	flannels
fuels	8	71	1735	3	fu__els
fulness	10	24	896	3	fulness
funders	11	38	1393	3	funders
fungals	11	27	678	3	fungals
funkers	14	37	1206	3	funkers
funned	10	36	1395	3	funne_d
funneled	12	5	487	3	funneled
funner	9	34	1410	3	funne_r
funnest	10	29	1200	3	funnest
funnies	10	41	1360	3	funnies
funnily	13	3	637	3	funnily
fusels	9	44	1245	3	fu_sels
gainers	8	42	1459	3	gainers
ganders	9	35	2170	3	ganders
ganefs	10	48	920	3	g_anefs
ganevs	10	45	691	3	g_anevs
gangers	9	44	1860	3	gangers
gangrels	10	9	497	3	gangrels
gannet	7	43	2185	3	ganne_t
garners	8	38	1598	3	garners
garnets	8	41	1540	3	garnets
gauntness	10	4	420	3	gauntness
gavels	10	59	1109	3	g_avels
gayness	11	3	684	3	gayness
gels	5	68	3610	3	g___els
genders	9	36	1678	3	genders
genes	6	51	3309	3	g_ene_s
genets	7	57	1666	3	g_enets
genies	7	53	2494	3	genie_s
genres	7	55	1562	3	genre_s
gentes	7	53	2416	3	gente_s
gentles	8	37	1434	3	gentles
gimels	9	3	889	3	g_imels
gingals	9	10	931	3	gingals
gingeli	9	28	615	3	gingeli
gingelis	10	24	709	3	gingelis
gingely	12	37	821	3	gingely
gingers	9	41	1864	3	gingers
ginned	8	38	1398	3	ginne_d
ginner	7	39	1582	3	ginne_r
gluiness	9	3	736	3	gluiness
glumness	11	3	520	3	glumness
gnarls	7	42	1077	3	g_narls
gonefs	10	43	987	3	g_onefs
goneness	9	3	1076	3	goneness
goners	7	44	2017	3	g_oners
gooneys	11	40	707	3	gooneys
gospels	10	3	559	3	gospels
grapnels	11	3	439	3	grapnels
gravels	11	36	1114	3	gravels
grinners	9	28	804	3	grinners
grovels	11	42	781	3	grovels
gruels	7	39	1015	3	g_ruels
grungers	10	29	850	3	grungers
grunges	9	33	1040	3	grunge_s
grunters	9	35	903	3	grunters
gruntles	9	28	723	3	gruntles
guanays	11	3	495	3	guanays
guanines	9	8	977	3	guanine_s
guanins	8	8	1001	3	guanins
guanos	7	38	1199	3	guan_os
guans	6	44	1944	3	guan__s
gudes	7	45	2081	3	gu_de_s
guenons	8	3	656	3	guenons
guess	6	42	1336	3	gu__ess
guggles	10	34	1054	3	guggles
guglets	9	36	969	3	guglets
guiders	9	41	1111	3	guiders
guides	8	41	1828	3	guide_s
guiles	7	39	1928	3	guile_s
guinea	7	3	761	3	guine_a
guises	7	42	1631	3	guise_s
guldens	9	35	657	3	guldens
gules	6	48	3104	3	gu_le_s
gullets	8	40	1371	3	gullets
gulleys	11	43	852	3	gulleys
gulls	6	52	2298	3	gu__lls
gulpers	10	29	901	3	gulpers
guls	5	59	3085	3	gu___ls
gumless	10	22	827	3	gumless
gummers	12	37	1220	3	gummers
gundogs	10	3	460	3	gundogs
gunites	8	3	1312	3	gunites
gunks	10	45	1772	3	gu_n_ks
gunmen	9	34	872	3	gunme_n
gunmetals	12	4	290	3	gunmetals
gunneries	10	4	704	3	gunneries
gunning	9	34	1317	3	gunning
gunnings	10	34	673	3	gunnings
gunny	9	44	1366	3	gunn__y
guns	5	55	3348	3	gu_n__s
gunwale	11	3	473	3	gunwale
gunwales	12	4	473	3	gunwales
gurges	8	47	1686	3	gurge_s
gurgles	9	43	1287	3	gurgles
gurnet	7	49	2087	3	gurne_t
gurney	10	42	941	3	gurne_y
gushers	11	35	1251	3	gushers
gushes	10	47	1903	3	gushe_s
gussets	8	3	744	3	gussets
gutless	8	26	1071	3	gutless
gutters	8	37	1551	3	gutters
guttles	8	30	1193	3	guttles
guzzles	16	32	804	3	guzzles
hansels	10	40	1166	3	hansels
hungers	11	40	1330	3	hungers
hunkers	14	33	1433	3	hunkers
hunkeys	17	38	619	3	hunkeys
hunters	10	39	1573	3	hunters
inners	6	39	1935	3	_inners
jennets	14	51	763	3	jennets
jungles	15	41	1254	3	jungles
junkers	18	40	1086	3	junkers
junkets	18	37	762	3	junkets
jurels	13	37	1058	3	ju_rels
kennel	10	36	922	3	kennel_
kernels	11	41	795	3	kernels
kneels	10	40	893	3	_kneels
kugels	11	4	607	3	ku_gels
kummels	15	23	479	3	kummels
lanners	7	36	1833	3	lanners
linnets	7	3	983	3	linnets
lintels	7	33	1116	3	lintels
lunes	5	53	3777	3	lu_ne_s
lunets	6	69	1476	3	lu_nets
lungees	8	44	1214	3	lungees
lungers	8	38	1709	3	lungers
lunges	7	61	2342	3	lunge_s
lunies	6	47	2301	3	lunie_s
lunkers	11	34	1460	3	lunkers
lunules	7	3	895	3	lunules
mangels	10	36	1449	3	mangels
manners	9	34	1783	3	manners
mantels	9	45	1504	3	mantels
mussels	9	41	984	3	mussels
mutuels	9	3	594	3	mutuels
noels	5	64	1870	3	__noels
nonnews	10	3	531	3	nonnews
nuncles	9	3	984	3	nuncles
nunnery	10	35	530	3	nunnery
ounces	8	36	1777	3	ounce_s
ousels	6	48	1528	3	ou_sels
ouzels	15	40	870	3	ou_zels
panels	8	47	1652	3	_panels
panners	9	36	2127	3	panners
pannes	8	55	2285	3	panne_s
pencels	11	36	1005	3	pencels
penners	9	34	1418	3	penners
pinners	9	35	1860	3	pinners
pummels	13	23	654	3	pummels
pungles	10	40	1371	3	pungles
puniness	10	16	1027	3	puniness
punkers	13	37	1485	3	punkers
punkeys	16	36	649	3	punkeys
punned	9	34	1619	3	punne_d
punner	8	49	1815	3	punne_r
punnet	8	35	1884	3	punne_t
punters	9	36	1704	3	punters
quinela	16	3	521	3	quinela
quinelas	17	4	493	3	quinelas
quinols	16	29	724	3	quinols
rennets	7	52	1263	3	rennets
rondels	8	25	1005	3	rondels
ronnel	6	33	1088	3	ronnel_
roundels	9	21	775	3	roundels
rubels	8	41	1299	3	ru_bels
ruiners	7	42	1302	3	ruiners
rundles	8	32	1471	3	rundles
runes	5	55	3022	3	ru_ne_s
runkles	11	41	1194	3	runkles
runless	7	28	1042	3	runless
runlets	7	33	1077	3	runlets
runner	6	38	1446	3	runne_r
scunners	10	35	730	3	scunners
sennets	7	37	1258	3	sennets
shunners	11	31	774	3	shunners
simnels	9	7	610	3	simnels
sinners	7	40	1902	3	sinners
sonnets	7	42	1199	3	sonnets
spinels	9	45	1244	3	spinels
stunners	8	27	792	3	stunners
subnets	9	25	1208	3	subnets
sunbelt	9	3	923	3	sunbelt
sunbelts	10	4	467	3	sunbelts
sunders	8	41	2005	3	sunders
sundews	11	39	815	3	sundews
sunkets	11	35	1128	3	sunkets
sunless	7	30	1369	3	sunless
sunnahs	10	32	659	3	sunnahs
sunnas	6	39	1456	3	sunn_as
sunned	7	42	1632	3	sunne_d
sunnily	10	3	783	3	sunnily
sunns	5	50	1735	3	sunn__s
sunsets	7	29	1157	3	sunsets
tanners	7	40	1839	3	tanners
tenners	7	40	1492	3	tenners
tinners	7	37	1731	3	tinners
tinsels	7	3	837	3	tinsels
tonners	7	38	1640	3	tonners
tonnes	6	53	2085	3	tonne_s
trunnel	7	4	540	3	trunnel_
tuners	6	44	1734	3	tu_ners
tunes	5	53	3219	3	tu_ne_s
tunned	7	40	1449	3	tunne_d
tunneled	9	5	523	3	tunneled
tunneler	8	6	447	3	tunneler
tunnelers	9	5	346	3	tunnelers
tunnies	7	36	1426	3	tunnies
turners	7	39	1289	3	turners
umbels	10	45	1059	3	_umbels
unbelt	8	30	1569	3	_unbelt
unbelts	9	23	766	3	_unbelts
uncles	8	3	1716	3	_uncles
unfelt	9	24	1346	3	_unfelt
unhelm	11	3	686	3	_unhelm
unhelms	12	3	422	3	_unhelms
unless	6	24	1307	3	_unless
unmews	11	32	652	3	_unmews
unnails	7	3	822	3	_unnails
unpegs	9	25	623	3	_unpegs
unpens	8	25	1101	3	_unpens
unreels	7	25	831	3	_unreels
unseals	7	32	1258	3	_unseals
unsell	6	35	1254	3	_unsell
unsells	7	32	1077	3	_unsells
unsets	6	41	1616	3	_unsets
unsews	9	37	936	3	_unsews
unveils	10	4	575	3	_unveils
unwell	9	34	944	3	_unwell
usneas	6	3	833	3	_usneas
vanners	10	36	1284	3	vanners
wanness	10	26	1068	3	wanness
winners	10	43	1691	3	winners
wonners	10	43	1281	3	wonners
wurzels	19	3	408	3	wurzels

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	134027	0.393	454684.5
2	DLD Change Limit	134027	322	6.436	20824.6
3	Display Results	322	322	0.110	2927.3
	(SQL Overall)	178691	322	6.939	25751.7