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

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

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

386 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
guns	5	55	3348	(None)
buns	6	62	4372	1	buns
duns	5	51	4043	1	duns
funs	7	52	3573	1	funs
gens	5	57	4007	1	gens
gins	5	55	4395	1	gins
gnus	5	65	1800	1	gnus
guans	6	44	1944	1	guans
guls	5	59	3085	1	guls
gums	7	50	3094	1	gums
gun	4	72	4080	1	gun_
gunk	9	54	2357	1	gunk
gunks	10	45	1772	1	gunks
guts	5	66	3725	1	guts
guvs	8	58	1681	1	guvs
guys	8	50	1964	1	guys
huns	7	61	3693	1	huns
muns	6	55	3592	1	muns
nuns	4	52	2823	1	nuns
puns	6	66	4148	1	puns
runs	4	64	3808	1	runs
suns	4	58	4190	1	suns
tuns	4	51	3866	1	tuns
uns	3	59	3676	1	_uns
agons	6	64	2378	2	agons
agues	6	49	1905	2	agues
ains	4	61	5888	2	ains
anus	4	71	3111	2	anus
auks	8	55	2526	2	auks
aunt	4	65	5365	2	aunt
aunts	5	52	2763	2	aunts
awns	7	53	2443	2	awns
bans	6	65	5514	2	bans
bens	6	59	4570	2	bens
bins	6	65	4825	2	bins
bubs	8	62	3550	2	bubs
buds	7	52	3517	2	buds
bugs	7	60	3591	2	bugs
bums	8	59	3459	2	bums
bun	5	63	4814	2	bun_
buna	6	47	3072	2	buna
bunas	7	51	2657	2	bunas
bund	7	55	3066	2	bund
bunds	8	55	2354	2	bunds
bung	7	57	3063	2	bung
bungs	8	53	2386	2	bungs
bunk	10	57	3135	2	bunk
bunks	11	51	2508	2	bunks
bunn	6	50	2365	2	bunn
bunns	7	47	1829	2	bunns
bunt	6	58	5085	2	bunt
bunts	7	57	2980	2	bunts
burns	7	49	2678	2	burns
burs	6	58	4742	2	burs
bus	5	69	5097	2	bu_s
buss	6	51	3491	2	buss
buts	6	72	4769	2	buts
buys	9	57	2679	2	buys
cans	6	50	5085	2	cans
cons	6	60	5769	2	cons
cubs	8	58	3238	2	cubs
cuds	7	67	3047	2	cuds
cues	6	54	3898	2	cues
cunt	6	62	4367	2	cunt
cunts	7	61	2512	2	cunts
cups	8	54	3082	2	cups
curns	7	49	2428	2	curns
curs	6	56	4554	2	curs
cuss	6	54	3061	2	cuss
cuts	6	58	4115	2	cuts
dans	5	67	4815	2	dans
dens	5	59	4507	2	dens
dins	5	66	5204	2	dins
dons	5	60	4870	2	dons
dubs	7	84	3219	2	dubs
duds	6	55	3014	2	duds
dues	5	60	4550	2	dues
dugs	6	148	3228	2	dugs
dun	4	65	4558	2	dun_
dune	5	61	3758	2	dune
dunes	6	53	3217	2	dunes
dung	6	63	2843	2	dung
dungs	7	58	2197	2	dungs
dunk	9	62	2857	2	dunk
dunks	10	56	2119	2	dunks
dunt	5	57	4687	2	dunt
dunts	6	58	2841	2	dunts
duos	5	67	2813	2	duos
dups	7	59	2951	2	dups
durns	6	48	1987	2	durns
ens	3	72	4592	2	_ens
eons	4	66	3871	2	eons
erns	4	54	2823	2	erns
fans	7	62	4737	2	fans
fauns	8	45	1675	2	fauns
fens	7	61	3976	2	fens
fins	7	58	4909	2	fins
fons	7	69	4389	2	fons
fubs	9	63	2879	2	fubs
fuds	8	65	2856	2	fuds
fugs	8	57	3069	2	fugs
fun	6	68	4114	2	fun_
fund	8	56	2498	2	fund
funds	9	41	1925	2	funds
funk	11	58	2562	2	funk
funks	12	53	1891	2	funks
furs	7	67	3504	2	furs
fuss	7	60	2793	2	fuss
gabs	7	67	4042	2	gabs
gads	6	78	4338	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gains	6	57	2951	2	gains
gals	5	79	4650	2	gals
gams	7	66	4888	2	gams
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gang	6	60	3197	2	gang
gangs	7	62	2257	2	gangs
gaps	7	60	4297	2	gaps
gars	5	57	5074	2	gars
gas	4	88	7025	2	g_as
gats	5	67	5344	2	gats
gauds	7	57	1772	2	gauds
gaums	8	62	1707	2	gaums
gaun	5	64	2771	2	gaun_
gaunt	6	54	3040	2	gaunt
gaurs	6	63	1799	2	gaurs
gauss	6	56	1345	2	gauss
gays	8	73	3802	2	gays
geds	6	67	3081	2	geds
gees	5	56	4788	2	gees
gels	5	68	3610	2	gels
gems	7	53	2911	2	gems
gen	4	59	5051	2	gen_
gene	5	62	3722	2	gene
genes	6	51	3309	2	genes
gent	5	69	5439	2	gent
gents	6	57	2961	2	gents
genu	5	59	2907	2	genu
genus	6	53	1983	2	genus
gets	5	54	4248	2	gets
geums	8	54	1411	2	geums
ghis	8	50	2016	2	ghis
gibs	7	55	2927	2	gibs
gids	6	59	3374	2	gids
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gin	4	60	5575	2	gin_
gink	9	71	2952	2	gink
ginks	10	43	1956	2	ginks
gips	7	56	3292	2	gips
girns	6	45	1680	2	girns
gits	5	57	4459	2	gits
glans	6	51	2583	2	glans
glens	6	65	1985	2	glens
glues	6	51	2568	2	glues
glugs	7	52	1428	2	glugs
glums	8	46	2142	2	glums
gluons	7	3	850	2	gluons
gluts	6	61	2013	2	gluts
gnu	4	55	2204	2	g_nu
goas	5	52	3994	2	goas
gobs	7	69	3557	2	gobs
gods	6	54	3804	2	gods
goes	5	56	4409	2	goes
gone	5	56	3904	2	gone
gong	6	68	2719	2	gong
gongs	7	49	2161	2	gongs
goons	6	53	2677	2	goons
goos	5	76	4491	2	goos
gos	4	71	5513	2	g_os
gouts	6	48	2617	2	gouts
gowns	9	51	1510	2	gowns
goys	8	63	2841	2	goys
grans	6	48	3254	2	grans
grins	6	54	2722	2	grins
grubs	8	63	1260	2	grubs
grues	6	57	2196	2	grues
grunt	6	55	2354	2	grunt
grunts	7	55	1185	2	grunts
guan	5	53	2558	2	guan
guano	6	92	1398	2	guano
guanos	7	38	1199	2	guanos
guar	5	69	2329	2	guar
guars	6	50	2105	2	guars
guck	11	49	2253	2	guck
gucks	12	39	1730	2	gucks
gude	6	54	2333	2	gude
gudes	7	45	2081	2	gudes
guess	6	42	1336	2	guess
guest	6	52	2592	2	guest
guff	11	46	2493	2	guff
guffs	12	44	1482	2	guffs
guid	6	60	2282	2	guid
guids	7	55	1615	2	guids
guise	6	47	1771	2	guise
gul	4	58	3279	2	gu_l
gules	6	48	3104	2	gules
gulf	8	49	2942	2	gulf
gulfs	9	49	1530	2	gulfs
gull	5	48	2845	2	gull
gulls	6	52	2298	2	gulls
gulp	7	55	2136	2	gulp
gulps	8	47	1507	2	gulps
gum	6	74	3953	2	gu_m
gunky	13	55	1411	2	gunky
gunny	9	44	1366	2	gunny
gunsel	7	33	985	2	gunsel
gursh	9	45	1233	2	gursh
guru	5	46	2391	2	guru
gurus	6	43	1819	2	gurus
gush	8	54	2400	2	gush
gussy	9	53	1432	2	gussy
gust	5	52	4070	2	gust
gusts	6	57	2279	2	gusts
gut	4	67	5385	2	gu_t
gutsy	9	64	1284	2	gutsy
guv	7	45	2317	2	gu_v
guy	7	57	2894	2	gu_y
gyms	10	75	1459	2	gyms
gyps	10	51	1502	2	gyps
hens	7	56	4257	2	hens
hins	7	64	4799	2	hins
hons	7	73	5078	2	hons
hubs	9	60	2714	2	hubs
hues	7	52	3523	2	hues
hugs	8	61	2975	2	hugs
hums	9	68	3142	2	hums
hun	6	58	4471	2	hun_
hung	8	61	2635	2	hung
hunh	10	63	2373	2	hunh
hunk	11	60	2954	2	hunk
hunks	12	53	2145	2	hunks
hunt	7	64	4549	2	hunt
hunts	8	68	2617	2	hunts
huts	7	67	3744	2	huts
inns	4	69	2093	2	inns
ins	3	59	4560	2	_ins
ions	4	67	3785	2	ions
jins	11	56	3501	2	jins
jugs	12	55	2560	2	jugs
jun	10	59	3206	2	jun_
junk	15	51	2103	2	junk
junks	16	48	1597	2	junks
jus	10	69	3022	2	ju_s
juts	11	59	3016	2	juts
kens	8	54	3523	2	kens
kins	8	57	4791	2	kins
kues	8	64	2677	2	kues
kuna	8	51	2070	2	kuna
kune	8	54	2457	2	kune
lens	4	61	4649	2	lens
lins	4	70	5905	2	lins
lues	4	59	4355	2	lues
lugs	5	52	3352	2	lugs
lums	6	57	3424	2	lums
luna	4	62	2985	2	luna
lunas	5	50	2501	2	lunas
lune	4	71	4049	2	lune
lunes	5	53	3777	2	lunes
lung	5	57	3249	2	lung
lungs	6	52	2388	2	lungs
lunk	8	60	3072	2	lunk
lunks	9	48	2245	2	lunks
lunt	4	61	4884	2	lunt
lunts	5	58	2690	2	lunts
luny	7	73	2413	2	luny
luvs	7	58	1850	2	luvs
mans	6	63	5455	2	mans
mons	6	81	5226	2	mons
muds	7	55	3065	2	muds
mugs	7	62	3204	2	mugs
mums	8	57	3277	2	mums
mun	5	61	4386	2	mun_
muni	6	58	2441	2	muni
munis	7	50	2200	2	munis
muons	7	58	1617	2	muons
mus	5	59	4675	2	mu_s
muss	6	49	3376	2	muss
muts	6	48	3998	2	muts
nans	4	61	3940	2	nans
nouns	5	67	1731	2	nouns
nubs	6	59	2714	2	nubs
nun	3	55	3774	2	nun_
nus	3	79	3939	2	nu_s
nuts	4	50	3267	2	nuts
ons	3	61	4851	2	_ons
onus	4	58	2681	2	onus
ouds	5	64	3010	2	ouds
ours	4	72	3756	2	ours
outs	4	57	4696	2	outs
owns	7	68	1958	2	owns
pans	6	58	5573	2	pans
pens	6	56	4964	2	pens
pins	6	55	5845	2	pins
pons	6	58	5060	2	pons
pubs	8	50	2921	2	pubs
puds	7	56	3051	2	puds
pugs	7	63	3277	2	pugs
puls	6	54	3756	2	puls
pun	5	88	4651	2	pun_
puna	6	53	3165	2	puna
punas	7	48	2675	2	punas
pung	7	54	2963	2	pung
pungs	8	54	2222	2	pungs
punk	10	57	2997	2	punk
punks	11	48	2268	2	punks
punt	6	57	4720	2	punt
punts	7	58	2800	2	punts
puny	9	55	2699	2	puny
pups	8	60	3223	2	pups
purs	6	56	4104	2	purs
pus	5	55	4784	2	pu_s
puss	6	48	3013	2	puss
puts	6	56	4175	2	puts
quins	14	48	1985	2	quins
rins	4	61	5319	2	rins
rubs	6	61	3349	2	rubs
rues	4	60	4448	2	rues
rugs	5	60	3368	2	rugs
ruins	5	58	2203	2	ruins
rums	6	48	3347	2	rums
run	3	62	4499	2	run_
rune	4	52	3630	2	rune
runes	5	55	3022	2	runes
rung	5	64	2998	2	rung
rungs	6	118	1940	2	rungs
runt	4	66	4799	2	runt
runts	5	59	2763	2	runts
ruts	4	45	4149	2	ruts
sans	4	51	5336	2	sans
shuns	8	50	1814	2	shuns
sins	4	67	5527	2	sins
sons	4	60	4955	2	sons
stuns	5	47	1949	2	stuns
subs	6	60	3712	2	subs
suds	5	61	3529	2	suds
sues	4	62	4765	2	sues
suks	8	59	2712	2	suks
sums	6	58	3758	2	sums
sun	3	71	4903	2	sun_
sung	5	58	3217	2	sung
sunk	8	50	3181	2	sunk
sunn	4	54	2359	2	sunn
sunns	5	50	1735	2	sunns
sups	6	48	3443	2	sups
suqs	13	43	1965	2	suqs
suss	4	52	2930	2	suss
tans	4	61	5482	2	tans
tens	4	56	4741	2	tens
tins	4	52	5130	2	tins
tons	4	65	5305	2	tons
tubs	6	54	3006	2	tubs
tugs	5	62	3167	2	tugs
tuis	4	48	2964	2	tuis
tun	3	58	4519	2	tun_
tuna	4	51	2784	2	tuna
tunas	5	42	2412	2	tunas
tune	4	56	3586	2	tune
tunes	5	53	3219	2	tunes
tung	5	53	2816	2	tung
tungs	6	55	2062	2	tungs
tups	6	56	2876	2	tups
turns	5	56	2324	2	turns
tuts	4	58	3845	2	tuts
ughs	8	54	1097	2	ughs
un	2	83	4114	2	_un_
ups	5	56	2905	2	_ups
urns	4	63	2390	2	urns
us	2	69	3743	2	_u_s
uts	3	55	3437	2	_uts
vans	7	62	3673	2	vans
vugs	8	70	2287	2	vugs
wans	7	64	5227	2	wans
wens	7	63	3793	2	wens
wins	7	59	4917	2	wins
wons	7	49	4204	2	wons
wuss	7	52	1933	2	wuss
wyns	10	57	1703	2	wyns
yens	7	58	3226	2	yens
yins	7	53	3512	2	yins
yuans	8	46	1332	2	yuans
yuks	11	64	1802	2	yuks
yups	9	61	2160	2	yups
zins	13	57	3500	2	zins

Search took 3 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	29872	0.563	317390.8
2	DLD Change Limit	29872	386	1.700	17571.8
3	Display Results	386	386	0.190	2031.6
	(SQL Overall)	178691	386	2.453	72845.9