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

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

416 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
fops	9	65	3268	(None)
bops	8	60	3798	1	bops
cops	8	67	5137	1	cops
flops	10	59	2014	1	flops
fobs	9	60	3427	1	fobs
foes	7	65	4344	1	foes
fogs	8	70	3500	1	fogs
fons	7	69	4389	1	fons
fop	8	67	4370	1	fop_
foss	7	64	3164	1	foss
foys	10	56	2829	1	foys
hops	9	79	4263	1	hops
kops	10	70	3129	1	kops
lops	6	60	4335	1	lops
mops	8	59	4013	1	mops
oops	6	52	3267	1	oops
ops	5	66	4125	1	_ops
pops	8	63	4095	1	pops
sops	6	52	4456	1	sops
tops	6	62	4812	1	tops
wops	9	66	3415	1	wops
alps	6	55	2924	2	alps
amps	8	62	3034	2	amps
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
asps	6	56	2209	2	asps
baps	8	60	4084	2	baps
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
bop	7	75	4948	2	bop_
bos	5	79	6681	2	bo_s
boss	6	59	3834	2	boss
bots	6	64	5395	2	bots
bows	9	62	4286	2	bows
boys	9	67	3733	2	boys
caps	8	71	4789	2	caps
ceps	8	61	2595	2	ceps
chops	12	50	1987	2	chops
clops	9	59	2485	2	clops
cobs	8	70	4314	2	cobs
cods	7	68	4810	2	cods
cogs	7	73	4003	2	cogs
cols	6	65	5308	2	cols
comps	11	55	2605	2	comps
cons	6	60	5769	2	cons
coops	9	62	2964	2	coops
coos	6	74	5649	2	coos
cop	7	111	6237	2	cop_
cope	8	68	4738	2	cope
copes	9	77	4710	2	copes
copse	9	56	2392	2	copse
copy	11	62	2980	2	copy
corps	9	59	2704	2	corps
cors	6	66	5644	2	cors
cos	5	102	7039	2	co_s
coss	6	61	4349	2	coss
cots	6	80	5484	2	cots
coups	9	55	2247	2	coups
cows	9	70	4664	2	cows
coys	9	75	3724	2	coys
crops	9	61	2523	2	crops
cups	8	54	3082	2	cups
daps	7	72	3916	2	daps
dips	7	55	3691	2	dips
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
dopa	7	72	2090	2	dopa
dopas	8	50	1906	2	dopas
dope	7	60	3889	2	dope
dopes	8	49	3504	2	dopes
dopy	10	62	2415	2	dopy
dorps	8	54	1922	2	dorps
dors	5	67	4760	2	dors
dos	4	80	6231	2	do_s
doss	5	62	3504	2	doss
dots	5	56	4766	2	dots
dows	8	59	4105	2	dows
drops	8	57	1950	2	drops
dups	7	59	2951	2	dups
eons	4	66	3871	2	eons
epos	6	67	2373	2	epos
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
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
fess	7	65	2916	2	fess
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
fits	7	60	4346	2	fits
flaps	10	56	2138	2	flaps
flips	10	51	1774	2	flips
flocs	10	55	1923	2	flocs
floes	8	55	2814	2	floes
flogs	9	59	1996	2	flogs
flop	9	69	2545	2	flop_
floss	8	51	1826	2	floss
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
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
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
fossa	8	58	1263	2	fossa
fosse	8	61	1946	2	fosse
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
fraps	10	56	2055	2	fraps
froes	8	61	2669	2	froes
frogs	9	62	2077	2	frogs
frons	8	61	2404	2	frons
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
fuss	7	60	2793	2	fuss
gaps	7	60	4297	2	gaps
gips	7	56	3292	2	gips
glops	8	56	1955	2	glops
goas	5	52	3994	2	goas
gobs	7	69	3557	2	gobs
gods	6	54	3804	2	gods
goes	5	56	4409	2	goes
goops	8	66	2096	2	goops
goos	5	76	4491	2	goos
gorps	8	53	1699	2	gorps
gos	4	71	5513	2	go_s
goys	8	63	2841	2	goys
gyps	10	51	1502	2	gyps
haps	9	64	4346	2	haps
hips	9	64	3370	2	hips
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
hoops	10	56	2107	2	hoops
hop	8	75	5459	2	hop_
hope	9	66	3967	2	hope
hopes	10	58	3564	2	hopes
hos	6	83	6419	2	ho_s
hots	7	83	4933	2	hots
hows	10	63	4560	2	hows
hoys	10	77	3393	2	hoys
hyps	12	54	1841	2	hyps
imps	8	62	2112	2	imps
ions	4	67	3785	2	ions
jobs	13	65	2943	2	jobs
joes	11	66	3589	2	joes
jogs	12	71	2933	2	jogs
joss	11	59	2559	2	joss
jots	11	63	3614	2	jots
jows	14	66	3209	2	jows
joys	14	66	2466	2	joys
keps	10	60	2730	2	keps
kips	10	64	3051	2	kips
knops	11	59	1181	2	knops
koas	8	56	3509	2	koas
kobs	10	58	3108	2	kobs
kois	8	51	2940	2	kois
kop	9	74	4020	2	kop_
koph	13	58	1654	2	koph
kophs	14	50	1093	2	kophs
kors	8	59	3301	2	kors
kos	7	69	4482	2	ko_s
koss	8	52	2481	2	koss
laps	6	68	4887	2	laps
lips	6	71	4144	2	lips
lobs	6	64	4108	2	lobs
logs	5	73	4311	2	logs
loops	7	57	2396	2	loops
loos	4	90	5112	2	loos
lop	5	82	5531	2	lop_
lope	6	59	4192	2	lope
lopes	7	64	3734	2	lopes
loss	4	53	3796	2	loss
lots	4	76	5209	2	lots
loups	7	53	1962	2	loups
lows	7	58	4301	2	lows
maps	8	61	4105	2	maps
mips	8	55	3408	2	mips
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
mop	7	69	5082	2	mop_
mope	8	68	3804	2	mope
mopes	9	51	3498	2	mopes
mopy	11	57	2197	2	mopy
mors	6	59	5006	2	mors
mos	5	70	6712	2	mo_s
moss	6	76	4103	2	moss
mots	6	68	5316	2	mots
mows	9	63	4083	2	mows
naps	6	62	3858	2	naps
nips	6	58	3092	2	nips
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
nope	6	59	3419	2	nope
nos	3	88	5932	2	no_s
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
oots	4	64	4644	2	oots
op	4	58	5016	2	_op_
ope	5	68	4524	2	_ope
opes	6	59	4261	2	_opes
opt	5	75	4554	2	_opt
opts	6	81	2474	2	_opts
opus	6	64	2059	2	_opus
ors	3	57	5011	2	_ors
os	2	113	5988	2	_o_s
paps	8	64	4345	2	paps
peps	8	51	3451	2	peps
pips	8	58	3713	2	pips
plops	9	59	2033	2	plops
pods	7	65	4015	2	pods
pois	6	65	3904	2	pois
pols	6	60	4456	2	pols
pomps	11	53	1619	2	pomps
poms	8	70	3774	2	poms
pons	6	58	5060	2	pons
poops	9	44	2241	2	poops
poos	6	59	4911	2	poos
pop	7	62	5225	2	pop_
pope	8	55	3561	2	pope
popes	9	59	3381	2	popes
popsy	12	57	1340	2	popsy
pots	6	64	5236	2	pots
pows	9	55	3766	2	pows
props	9	57	2688	2	props
pups	8	60	3223	2	pups
qoph	18	59	1194	2	qoph
qophs	19	50	781	2	qophs
raps	6	62	4773	2	raps
reps	6	59	3795	2	reps
rips	6	62	3743	2	rips
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5413	2	roes
romps	9	46	1754	2	romps
roms	6	70	3896	2	roms
rope	6	55	4291	2	rope
ropes	7	59	4006	2	ropes
ropy	9	63	2341	2	ropy
rots	4	64	5409	2	rots
roups	7	51	1890	2	roups
rows	7	59	4175	2	rows
saps	6	53	4637	2	saps
scops	9	58	2019	2	scops
shops	10	42	2290	2	shops
sips	6	57	4010	2	sips
slops	7	50	2601	2	slops
soaps	7	51	2071	2	soaps
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
sop	5	75	5786	2	sop_
soph	9	70	2420	2	soph
sophs	10	49	1602	2	sophs
sos	3	77	6160	2	so_s
sots	4	55	5245	2	sots
soups	7	53	2294	2	soups
sous	4	69	4721	2	sous
sows	7	53	4249	2	sows
soys	7	52	3393	2	soys
stops	7	48	2728	2	stops
sups	6	48	3443	2	sups
swops	10	59	1397	2	swops
taps	6	60	5067	2	taps
tips	6	64	3676	2	tips
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
top	5	105	6068	2	top_
tope	6	59	4638	2	tope
topes	7	69	4176	2	topes
toph	9	63	2687	2	toph
tophs	10	52	2005	2	tophs
topi	6	78	3039	2	topi
topis	7	60	2583	2	topis
topo	6	69	3240	2	topo
topos	7	57	2639	2	topos
tors	4	61	5738	2	tors
toss	4	56	3797	2	toss
tots	4	66	5412	2	tots
tows	7	85	4555	2	tows
toys	7	80	3634	2	toys
tups	6	56	2876	2	tups
umps	8	57	2194	2	umps
ups	5	56	2905	2	_ups
urps	6	69	2047	2	urps
voes	7	54	3282	2	voes
vows	10	66	2694	2	vows
waps	9	66	4208	2	waps
whops	13	50	1393	2	whops
woes	7	64	4066	2	woes
wogs	8	65	3140	2	wogs
woks	11	62	2490	2	woks
wons	7	49	4204	2	wons
woops	10	49	1752	2	woops
woos	7	62	3880	2	woos
wop	8	71	4513	2	wop_
wos	6	69	5353	2	wo_s
wots	7	63	4289	2	wots
wows	10	46	3349	2	wows
yaps	9	59	3352	2	yaps
yeps	9	59	2440	2	yeps
yips	9	52	2670	2	yips
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
yups	9	61	2160	2	yups
zaps	15	68	2689	2	zaps
zeps	15	60	1934	2	zeps
zips	15	57	2379	2	zips
zoos	13	58	2880	2	zoos

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.140	1276364.3
2	DLD Change Limit	29872	416	1.796	16632.5
3	Display Results	416	416	0.203	2049.3
	(SQL Overall)	178691	416	2.139	83539.5