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

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

381 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
foss	7	64	3164	(None)
boss	6	59	3834	1	boss
coss	6	61	4349	1	coss
doss	5	62	3504	1	doss
fess	7	65	2916	1	fess
floss	8	51	1826	1	floss
fobs	9	60	3427	1	fobs
foes	7	65	4344	1	foes
fogs	8	70	3500	1	fogs
fons	7	69	4389	1	fons
fops	9	65	3268	1	fops
fossa	8	58	1263	1	fossa
fosse	8	61	1946	1	fosse
foys	10	56	2829	1	foys
fuss	7	60	2793	1	fuss
joss	11	59	2559	1	joss
koss	8	52	2481	1	koss
loss	4	53	3796	1	loss
moss	6	76	4103	1	moss
toss	4	56	3797	1	toss
ass	3	78	4406	2	_ass
bass	6	61	4678	2	bass
boas	6	61	5083	2	boas
bobs	8	63	4065	2	bobs
bods	7	62	4471	2	bods
bogs	7	57	4275	2	bogs
boos	6	79	5503	2	boos
bops	8	60	3798	2	bops
bos	5	79	6681	2	bo_s
bosh	9	63	2897	2	bosh
bosk	10	58	2573	2	bosk
bosks	11	52	1885	2	bosks
bossy	10	55	1597	2	bossy
bots	6	64	5395	2	bots
bows	9	62	4286	2	bows
boys	9	67	3733	2	boys
buss	6	51	3491	2	buss
cess	6	53	2605	2	cess
cobs	8	70	4314	2	cobs
cods	7	68	4810	2	cods
cogs	7	73	4003	2	cogs
cols	6	65	5308	2	cols
cons	6	60	5769	2	cons
coos	6	74	5649	2	coos
cops	8	67	5137	2	cops
cors	6	66	5644	2	cors
cos	5	102	7039	2	co_s
coses	7	69	4949	2	coses
cosh	9	61	2762	2	cosh
cost	6	80	5794	2	cost
costs	7	72	3114	2	costs
cosy	9	72	3270	2	cosy
cots	6	80	5484	2	cots
cows	9	70	4664	2	cows
coys	9	75	3724	2	coys
cross	7	51	2450	2	cross
cuss	6	54	3061	2	cuss
diss	5	64	3448	2	diss
docs	7	56	3115	2	docs
does	5	65	5447	2	does
dogs	6	64	4015	2	dogs
dols	5	69	4305	2	dols
doms	7	62	3957	2	doms
dons	5	60	4870	2	dons
dors	5	67	4760	2	dors
dos	4	80	6231	2	do_s
dose	5	64	4243	2	dose
doses	6	59	3850	2	doses
dost	5	72	4835	2	dost
dots	5	56	4766	2	dots
dows	8	59	4105	2	dows
dross	6	54	1809	2	dross
eons	4	66	3871	2	eons
ess	3	60	3088	2	_ess
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fans	7	62	4737	2	fans
fas	6	82	6293	2	f_as
fash	10	72	3229	2	fash
fast	7	70	5231	2	fast
fasts	8	64	2968	2	fasts
fats	7	62	5250	2	fats
fays	10	85	3536	2	fays
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
feods	9	95	1685	2	feods
fes	6	65	5167	2	f_es
fesse	8	61	1633	2	fesse
fest	7	49	4944	2	fest
fests	8	58	2804	2	fests
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
fibs	9	63	2950	2	fibs
fids	8	70	3473	2	fids
figs	8	53	3264	2	figs
fils	7	58	3869	2	fils
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fisc	9	68	1975	2	fisc
fiscs	10	53	1188	2	fiscs
fish	10	69	2627	2	fish
fist	7	62	4842	2	fist
fists	8	55	2754	2	fists
fits	7	60	4346	2	fits
flocs	10	55	1923	2	flocs
floes	8	55	2814	2	floes
flogs	9	59	1996	2	flogs
flops	10	59	2014	2	flops
flossy	12	51	770	2	flossy
flows	11	58	2236	2	flows
flus	7	56	2654	2	flus
foal	7	66	3092	2	foal
foals	8	57	2169	2	foals
foam	9	71	2717	2	foam
foams	10	50	1795	2	foams
fob	8	67	4833	2	fo_b
foci	9	45	2101	2	foci
focus	10	58	1588	2	focus
foe	6	63	5081	2	fo_e
fog	7	69	4556	2	fo_g
fogy	11	59	2318	2	fogy
foh	9	81	3589	2	fo_h
fohn	10	61	1655	2	fohn
fohns	11	73	1078	2	fohns
foil	7	64	3391	2	foil
foils	8	50	2581	2	foils
foin	7	72	3156	2	foin
foins	8	55	2338	2	foins
foist	8	57	3097	2	foist
foists	9	54	1398	2	foists
fold	8	65	2894	2	fold
folds	9	52	2169	2	folds
folk	11	60	2154	2	folk
folks	12	60	1712	2	folks
fon	6	63	5227	2	fo_n
fond	8	63	3095	2	fond
fonds	9	58	2482	2	fonds
font	7	71	4375	2	font
fonts	8	61	2475	2	fonts
food	8	68	3057	2	food
foods	9	59	2416	2	foods
fool	7	53	3059	2	fool
fools	8	68	2420	2	fools
foot	7	62	4801	2	foot
foots	8	55	2828	2	foots
fop	8	67	4370	2	fo_p
for	6	69	5207	2	fo_r
fora	7	59	3739	2	fora
forb	9	71	3133	2	forb
forbs	10	57	2080	2	forbs
ford	8	68	3549	2	ford
fords	9	53	2818	2	fords
fore	7	83	5147	2	fore
fores	8	58	4710	2	fores
fork	11	59	3094	2	fork
forks	12	53	2468	2	forks
form	9	58	3687	2	form
forms	10	53	2705	2	forms
fort	7	64	5644	2	fort
forts	8	60	3445	2	forts
fossae	9	55	1037	2	fossae
fossas	9	46	1070	2	fossas
fosses	9	60	2208	2	fosses
fossil	9	37	935	2	fossil
fou	6	67	4378	2	fo_u
foul	7	70	2758	2	foul
fouls	8	72	2143	2	fouls
four	7	62	2686	2	four
fours	8	55	2149	2	fours
fowl	10	57	2363	2	fowl
fowls	11	55	1889	2	fowls
fox	13	67	3786	2	fo_x
foxes	15	63	2109	2	foxes
foxy	17	65	1775	2	foxy
foy	9	60	4426	2	fo_y
fozy	19	70	1716	2	fozy
frass	8	53	2112	2	frass
froes	8	61	2669	2	froes
frogs	9	62	2077	2	frogs
frons	8	61	2404	2	frons
frosh	11	57	1340	2	frosh
frost	8	47	2783	2	frost
frosts	9	42	1462	2	frosts
frows	11	66	2310	2	frows
fubs	9	63	2879	2	fubs
fuds	8	65	2856	2	fuds
fugs	8	57	3069	2	fugs
funs	7	52	3573	2	funs
furs	7	67	3504	2	furs
fuse	7	64	2999	2	fuse
fuses	8	56	2842	2	fuses
fussy	11	56	1395	2	fussy
gloss	6	43	1962	2	gloss
goas	5	52	3994	2	goas
gobs	7	69	3557	2	gobs
gods	6	54	3804	2	gods
goes	5	56	4409	2	goes
goos	5	76	4491	2	goos
gos	4	71	5513	2	go_s
gosh	8	61	2342	2	gosh
goys	8	63	2841	2	goys
gross	6	54	2169	2	gross
hiss	7	56	2921	2	hiss
hobs	9	70	3898	2	hobs
hods	8	72	3986	2	hods
hoes	7	57	5573	2	hoes
hogs	8	71	3966	2	hogs
hols	7	69	4629	2	hols
hons	7	73	5078	2	hons
hops	9	79	4263	2	hops
hos	6	83	6419	2	ho_s
hose	7	65	4724	2	hose
hoses	8	54	4317	2	hoses
host	7	78	5283	2	host
hosts	8	55	2670	2	hosts
hots	7	83	4933	2	hots
hows	10	63	4560	2	hows
hoys	10	77	3393	2	hoys
ions	4	67	3785	2	ions
jess	11	60	2203	2	jess
jobs	13	65	2943	2	jobs
joes	11	66	3589	2	joes
jogs	12	71	2933	2	jogs
josh	14	51	1761	2	josh
jots	11	63	3614	2	jots
jows	14	66	3209	2	jows
joys	14	66	2466	2	joys
kiss	8	52	2739	2	kiss
koas	8	56	3509	2	koas
kobs	10	58	3108	2	kobs
kois	8	51	2940	2	kois
kops	10	70	3129	2	kops
kors	8	59	3301	2	kors
kos	7	69	4482	2	ko_s
lass	4	74	4454	2	lass
less	4	56	3510	2	less
lobs	6	64	4108	2	lobs
loess	5	57	1470	2	loess
logs	5	73	4311	2	logs
loos	4	90	5112	2	loos
lops	6	60	4335	2	lops
lose	4	51	4458	2	lose
loses	5	67	4201	2	loses
lossy	8	52	1464	2	lossy
lost	4	79	5149	2	lost
lots	4	76	5209	2	lots
lows	7	58	4301	2	lows
mass	6	60	4494	2	mass
mess	6	59	3243	2	mess
miss	6	53	3942	2	miss
moas	6	55	4534	2	moas
mobs	8	57	3737	2	mobs
mocs	8	58	3490	2	mocs
mods	7	79	4505	2	mods
mogs	7	54	3933	2	mogs
mols	6	59	4857	2	mols
moms	8	65	3948	2	moms
mons	6	81	5226	2	mons
moos	6	60	5130	2	moos
mops	8	59	4013	2	mops
mors	6	59	5006	2	mors
mos	5	70	6712	2	mo_s
mosh	9	52	2760	2	mosh
mosk	10	56	2244	2	mosk
mosks	11	61	1700	2	mosks
mosso	7	47	1518	2	mosso
mossy	10	52	1706	2	mossy
most	6	65	5420	2	most
mosts	7	60	2854	2	mosts
mots	6	68	5316	2	mots
mows	9	63	4083	2	mows
muss	6	49	3376	2	muss
ness	4	55	2656	2	ness
nobs	6	64	3690	2	nobs
nods	5	58	3822	2	nods
noes	4	58	4539	2	noes
nogs	5	65	3461	2	nogs
noms	6	56	3640	2	noms
nos	3	88	5932	2	no_s
nose	4	67	3936	2	nose
noses	5	54	3564	2	noses
nosh	7	62	2354	2	nosh
nosy	7	63	2289	2	nosy
nous	4	61	3698	2	nous
nows	7	57	3823	2	nows
ods	4	75	4621	2	_ods
oes	3	58	6619	2	_oes
offs	10	71	1701	2	offs
ohs	6	62	3231	2	_ohs
oms	5	63	3751	2	_oms
ons	3	61	4851	2	_ons
oohs	7	52	2069	2	oohs
oops	6	52	3267	2	oops
oots	4	64	4644	2	oots
ops	5	66	4125	2	_ops
ors	3	57	5011	2	_ors
os	2	113	5988	2	_o_s
ose	3	81	4734	2	_ose
oses	4	66	4151	2	_oses
ossa	4	37	1416	2	_ossa
pass	6	52	3995	2	pass
piss	6	50	3333	2	piss
pods	7	65	4015	2	pods
pois	6	65	3904	2	pois
pols	6	60	4456	2	pols
poms	8	70	3774	2	poms
pons	6	58	5060	2	pons
poos	6	59	4911	2	poos
pops	8	63	4095	2	pops
pose	6	64	4173	2	pose
poses	7	46	4276	2	poses
posh	9	54	2732	2	posh
posse	7	47	2227	2	posse
post	6	79	5336	2	post
posts	7	52	2878	2	posts
posy	9	60	2842	2	posy
pots	6	64	5236	2	pots
pows	9	55	3766	2	pows
pross	7	65	2940	2	pross
puss	6	48	3013	2	puss
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5414	2	roes
roms	6	70	3896	2	roms
rose	4	61	4890	2	rose
roses	5	64	4577	2	roses
rosy	7	60	2487	2	rosy
rots	4	64	5409	2	rots
rows	7	59	4175	2	rows
sass	4	50	3562	2	sass
sobs	6	49	4175	2	sobs
sods	5	49	4021	2	sods
sols	4	54	4816	2	sols
soms	6	62	3937	2	soms
sons	4	60	4955	2	sons
sops	6	52	4456	2	sops
sos	3	77	6160	2	so_s
sots	4	55	5245	2	sots
sous	4	69	4721	2	sous
sows	7	53	4249	2	sows
soys	7	52	3393	2	soys
stoss	5	43	1634	2	stoss
suss	4	52	2930	2	suss
tass	4	56	4057	2	tass
tods	5	61	4184	2	tods
toes	4	69	5644	2	toes
togs	5	72	4243	2	togs
toms	6	83	4349	2	toms
tons	4	65	5305	2	tons
tops	6	62	4812	2	tops
tors	4	61	5738	2	tors
tosh	7	48	2681	2	tosh
tost	4	83	5192	2	tost
tots	4	66	5412	2	tots
tows	7	85	4555	2	tows
toys	7	80	3634	2	toys
voes	7	54	3282	2	voes
vows	10	66	2694	2	vows
wiss	7	56	3054	2	wiss
woes	7	64	4066	2	woes
wogs	8	65	3140	2	wogs
woks	11	62	2490	2	woks
wons	7	49	4204	2	wons
woos	7	62	3880	2	woos
wops	9	66	3415	2	wops
wos	6	69	5353	2	wo_s
wost	7	65	4436	2	wost
wots	7	63	4289	2	wots
wows	10	46	3349	2	wows
wuss	7	52	1933	2	wuss
yobs	9	60	2808	2	yobs
yods	8	65	3118	2	yods
yoks	11	62	2374	2	yoks
yous	7	62	3065	2	yous
yows	10	64	3312	2	yows
zoos	13	58	2880	2	zoos

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.263	679433.5
2	DLD Change Limit	29872	381	0.846	35309.7
3	Display Results	381	381	0.093	4096.8
	(SQL Overall)	178691	381	1.202	148661.4