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

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

280 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
neats	5	59	3190	(None)
beats	7	60	4224	1	beats
eats	4	70	5487	1	_eats
feats	8	64	3275	1	feats
heats	8	58	3840	1	heats
meats	7	50	3405	1	meats
neaps	7	56	1832	1	neaps
nears	5	55	2942	1	nears
neat	4	63	5678	1	neat_
neath	8	60	2028	1	neath
nerts	5	59	2498	1	nerts
nests	5	57	2800	1	nests
nets	4	59	4153	1	ne_ts
netts	5	53	2072	1	netts
newts	8	60	1528	1	newts
peats	7	61	4019	1	peats
seats	5	48	4434	1	seats
teats	5	56	3681	1	teats
anears	6	37	1718	2	anears
bats	6	69	6233	2	_bats
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bears	7	57	3904	2	bears
beast	7	63	3864	2	beast
beasts	8	45	1972	2	beasts
beat	6	61	6830	2	beat_
beaus	7	51	2711	2	beaus
beauts	8	60	1528	2	beauts
beets	7	61	3144	2	beets
belts	7	59	3116	2	belts
bents	7	60	3369	2	bents
bests	7	59	3261	2	bests
betas	7	55	2876	2	betas
bets	6	70	5144	2	be_ts
blats	7	51	3250	2	blats
bleats	8	55	1861	2	bleats
boats	7	56	3515	2	boats
brats	7	53	3601	2	brats
cats	6	63	5634	2	_cats
celts	7	53	2578	2	celts
cents	7	47	3033	2	cents
chats	10	57	3009	2	chats
cheats	11	45	1954	2	cheats
cleats	8	49	1931	2	cleats
coats	7	56	3499	2	coats
deads	7	57	2691	2	deads
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dears	6	57	3688	2	dears
death	9	48	2252	2	death
deaths	10	59	1444	2	deaths
debts	8	64	1837	2	debts
deets	6	53	3024	2	deets
defats	10	51	1455	2	defats
delts	6	57	3179	2	delts
dents	6	50	3180	2	dents
derats	7	46	2506	2	derats
doats	6	52	2488	2	doats
drats	6	66	2837	2	drats
ears	4	63	5659	2	_ears
east	4	66	5910	2	_east
easts	5	75	3032	2	_easts
eat	3	69	8905	2	_eat_
eath	7	57	3566	2	_eath
efts	7	65	1948	2	_efts
enacts	8	40	1297	2	enacts
enate	5	44	2814	2	enate
enates	6	40	2642	2	enates
etas	4	64	3227	2	_etas
fats	7	62	5250	2	_fats
fears	8	48	2939	2	fears
feast	8	59	3272	2	feast
feasts	9	51	1609	2	feasts
feat	7	64	5822	2	feat_
felts	8	53	2454	2	felts
fests	8	58	2804	2	fests
fetas	8	56	2440	2	fetas
fets	7	53	4594	2	fe_ts
fiats	8	53	2448	2	fiats
flats	8	64	2974	2	flats
frats	8	68	2967	2	frats
gats	5	67	5344	2	_gats
gears	6	46	2869	2	gears
gelts	6	59	2461	2	gelts
gents	6	57	2961	2	gents
gests	6	60	2881	2	gests
getas	6	54	2148	2	getas
gets	5	54	4248	2	ge_ts
ghats	9	58	1861	2	ghats
gnats	6	52	1771	2	gnats
goats	6	55	2730	2	goats
greats	7	63	1839	2	greats
haets	8	65	2512	2	haets
hats	7	68	5825	2	_hats
heads	9	51	2711	2	heads
heals	8	57	3345	2	heals
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
hearts	9	62	1894	2	hearts
heat	7	70	6142	2	heat_
heath	11	57	2428	2	heath
heaths	12	63	1638	2	heaths
hefts	11	62	1815	2	hefts
hents	8	73	3074	2	hents
hests	8	58	2993	2	hests
hets	7	55	4720	2	he_ts
ikats	9	53	1115	2	ikats
inerts	6	45	1702	2	inerts
jeans	12	60	2211	2	jeans
jests	12	59	2245	2	jests
jets	11	58	3410	2	je_ts
kats	8	59	4433	2	_kats
keas	8	63	3709	2	kea_s
keets	9	51	2348	2	keets
kelts	9	52	2263	2	kelts
khats	12	53	1601	2	khats
kneads	11	35	709	2	kneads
kyats	12	50	1244	2	kyats
lats	4	59	6270	2	_lats
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
least	5	61	3488	2	least
leasts	6	46	1641	2	leasts
leets	5	49	2712	2	leets
lefts	8	65	1781	2	lefts
lets	4	71	4794	2	le_ts
mats	6	54	6028	2	_mats
meads	8	54	2532	2	meads
meals	7	59	3337	2	meals
means	7	58	3122	2	means
meat	6	63	5960	2	meat_
meatus	8	51	1292	2	meatus
meaty	10	70	2131	2	meaty
meets	7	42	2461	2	meets
melts	7	49	3010	2	melts
moats	7	58	2764	2	moats
naans	5	58	1525	2	naans
nabs	6	62	3619	2	n_abs
nags	5	54	3602	2	n_ags
nans	4	61	3939	2	n_ans
naos	4	74	2973	2	n_aos
naps	6	62	3858	2	n_aps
nates	5	52	3833	2	n_ates
nays	7	59	3159	2	n_ays
neap	6	69	2701	2	nea_p
near	4	52	3650	2	nea_r
neaten	6	42	1454	2	neaten
neatens	7	33	1040	2	neatens
neater	6	44	2431	2	neater
neatest	7	25	1600	2	neatest
neatly	9	38	1248	2	neatly
nebs	6	61	2498	2	ne_bs
necks	11	51	1933	2	necks
needs	6	57	1963	2	needs
neems	7	73	1629	2	neems
neeps	7	56	1788	2	neeps
negate	7	29	1557	2	negate
negates	8	32	1583	2	negates
negs	5	57	2736	2	ne_gs
negus	6	45	1356	2	negus
neifs	8	56	1304	2	neifs
neist	5	46	2844	2	neist
nemas	7	53	2157	2	nemas
nenes	5	53	2967	2	nenes
neons	5	58	1868	2	neons
nerds	6	57	1925	2	nerds
nertz	14	51	1745	2	nertz
ness	4	55	2656	2	ne_ss
nest	4	55	4873	2	nest_
net	3	66	7029	2	ne_t_
nett	4	66	4323	2	ne_tt
netty	8	58	1676	2	netty
neuks	9	65	1086	2	neuks
neums	7	54	1425	2	neums
neves	8	70	2187	2	neves
nevus	8	46	1139	2	nevus
news	7	61	2737	2	ne_ws
newt	7	69	3374	2	newt_
next	11	66	3108	2	next_
nexus	12	47	1066	2	nexus
nits	4	57	4164	2	n_its
nowts	8	69	1585	2	nowts
nuts	4	50	3267	2	n_uts
oats	4	65	5421	2	_oats
pats	6	64	6085	2	_pats
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peat	6	59	6793	2	peat_
peaty	10	57	2569	2	peaty
pelts	7	61	2881	2	pelts
pests	7	59	3327	2	pests
pets	6	62	4833	2	pe_ts
plats	7	55	3137	2	plats
pleats	8	52	1859	2	pleats
prats	7	63	3339	2	prats
qats	13	53	3134	2	_qats
rats	4	62	6037	2	_rats
reacts	8	36	1660	2	reacts
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
reata	5	42	2539	2	reata
reatas	6	40	2101	2	reatas
rents	5	59	3518	2	rents
rests	5	49	3587	2	rests
rets	4	53	5256	2	re_ts
scats	7	59	3060	2	scats
seals	5	48	3969	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seat	4	75	7556	2	seat_
sects	7	56	2289	2	sects
septs	7	54	2060	2	septs
sets	4	55	4950	2	se_ts
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
skats	9	46	2153	2	skats
slats	5	54	3690	2	slats
sneaks	10	43	1249	2	sneaks
sneaps	8	45	1086	2	sneaps
spats	7	50	3138	2	spats
stats	5	59	3336	2	stats
swats	8	57	2686	2	swats
sweats	9	48	1461	2	sweats
tats	4	68	5813	2	_tats
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tears	5	54	3646	2	tears
teas	4	58	5149	2	tea_s
teat	4	59	6363	2	teat_
tents	5	64	3421	2	tents
tests	5	65	3019	2	tests
tets	4	58	4745	2	te_ts
texts	12	55	1504	2	texts
treats	6	48	2169	2	treats
twats	8	66	1660	2	twats
unhats	9	11	1062	2	unhats
unseats	7	30	1285	2	unseats
vats	7	68	4174	2	_vats
veals	8	49	2619	2	veals
vents	8	61	2593	2	vents
verts	8	57	2473	2	verts
vests	8	53	2598	2	vests
vets	7	68	3509	2	ve_ts
wats	7	75	5588	2	_wats
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wears	8	60	3030	2	wears
weets	8	54	2772	2	weets
wefts	11	67	1549	2	wefts
welts	8	52	2519	2	welts
wests	8	57	2700	2	wests
wets	7	59	4029	2	we_ts
whats	11	77	1899	2	whats
wheats	12	50	1322	2	wheats
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yeast	8	53	2794	2	yeast
yeasts	9	64	1305	2	yeasts
yetts	8	67	1513	2	yetts
zeals	14	53	2085	2	zeals
zests	14	54	1974	2	zests
zetas	14	50	1816	2	zetas

Search took 9 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	53800	0.343	520965.0
2	DLD Change Limit	53800	280	6.046	8898.4
3	Display Results	280	280	0.266	1052.6
	(SQL Overall)	178691	280	6.655	26850.6