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

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

460 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
fags	8	69	3912	(None)
ags	4	75	5166	1	_ags
bags	7	66	4550	1	bags
dags	6	66	4259	1	dags
fabs	9	86	3586	1	fabs
fads	8	69	3987	1	fads
fag	7	68	5236	1	fag_
fangs	9	62	2407	1	fangs
fans	7	62	4736	1	fans
fas	6	82	6293	1	fa_s
fats	7	62	5250	1	fats
fays	10	85	3536	1	fays
figs	8	53	3264	1	figs
flags	9	53	2128	1	flags
fogs	8	70	3500	1	fogs
frags	9	63	2216	1	frags
fugs	8	57	3069	1	fugs
gags	6	64	4106	1	gags
hags	8	67	4084	1	hags
jags	12	61	3279	1	jags
lags	5	65	4622	1	lags
mags	7	54	4452	1	mags
nags	5	54	3602	1	nags
rags	5	54	4837	1	rags
sags	5	59	4840	1	sags
tags	5	55	4523	1	tags
wags	8	61	4055	1	wags
yags	8	66	3229	1	yags
zags	14	68	2668	1	zags
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	_aas
abs	5	93	5607	2	_abs
ads	4	97	5573	2	_ads
afars	8	57	1651	2	afars
ag	3	110	6746	2	_ag_
aga	4	104	4723	2	_aga
agas	5	59	3884	2	_agas
age	4	71	5433	2	_age
ages	5	58	4459	2	_ages
ago	4	88	4552	2	_ago
ahs	6	86	4482	2	_ahs
ais	3	90	8357	2	_ais
als	3	66	6302	2	_als
ars	3	76	7093	2	_ars
as	2	110	8307	2	_a_s
ass	3	78	4406	2	_ass
ays	6	70	5029	2	_ays
baas	6	68	4467	2	baas
bads	7	70	4886	2	bads
bag	6	70	5922	2	bag_
bals	6	63	5404	2	bals
bams	8	70	4445	2	bams
bangs	8	56	2777	2	bangs
bans	6	65	5513	2	bans
baps	8	60	4084	2	baps
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bays	9	71	4391	2	bays
begs	7	57	3383	2	begs
bigs	7	62	3502	2	bigs
bogs	7	57	4275	2	bogs
brags	8	56	2510	2	brags
bugs	7	60	3591	2	bugs
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
cage	7	53	3906	2	cage
cages	8	59	3601	2	cages
cagy	10	63	2199	2	cagy
cams	8	70	4728	2	cams
cans	6	50	5084	2	cans
caps	8	71	4789	2	caps
cars	6	73	6476	2	cars
cats	6	63	5634	2	cats
caws	9	60	3610	2	caws
cays	9	54	3767	2	cays
cigs	7	56	2510	2	cigs
clags	8	56	2112	2	clags
cogs	7	73	4003	2	cogs
crags	8	56	2257	2	crags
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
dag	5	77	5300	2	dag_
dago	6	57	2508	2	dago
dagos	7	64	1944	2	dagos
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
dams	7	74	4437	2	dams
dangs	7	56	2320	2	dangs
dans	5	67	4814	2	dans
daps	7	72	3916	2	daps
daws	8	66	3824	2	daws
days	8	76	3713	2	days
digs	6	60	3605	2	digs
dogs	6	64	4015	2	dogs
drags	7	55	2111	2	drags
dugs	6	148	3228	2	dugs
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
eggs	6	65	1615	2	eggs
engs	5	61	2139	2	engs
ergs	5	55	2381	2	ergs
fa	5	101	4845	2	fa__
fab	8	74	5313	2	fa_b
face	9	61	4012	2	face
faces	10	64	3943	2	faces
fact	9	71	4254	2	fact
facts	10	70	2189	2	facts
fad	7	74	5241	2	fa_d
fade	8	57	3634	2	fade
fades	9	49	3286	2	fades
fadge	10	48	1699	2	fadge
fadges	11	48	1402	2	fadges
fado	8	72	2646	2	fado
fados	9	56	2073	2	fados
faggy	13	65	1437	2	faggy
fagin	9	2	1657	2	fagin
fagins	10	5	1386	2	fagins
fagot	9	3	2340	2	fagot
fagots	10	3	996	2	fagots
fail	7	48	4024	2	fail
fails	8	56	3148	2	fails
fain	7	58	4056	2	fain
fair	7	63	3252	2	fair
fairs	8	58	2544	2	fairs
fake	11	55	3494	2	fake
fakes	12	60	3248	2	fakes
fall	7	55	3531	2	fall
falls	8	57	2765	2	falls
false	8	48	1812	2	false
falx	14	71	2078	2	falx
fame	9	56	3939	2	fame
fames	10	57	3592	2	fames
fan	6	71	5885	2	fa_n
fane	7	53	4356	2	fane
fanes	8	46	3989	2	fanes
fang	8	54	3254	2	fang
fanga	9	61	1962	2	fanga
fangas	10	50	1719	2	fangas
fano	7	58	3168	2	fano
fanos	8	59	2650	2	fanos
far	6	77	6260	2	fa_r
fard	8	56	3906	2	fard
fards	9	66	2984	2	fards
fare	7	63	5446	2	fare
fares	8	58	5287	2	fares
farl	7	63	3855	2	farl
farls	8	57	3111	2	farls
farm	9	59	3453	2	farm
farms	10	63	2495	2	farms
faro	7	61	3692	2	faro
faros	8	55	3202	2	faros
fart	7	68	6056	2	fart
farts	8	83	3684	2	farts
fash	10	72	3229	2	fash
fast	7	70	5231	2	fast
fasts	8	64	2968	2	fasts
fat	6	81	7808	2	fa_t
fate	7	54	4428	2	fate
fates	8	51	3923	2	fates
fatso	8	51	1349	2	fatso
faugh	12	57	1296	2	faugh
faun	7	62	2662	2	faun
fauns	8	45	1675	2	fauns
faux	14	65	1907	2	faux
fava	10	68	2026	2	fava
favas	11	56	1859	2	favas
fave	10	55	3296	2	fave
faves	11	53	3142	2	faves
favus	11	43	1173	2	favus
fawn	10	53	2195	2	fawn
fawns	11	59	1426	2	fawns
fax	13	81	4331	2	fa_x
faxes	15	57	2665	2	faxes
fay	9	74	5486	2	fa_y
faze	16	56	3004	2	faze
fazes	17	55	2721	2	fazes
fears	8	48	2939	2	fears
feats	8	64	3275	2	feats
feds	8	52	3431	2	feds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fems	9	64	2870	2	fems
fens	7	61	3976	2	fens
fes	6	65	5167	2	f_es
fess	7	65	2916	2	fess
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
fiars	8	67	2083	2	fiars
fiats	8	53	2448	2	fiats
fibs	9	63	2950	2	fibs
fids	8	70	3473	2	fids
fig	7	62	4283	2	fig_
fils	7	58	3869	2	fils
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
flabs	10	58	1864	2	flabs
flag	8	74	2708	2	flag_
flams	10	51	2501	2	flams
flans	8	53	2797	2	flans
flaps	10	56	2138	2	flaps
flats	8	64	2974	2	flats
flaws	11	59	2034	2	flaws
flays	11	63	2105	2	flays
flogs	9	59	1996	2	flogs
flus	7	56	2654	2	flus
foals	8	57	2169	2	foals
foams	10	50	1795	2	foams
fobs	9	60	3427	2	fobs
foes	7	65	4344	2	foes
fog	7	69	4556	2	fog_
fogy	11	59	2318	2	fogy
fons	7	69	4389	2	fons
fops	9	65	3268	2	fops
foss	7	64	3164	2	foss
foys	10	56	2829	2	foys
frag	8	51	2627	2	frag_
fraps	10	56	2055	2	fraps
frass	8	53	2112	2	frass
frats	8	68	2967	2	frats
frays	11	69	2010	2	frays
frigs	9	60	1927	2	frigs
frogs	9	62	2077	2	frogs
frugs	9	61	1428	2	frugs
fubs	9	63	2879	2	fubs
fuds	8	65	2856	2	fuds
fug	7	62	3451	2	fug_
fugu	8	54	1986	2	fugu
fugus	9	59	1401	2	fugus
funs	7	52	3573	2	funs
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
gag	5	77	5363	2	gag_
gaga	6	66	2555	2	gaga
gage	6	59	3610	2	gage
gages	7	45	2997	2	gages
gals	5	79	4650	2	gals
gams	7	66	4888	2	gams
gangs	7	62	2257	2	gangs
gaps	7	60	4297	2	gaps
gars	5	57	5074	2	gars
gas	4	88	7025	2	ga_s
gats	5	67	5344	2	gats
gays	8	73	3802	2	gays
gigs	6	66	3118	2	gigs
haes	7	76	5102	2	haes
hag	7	72	5574	2	hag_
hahs	10	83	3336	2	hahs
hams	9	64	4613	2	hams
hangs	9	57	2672	2	hangs
haps	9	64	4346	2	haps
has	6	73	7265	2	ha_s
hats	7	68	5825	2	hats
haws	10	64	3944	2	haws
hays	10	61	3807	2	hays
hogs	8	71	3966	2	hogs
hugs	8	61	2975	2	hugs
iggs	6	66	1267	2	iggs
jabs	13	58	3009	2	jabs
jag	11	65	4271	2	jag_
jagg	13	61	1531	2	jagg
jaggs	14	81	1149	2	jaggs
jams	13	52	3107	2	jams
jars	11	73	3835	2	jars
jaws	14	50	2729	2	jaws
jays	14	63	2834	2	jays
jigs	12	65	2476	2	jigs
jogs	12	71	2933	2	jogs
jugs	12	55	2560	2	jugs
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kagu	9	54	1811	2	kagu
kagus	10	58	1203	2	kagus
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
kegs	9	58	2401	2	kegs
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lag	4	78	6212	2	lag_
lams	6	65	5226	2	lams
laps	6	68	4887	2	laps
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lavs	7	67	3415	2	lavs
laws	7	64	4168	2	laws
lays	7	60	4325	2	lays
legs	5	61	3369	2	legs
logs	5	73	4311	2	logs
lugs	5	52	3352	2	lugs
macs	8	67	4250	2	macs
mads	7	68	4536	2	mads
maes	6	69	4839	2	maes
mag	6	79	5647	2	mag_
mage	7	57	3912	2	mage
mages	8	50	3602	2	mages
magi	7	63	2952	2	magi
magus	8	53	1875	2	magus
mans	6	63	5453	2	mans
maps	8	61	4104	2	maps
mars	6	62	6186	2	mars
mas	5	81	7581	2	ma_s
mass	6	60	4493	2	mass
mats	6	54	6028	2	mats
maws	9	64	3713	2	maws
mays	9	69	4002	2	mays
megs	7	55	3063	2	megs
migs	7	69	3532	2	migs
mogs	7	54	3933	2	mogs
mugs	7	62	3204	2	mugs
nabs	6	62	3619	2	nabs
nag	4	64	5081	2	nag_
nans	4	61	3939	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nays	7	59	3159	2	nays
negs	5	57	2736	2	negs
nogs	5	65	3461	2	nogs
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
ofays	11	48	892	2	ofays
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
page	7	60	3610	2	page
pages	8	52	3507	2	pages
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pangs	8	46	2866	2	pangs
pans	6	58	5572	2	pans
paps	8	64	4345	2	paps
pars	6	75	6079	2	pars
pas	5	87	7574	2	pa_s
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
peags	8	61	2284	2	peags
pegs	7	55	3176	2	pegs
pigs	7	66	3422	2	pigs
pugs	7	63	3277	2	pugs
qats	13	53	3134	2	qats
quags	15	46	1325	2	quags
rads	5	60	4660	2	rads
rag	4	57	6132	2	rag_
raga	5	59	3081	2	raga
ragas	6	53	2606	2	ragas
rage	5	57	4235	2	rage
rages	6	45	3944	2	rages
ragg	6	56	2269	2	ragg
raggs	7	52	1647	2	raggs
ragi	5	60	3228	2	ragi
ragis	6	63	2560	2	ragis
rais	4	52	5262	2	rais
rams	6	59	5077	2	rams
raps	6	62	4773	2	raps
ras	3	75	7539	2	ra_s
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
regs	5	54	3657	2	regs
rigs	5	51	3759	2	rigs
rugs	5	60	3368	2	rugs
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
sag	4	61	6340	2	sag_
saga	5	53	3117	2	saga
sagas	6	60	2588	2	sagas
sage	5	50	4459	2	sage
sages	6	53	3906	2	sages
sago	5	63	3267	2	sago
sagos	6	61	2387	2	sagos
sagy	8	53	2708	2	sagy
sals	4	68	5167	2	sals
sans	4	51	5335	2	sans
saps	6	53	4637	2	saps
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
says	7	59	4210	2	says
scags	8	55	2097	2	scags
segs	5	49	3388	2	segs
shags	9	51	2386	2	shags
skags	10	43	1607	2	skags
slags	6	65	2590	2	slags
snags	6	44	2131	2	snags
stags	6	62	2674	2	stags
swags	9	49	2125	2	swags
tabs	6	68	4298	2	tabs
tads	5	71	4394	2	tads
tag	4	72	5949	2	tag_
tams	6	72	4793	2	tams
tangs	6	50	2834	2	tangs
tans	4	61	5481	2	tans
taos	4	55	4100	2	taos
taps	6	60	5067	2	taps
tars	4	67	6395	2	tars
tas	3	84	7710	2	ta_s
tass	4	56	4057	2	tass
tats	4	68	5813	2	tats
taus	4	63	4273	2	taus
tavs	7	56	3097	2	tavs
taws	7	56	4159	2	taws
tegs	5	60	3149	2	tegs
togs	5	72	4243	2	togs
tugs	5	62	3167	2	tugs
vacs	9	62	2620	2	vacs
vagi	8	67	1936	2	vagi
vagus	9	67	1381	2	vagus
vangs	9	63	1958	2	vangs
vans	7	62	3672	2	vans
vars	7	57	4207	2	vars
vas	6	77	5577	2	va_s
vats	7	68	4174	2	vats
vaus	7	59	2892	2	vaus
vavs	10	57	2043	2	vavs
vaws	10	55	2732	2	vaws
vigs	8	54	2727	2	vigs
vugs	8	70	2287	2	vugs
wabs	9	73	3723	2	wabs
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
wag	7	64	5175	2	wag_
wage	8	48	3408	2	wage
wages	9	53	3093	2	wages
wans	7	64	5226	2	wans
waps	9	66	4208	2	waps
wars	7	86	5980	2	wars
was	6	87	6756	2	wa_s
wats	7	75	5588	2	wats
waws	10	68	3490	2	waws
ways	10	77	3795	2	ways
wigs	8	49	3125	2	wigs
wogs	8	65	3140	2	wogs
yag	7	69	4773	2	yag_
yagi	8	69	2224	2	yagi
yagis	9	54	1657	2	yagis
yaks	11	60	2520	2	yaks
yams	9	53	3073	2	yams
yangs	9	56	1869	2	yangs
yaps	9	59	3352	2	yaps
yaws	10	55	3121	2	yaws
yays	10	57	2891	2	yays
zag	13	75	3947	2	zag_
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	za_s
zigs	14	54	2279	2	zigs

Search took 2 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.080	2233637.5
2	DLD Change Limit	29872	460	0.860	34734.9
3	Display Results	460	460	0.106	4339.6
	(SQL Overall)	178691	460	1.046	170832.7