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

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

466 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
gets	5	54	4248	(None)
bets	6	70	5144	1	bets
fets	7	53	4594	1	fets
gats	5	67	5344	1	gats
geds	6	67	3081	1	geds
gees	5	56	4788	1	gees
gels	5	68	3610	1	gels
gelts	6	59	2461	1	gelts
gems	7	53	2911	1	gems
gens	5	57	4007	1	gens
gents	6	57	2961	1	gents
gest	5	61	4913	1	gest
gests	6	60	2881	1	gests
get	4	74	6746	1	get_
geta	5	66	2744	1	geta
getas	6	54	2148	1	getas
gits	5	57	4459	1	gits
guts	5	66	3725	1	guts
hets	7	55	4720	1	hets
jets	11	58	3410	1	jets
lets	4	71	4794	1	lets
nets	4	59	4153	1	nets
pets	6	62	4833	1	pets
rets	4	53	5256	1	rets
sets	4	55	4950	1	sets
tets	4	58	4746	1	tets
vets	7	68	3509	1	vets
wets	7	59	4029	1	wets
abets	7	56	2167	2	abets
acts	6	69	2986	2	acts
agents	7	48	1629	2	agents
agers	6	50	2785	2	agers
ages	5	58	4459	2	age_s
aglets	7	39	1568	2	aglets
aits	4	63	5553	2	aits
alts	4	66	3990	2	alts
ants	4	72	4347	2	ants
arts	4	96	5026	2	arts
ates	4	50	4792	2	ates
bats	6	69	6233	2	bats
beats	7	60	4224	2	beats
beds	7	59	3778	2	beds
bees	6	54	5338	2	bees
beets	7	61	3144	2	beets
begets	9	62	1552	2	begets
begs	7	57	3383	2	begs
bels	6	61	4249	2	bels
belts	7	59	3116	2	belts
bens	6	59	4570	2	bens
bents	7	60	3369	2	bents
bes	5	65	5743	2	be_s
best	6	63	5532	2	best
bests	7	59	3261	2	bests
bet	5	83	7667	2	bet_
beta	6	62	3413	2	beta
betas	7	55	2876	2	betas
beth	9	66	2923	2	beth
beths	10	55	1922	2	beths
beys	9	138	2955	2	beys
bits	6	61	4816	2	bits
blets	7	53	2494	2	blets
bots	6	64	5395	2	bots
buts	6	72	4769	2	buts
cats	6	63	5634	2	cats
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
celts	7	53	2578	2	celts
cents	7	47	3033	2	cents
ceps	8	61	2595	2	ceps
cess	6	53	2605	2	cess
cete	6	49	3478	2	cete
cetes	7	57	3110	2	cetes
cots	6	80	5484	2	cots
cuts	6	58	4115	2	cuts
debs	7	65	3024	2	debs
debts	8	64	1837	2	debts
dees	5	63	5663	2	dees
deets	6	53	3024	2	deets
dels	5	67	4547	2	dels
delts	6	57	3179	2	delts
dens	5	59	4507	2	dens
dents	6	50	3180	2	dents
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
diets	6	60	2664	2	diets
dits	5	64	5052	2	dits
dots	5	56	4766	2	dots
duets	6	53	2388	2	duets
eats	4	70	5487	2	eats
eds	4	66	3892	2	_eds
eels	4	65	3674	2	eels
efs	6	68	2960	2	_efs
efts	7	65	1948	2	efts
egers	6	51	2037	2	egers
egest	6	52	2234	2	egest
egests	7	44	1125	2	egests
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
egos	5	58	2165	2	egos
egrets	7	27	1224	2	egrets
els	3	76	4572	2	_els
ems	5	64	3549	2	_ems
ens	3	72	4592	2	_ens
ers	3	60	4628	2	_ers
es	2	90	4822	2	_e_s
ess	3	60	3088	2	_ess
et	2	69	6419	2	_et_
eta	3	58	3419	2	_eta
etas	4	64	3227	2	_etas
eth	6	66	3098	2	_eth
eths	7	66	1952	2	_eths
fats	7	62	5250	2	fats
feats	8	64	3275	2	feats
feds	8	52	3431	2	feds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
felts	8	53	2454	2	felts
fems	9	64	2870	2	fems
fens	7	61	3976	2	fens
fes	6	65	5167	2	fe_s
fess	7	65	2916	2	fess
fest	7	49	4944	2	fest
fests	8	58	2804	2	fests
fet	6	64	7163	2	fet_
feta	7	65	2890	2	feta
fetas	8	56	2440	2	fetas
fete	7	57	3492	2	fete
fetes	8	56	3014	2	fetes
fetus	8	58	1654	2	fetus
feus	7	58	3075	2	feus
fits	7	60	4346	2	fits
frets	8	55	2340	2	frets
gabs	7	67	4042	2	gabs
gads	6	78	4338	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gaits	6	57	2601	2	gaits
gals	5	79	4650	2	gals
gams	7	66	4888	2	gams
gaps	7	60	4297	2	gaps
gars	5	57	5074	2	gars
gas	4	88	7025	2	g_as
gast	5	60	5256	2	gast
gasts	6	66	2863	2	gasts
gat	4	68	8051	2	gat_
gate	5	57	4657	2	gate
gates	6	59	3951	2	gates
gays	8	73	3802	2	gays
gear	5	59	3497	2	gear
gears	6	46	2869	2	gears
geck	11	57	2199	2	geck
gecks	12	51	1709	2	gecks
ged	5	70	4453	2	ge_d
gee	4	53	5920	2	ge_e
geed	6	54	3550	2	geed
geek	9	53	2702	2	geek
geeks	10	49	1584	2	geeks
geese	6	43	1600	2	geese
geest	6	48	2962	2	geest
geests	7	59	1216	2	geests
geez	14	64	2486	2	geez
gel	4	56	4243	2	ge_l
geld	6	58	2843	2	geld
gelds	7	51	1834	2	gelds
gelt	5	64	4801	2	gelt
gem	6	68	4022	2	ge_m
gemots	9	37	1215	2	gemots
gen	4	59	5051	2	ge_n
gene	5	62	3722	2	gene
genes	6	51	3309	2	genes
genets	7	57	1666	2	genets
gent	5	69	5439	2	gent
gentes	7	53	2416	2	gentes
genu	5	59	2907	2	genu
genus	6	53	1983	2	genus
germ	7	54	2896	2	germ
germs	8	51	1887	2	germs
gesso	6	4	960	2	gesso
geste	6	59	2069	2	geste
gestes	7	57	2139	2	gestes
getup	8	34	1026	2	getup
getups	9	34	685	2	getups
geum	7	54	2455	2	geum
geums	8	54	1411	2	geums
gey	7	57	3830	2	ge_y
ghats	9	58	1861	2	ghats
ghees	9	52	1555	2	ghees
ghis	8	50	2016	2	ghis
gibs	7	55	2927	2	gibs
gids	6	59	3374	2	gids
gies	5	56	4142	2	gies
gifts	9	62	1496	2	gifts
gigs	6	66	3118	2	gigs
gilts	6	49	2426	2	gilts
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
girts	6	54	2362	2	girts
gist	5	60	4676	2	gist
gists	6	60	2619	2	gists
git	4	62	6605	2	git_
gite	5	54	3861	2	gite
gites	6	56	3018	2	gites
gleds	7	54	1789	2	gleds
glees	6	50	2759	2	glees
gleets	7	53	1505	2	gleets
glens	6	65	1985	2	glens
gleys	9	65	1485	2	gleys
gluts	6	61	2013	2	gluts
gnats	6	52	1771	2	gnats
gnus	5	65	1800	2	gnus
goas	5	52	3994	2	goas
goats	6	55	2730	2	goats
gobs	7	69	3557	2	gobs
godets	8	4	1093	2	godets
gods	6	54	3804	2	gods
goers	6	55	2025	2	goers
goes	5	56	4409	2	goes
goos	5	76	4491	2	goos
gos	4	71	5513	2	g_os
got	4	98	7044	2	got_
goth	8	68	2508	2	goth
goths	9	65	1300	2	goths
gouts	6	48	2617	2	gouts
goys	8	63	2841	2	goys
greats	7	63	1839	2	greats
grees	6	51	3247	2	grees
greets	7	51	1742	2	greets
greys	9	66	1485	2	greys
grits	6	55	2958	2	grits
grots	6	50	2585	2	grots
guess	6	42	1336	2	guess
guest	6	52	2592	2	guest
guests	7	43	1120	2	guests
guls	5	59	3085	2	guls
gums	7	50	3094	2	gums
guns	5	55	3348	2	guns
gust	5	52	4070	2	gust
gusts	6	57	2279	2	gusts
gut	4	67	5385	2	gut_
gutsy	9	64	1284	2	gutsy
guvs	8	58	1681	2	guvs
guys	8	50	1964	2	guys
gyms	10	75	1459	2	gyms
gyps	10	51	1502	2	gyps
haets	8	65	2512	2	haets
hats	7	68	5825	2	hats
heats	8	58	3840	2	heats
hefts	11	62	1815	2	hefts
hehs	10	67	2396	2	hehs
hems	9	55	3494	2	hems
hens	7	56	4257	2	hens
hents	8	73	3074	2	hents
hers	7	58	4487	2	hers
hes	6	66	5420	2	he_s
hest	7	59	5077	2	hest
hests	8	58	2993	2	hests
het	6	76	7431	2	het_
heth	10	70	2802	2	heth
heths	11	63	1778	2	heths
hews	10	56	3157	2	hews
hits	7	55	4513	2	hits
hots	7	83	4933	2	hots
huts	7	67	3744	2	huts
its	3	55	3883	2	_its
jees	11	59	3854	2	jees
jess	11	60	2203	2	jess
jest	11	67	3850	2	jest
jests	12	59	2245	2	jests
jet	10	67	5482	2	jet_
jete	11	59	2725	2	jete
jetes	12	49	2284	2	jetes
jews	14	58	2208	2	jews
jots	11	63	3614	2	jots
juts	11	59	3016	2	juts
kats	8	59	4433	2	kats
keas	8	63	3709	2	keas
keets	9	51	2348	2	keets
kefs	11	59	2274	2	kefs
kegs	9	58	2402	2	kegs
kelts	9	52	2263	2	kelts
kens	8	54	3523	2	kens
keps	10	60	2730	2	keps
keto	8	62	2345	2	keto
keys	11	63	2216	2	keys
khets	12	49	1343	2	khets
kits	8	64	4177	2	kits
lats	4	59	6270	2	lats
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
leets	5	49	2712	2	leets
lefts	8	65	1781	2	lefts
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lens	4	61	4649	2	lens
les	3	56	6307	2	le_s
less	4	56	3510	2	less
lest	4	69	5632	2	lest
let	3	64	8147	2	let_
leys	7	64	3018	2	leys
lits	4	62	5249	2	lits
lots	4	76	5209	2	lots
mats	6	54	6029	2	mats
meats	7	50	3405	2	meats
meds	7	57	3536	2	meds
meets	7	42	2461	2	meets
megs	7	55	3063	2	megs
mels	6	59	4153	2	mels
melts	7	49	3010	2	melts
mems	8	59	3150	2	mems
mess	6	59	3243	2	mess
met	5	60	7243	2	met_
meta	6	59	3241	2	meta
mete	6	44	3813	2	mete
metes	7	47	3621	2	metes
meth	9	58	2784	2	meth
meths	10	53	2023	2	meths
metis	7	50	2590	2	metis
mews	9	66	2933	2	mews
mots	6	68	5316	2	mots
muts	6	48	3998	2	muts
neats	5	59	3190	2	neats
nebs	6	61	2498	2	nebs
negs	5	57	2736	2	negs
nerts	5	59	2498	2	nerts
ness	4	55	2656	2	ness
nest	4	55	4873	2	nest
nests	5	57	2800	2	nests
net	3	66	7029	2	net_
nett	4	66	4323	2	nett
netts	5	53	2072	2	netts
news	7	61	2737	2	news
newts	8	60	1528	2	newts
nits	4	57	4164	2	nits
nuts	4	50	3267	2	nuts
oats	4	65	5421	2	oats
oes	3	58	6619	2	oe_s
ogees	6	51	1914	2	ogees
oots	4	64	4644	2	oots
opts	6	81	2474	2	opts
orts	4	65	3833	2	orts
outs	4	57	4696	2	outs
pats	6	64	6085	2	pats
peas	6	57	5506	2	peas
peats	7	61	4019	2	peats
pecs	8	46	3410	2	pecs
peds	7	58	3524	2	peds
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
pelts	7	61	2881	2	pelts
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	pe_s
pest	6	55	5529	2	pest
pests	7	59	3327	2	pests
pet	5	64	7730	2	pet_
pews	9	57	3153	2	pews
pits	6	63	4874	2	pits
poets	7	60	2444	2	poets
pots	6	64	5236	2	pots
puts	6	56	4175	2	puts
qats	13	53	3134	2	qats
rats	4	62	6037	2	rats
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
rents	5	59	3518	2	rents
reps	6	59	3795	2	reps
res	3	55	6504	2	re_s
rest	4	64	5984	2	rest
rests	5	49	3587	2	rests
ret	3	59	8283	2	ret_
rete	4	49	4413	2	rete
revs	7	50	2705	2	revs
rots	4	64	5409	2	rots
ruts	4	45	4149	2	ruts
seas	4	57	5527	2	seas
seats	5	48	4434	2	seats
secs	6	50	3389	2	secs
sects	7	56	2289	2	sects
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
septs	7	54	2060	2	septs
sers	4	57	4665	2	sers
set	3	66	8125	2	set_
seta	4	56	3731	2	seta
sett	4	59	4905	2	sett
setts	5	51	2432	2	setts
sews	7	58	3602	2	sews
sexts	12	51	1838	2	sexts
sits	4	50	5020	2	sits
sots	4	55	5245	2	sots
stets	5	54	2391	2	stets
suets	5	51	2610	2	suets
tats	4	68	5813	2	tats
teas	4	58	5149	2	teas
teats	5	56	3681	2	teats
teds	5	49	3257	2	teds
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
tens	4	56	4741	2	tens
tents	5	64	3421	2	tents
test	4	86	5162	2	test
tests	5	65	3019	2	tests
tet	3	92	7499	2	tet_
teth	7	63	2789	2	teth
teths	8	54	1851	2	teths
tews	7	64	3164	2	tews
texts	12	55	1504	2	texts
tits	4	61	4504	2	tits
tots	4	66	5412	2	tots
trets	5	59	2802	2	trets
tuts	4	58	3845	2	tuts
utes	4	59	3088	2	utes
uts	3	55	3437	2	_uts
vats	7	68	4174	2	vats
vees	7	54	3943	2	vees
vents	8	61	2593	2	vents
verts	8	57	2473	2	verts
vest	7	57	4360	2	vest
vests	8	53	2598	2	vests
vet	6	59	5852	2	vet_
veto	7	66	2299	2	veto
wats	7	75	5588	2	wats
webs	9	66	2212	2	webs
weds	8	66	2893	2	weds
wees	7	62	4912	2	wees
weets	8	54	2772	2	weets
wefts	11	67	1549	2	wefts
welts	8	52	2519	2	welts
wens	7	63	3793	2	wens
west	7	57	4808	2	west
wests	8	57	2700	2	wests
wet	6	59	6662	2	wet_
whets	11	50	1961	2	whets
wits	7	60	4487	2	wits
wots	7	63	4289	2	wots
yeas	7	86	3842	2	yeas
yens	7	58	3226	2	yens
yeps	9	59	2440	2	yeps
yes	6	62	5061	2	ye_s
yet	6	69	6069	2	yet_
yeti	7	58	2321	2	yeti
yetis	8	54	1839	2	yetis
yett	7	64	3449	2	yett
yetts	8	67	1513	2	yetts
yews	10	53	2396	2	yews
zeds	14	58	2180	2	zeds
zees	13	63	3189	2	zees
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps
zest	13	60	3570	2	zest
zests	14	54	1974	2	zests
zeta	13	51	2164	2	zeta
zetas	14	50	1816	2	zetas
zits	13	60	3029	2	zits

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.296	603685.8
2	DLD Change Limit	29872	466	1.016	29401.6
3	Display Results	466	466	0.110	4236.4
	(SQL Overall)	178691	466	1.422	125661.7