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

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

306 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
fug	7	62	3451	(None)
bug	6	53	4074	1	bug
dug	5	81	3869	1	dug
fag	7	68	5236	1	fag
fig	7	62	4284	1	fig
fog	7	69	4556	1	fog
frug	8	65	1710	1	frug
fub	8	63	3739	1	fub
fud	7	63	3516	1	fud
fugs	8	57	3069	1	fugs
fugu	8	54	1986	1	fugu
fun	6	68	4114	1	fun
fur	6	66	3732	1	fur
hug	7	60	3736	1	hug
jug	11	55	2954	1	jug
lug	4	61	3806	1	lug
mug	6	58	3769	1	mug
pug	6	53	3718	1	pug
rug	4	60	3915	1	rug
tug	4	59	3740	1	tug
vug	7	61	2741	1	vug
ag	3	110	6746	2	_ag
auk	7	62	3414	2	auk
bag	6	70	5922	2	bag
beg	6	59	4413	2	beg
big	6	73	4573	2	big
bog	6	78	5241	2	bog
bub	7	63	4398	2	bub
bud	6	70	4128	2	bud
bugs	7	60	3591	2	bugs
bum	7	53	4269	2	bum
bun	5	63	4814	2	bun
bung	7	57	3063	2	bung
bur	5	57	4469	2	bur
burg	7	49	3036	2	burg
bus	5	69	5097	2	bus
but	5	59	6302	2	but
buy	8	64	3654	2	buy
chug	10	59	1411	2	chug
cig	6	70	3619	2	cig
cog	6	95	5290	2	cog
cub	7	69	4094	2	cub
cud	6	79	3746	2	cud
cue	5	75	4418	2	cue
cum	7	64	4016	2	cum
cup	7	67	3824	2	cup
cur	5	68	4198	2	cur
cut	5	79	5766	2	cut
dag	5	77	5301	2	dag
dig	5	75	4448	2	dig
dog	5	74	4975	2	dog
drug	6	57	1813	2	drug
dub	6	66	4220	2	dub
dud	5	67	3760	2	dud
due	4	52	4986	2	due
dugs	6	148	3228	2	dugs
duh	7	79	3038	2	duh
dui	4	64	3338	2	dui
dun	4	65	4558	2	dun
dung	6	63	2843	2	dung
duo	4	85	3614	2	duo
dup	6	76	3788	2	dup
egg	5	69	1867	2	egg
eng	4	67	2678	2	eng
erg	4	55	3107	2	erg
fa	5	101	4845	2	f_a
fab	8	74	5313	2	fab
fad	7	74	5242	2	fad
fags	8	69	3912	2	fags
fan	6	71	5886	2	fan
fang	8	54	3256	2	fang
far	6	77	6260	2	far
fas	6	82	6293	2	fas
fat	6	81	7808	2	fat
faugh	12	57	1296	2	faugh
faun	7	62	2662	2	faun
faux	14	65	1907	2	faux
fax	13	81	4331	2	fax
fay	9	74	5486	2	fay
fe	5	79	4474	2	f_e
fed	7	65	4836	2	fed
fee	6	68	6201	2	fee
feh	9	61	3609	2	feh
fem	8	60	4073	2	fem
fen	6	68	5135	2	fen
fer	6	66	4612	2	fer
fes	6	65	5167	2	fes
fet	6	64	7163	2	fet
feu	6	78	4366	2	feu
feud	8	65	2302	2	feud
feus	7	58	3075	2	feus
few	9	54	3696	2	few
fey	9	59	4088	2	fey
fez	15	62	3682	2	fez
fib	8	63	4428	2	fib
fid	7	68	4770	2	fid
fie	6	71	5245	2	fie
figs	8	53	3265	2	figs
fil	6	54	4715	2	fil
fin	6	64	5804	2	fin
fir	6	67	4490	2	fir
fit	6	63	6546	2	fit
fix	13	62	3611	2	fix
fiz	15	62	3877	2	fiz
flag	8	74	2708	2	flag
flog	8	55	2389	2	flog
flu	6	65	3021	2	flu
flub	9	57	2188	2	flub
flue	7	53	2985	2	flue
flung	9	51	1458	2	flung
flus	7	56	2654	2	flus
flux	14	56	1774	2	flux
fly	9	71	2495	2	fly
fob	8	67	4833	2	fob
foe	6	63	5081	2	foe
fogs	8	70	3500	2	fogs
fogy	11	59	2318	2	fogy
foh	9	81	3589	2	foh
fon	6	63	5227	2	fon
fop	8	67	4370	2	fop
for	6	69	5207	2	for
fou	6	67	4378	2	fou
foul	7	70	2758	2	foul
four	7	62	2686	2	four
fox	13	67	3786	2	fox
foy	9	60	4426	2	foy
frag	8	51	2627	2	frag
frig	8	54	2450	2	frig
fro	6	55	3064	2	fro
frog	8	56	2436	2	frog
frugs	9	61	1428	2	frugs
fry	9	62	2650	2	fry
fubs	9	63	2879	2	fubs
fuci	9	57	2031	2	fuci
fuck	13	49	2463	2	fuck
fudge	10	53	1553	2	fudge
fuds	8	65	2857	2	fuds
fuel	7	68	2473	2	fuel
fugal	9	56	1303	2	fugal
fuggy	13	54	1167	2	fuggy
fugio	9	3	1092	2	fugio
fugle	9	49	1554	2	fugle
fugue	9	43	1337	2	fugue
fugus	9	59	1401	2	fugus
fuji	14	41	1200	2	fuji
full	7	52	2915	2	full
fume	9	67	2763	2	fume
fumy	12	71	1858	2	fumy
fund	8	56	2498	2	fund
fungi	9	50	1413	2	fungi
fungo	9	44	1313	2	fungo
funk	11	58	2562	2	funk
funs	7	52	3573	2	funs
furl	7	70	3088	2	furl
furs	7	67	3504	2	furs
fury	10	77	2797	2	fury
fuse	7	64	2999	2	fuse
fuss	7	60	2793	2	fuss
futz	16	78	2380	2	futz
fuze	16	64	2237	2	fuze
fuzz	15	84	2057	2	fuzz
gag	5	77	5363	2	gag
gig	5	60	4076	2	gig
glug	6	61	1801	2	glug
gul	4	58	3279	2	gul
gum	6	74	3953	2	gum
gun	4	72	4080	2	gun
gut	4	67	5385	2	gut
guv	7	45	2317	2	guv
guy	7	57	2894	2	guy
hag	7	72	5574	2	hag
hog	7	80	4906	2	hog
hub	8	64	3748	2	hub
hue	6	66	4230	2	hue
huge	8	63	2165	2	huge
hugs	8	61	2975	2	hugs
huh	9	64	3201	2	huh
hum	8	55	4293	2	hum
hun	6	58	4471	2	hun
hung	8	61	2635	2	hung
hup	8	64	3781	2	hup
hut	6	64	5729	2	hut
igg	5	71	1680	2	igg
jag	11	65	4271	2	jag
jig	11	56	3352	2	jig
jog	11	74	3831	2	jog
juga	12	64	1732	2	juga
jugs	12	55	2560	2	jugs
jun	10	59	3206	2	jun
jus	10	69	3022	2	jus
jut	10	59	4401	2	jut
keg	8	64	3255	2	keg
kue	7	66	3187	2	kue
lag	4	78	6212	2	lag
leg	4	64	4611	2	leg
log	4	62	5268	2	log
luge	5	55	3164	2	luge
lugs	5	52	3352	2	lugs
lum	5	55	4293	2	lum
lung	5	57	3249	2	lung
luv	6	71	2577	2	luv
lux	10	65	2877	2	lux
mag	6	79	5648	2	mag
meg	6	60	4095	2	meg
mig	6	56	4609	2	mig
mog	6	69	4967	2	mog
mu	4	67	3748	2	mu_
mud	6	73	3687	2	mud
mugg	8	63	1601	2	mugg
mugs	7	62	3204	2	mugs
mum	7	66	4361	2	mum
mun	5	61	4386	2	mun
mus	5	59	4675	2	mus
mut	5	83	5718	2	mut
nag	4	64	5081	2	nag
neg	4	72	3734	2	neg
nog	4	68	4731	2	nog
nu	2	63	3195	2	nu_
nub	5	64	3914	2	nub
nun	3	55	3774	2	nun
nus	3	79	3939	2	nus
nut	3	66	5196	2	nut
oud	4	74	3908	2	oud
our	3	60	4289	2	our
out	3	80	7215	2	out
peg	6	58	4306	2	peg
pfui	9	34	979	2	pfui
pig	6	57	4498	2	pig
plug	7	49	1599	2	plug
pub	7	60	3769	2	pub
pud	6	58	3666	2	pud
pugh	10	66	1923	2	pugh
pugs	7	63	3277	2	pugs
pul	5	61	3806	2	pul
pun	5	88	4651	2	pun
pung	7	54	2963	2	pung
pup	7	63	3988	2	pup
pur	5	68	4055	2	pur
pus	5	55	4784	2	pus
put	5	57	5907	2	put
qua	12	48	2197	2	qua
quag	14	48	1594	2	quag
rag	4	57	6132	2	rag
reg	4	61	4649	2	reg
rig	4	67	4813	2	rig
rub	5	63	4282	2	rub
rue	3	55	4926	2	rue
ruga	5	61	2123	2	ruga
rugs	5	60	3368	2	rugs
rum	5	66	4464	2	rum
run	3	62	4499	2	run
rung	5	64	2998	2	rung
rut	3	55	6052	2	rut
sag	4	61	6340	2	sag
seg	4	55	4488	2	seg
slug	5	51	2464	2	slug
smug	7	58	1526	2	smug
snug	5	52	1869	2	snug
sub	5	54	4555	2	sub
sue	3	56	5146	2	sue
sugh	8	64	2344	2	sugh
suk	7	56	3297	2	suk
sum	5	63	4601	2	sum
sun	3	71	4903	2	sun
sung	5	58	3217	2	sung
sup	5	70	4194	2	sup
suq	12	62	2899	2	suq
tag	4	72	5950	2	tag
teg	4	57	4162	2	teg
thug	8	64	1548	2	thug
tog	4	102	5504	2	tog
trug	5	57	2004	2	trug
tub	5	56	4003	2	tub
tugs	5	62	3167	2	tugs
tui	3	70	3402	2	tui
tun	3	58	4519	2	tun
tung	5	53	2817	2	tung
tup	5	60	3754	2	tup
tut	3	67	5809	2	tut
tux	10	54	2657	2	tux
ugh	7	65	2068	2	_ugh
uh	5	74	2985	2	_uh
um	4	73	3883	2	_um
un	2	83	4114	2	_un
up	4	78	3282	2	_up
us	2	69	3743	2	_us
ut	2	86	4703	2	_ut
veg	7	69	3106	2	veg
vig	7	56	3753	2	vig
vugg	9	56	1271	2	vugg
vugh	11	71	1572	2	vugh
vugs	8	70	2287	2	vugs
vum	8	54	2865	2	vum
wag	7	64	5175	2	wag
wig	7	67	4039	2	wig
wog	7	62	4273	2	wog
wud	7	62	2716	2	wud
xu	9	60	1883	2	xu_
yag	7	69	4773	2	yag
yuga	8	56	1542	2	yuga
yuk	10	67	2560	2	yuk
yum	8	61	3282	2	yum
yup	8	60	3170	2	yup
zag	13	75	3947	2	zag
zig	13	69	3191	2	zig
zuz	11	106	2203	2	zuz

Search took 1 second 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	14084	0.250	714764.0
2	DLD Change Limit	14084	306	0.390	36112.8
3	Display Results	306	306	0.063	4857.1
	(SQL Overall)	178691	306	0.703	254183.5