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

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

328 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
stats	5	59	3336	(None)
scats	7	59	3060	1	scats
seats	5	48	4434	1	seats
skats	9	46	2153	1	skats
slats	5	54	3690	1	slats
spats	7	50	3138	1	spats
stabs	7	62	2138	1	stabs
stags	6	62	2674	1	stags
stars	5	58	3657	1	stars
starts	6	54	2312	1	starts
stat	4	73	5269	1	stat_
state	5	62	3733	1	state
states	6	43	3708	1	states
status	6	55	1521	1	status
stays	8	60	2202	1	stays
stets	5	54	2391	1	stets
stoats	6	51	1748	1	stoats
stots	5	48	2854	1	stots
swats	8	57	2686	1	swats
tats	4	68	5813	1	_tats
ataps	7	64	1483	2	ataps
bats	6	69	6233	2	_bats
batts	7	67	2756	2	batts
beats	7	60	4224	2	beats
blats	7	51	3250	2	blats
boats	7	56	3515	2	boats
brats	7	53	3601	2	brats
cats	6	63	5634	2	_cats
chats	10	57	3009	2	chats
coats	7	56	3499	2	coats
doats	6	52	2488	2	doats
drats	6	66	2837	2	drats
eats	4	70	5487	2	_eats
estate	6	47	1976	2	estate
estates	7	45	2017	2	estates
etas	4	64	3227	2	eta_s
fats	7	62	5250	2	_fats
feats	8	64	3275	2	feats
fiats	8	53	2448	2	fiats
flats	8	64	2974	2	flats
frats	8	68	2967	2	frats
gats	5	67	5344	2	_gats
ghats	9	58	1861	2	ghats
gnats	6	52	1771	2	gnats
goats	6	55	2730	2	goats
hats	7	68	5825	2	_hats
heats	8	58	3840	2	heats
ikats	9	53	1115	2	ikats
kats	8	59	4433	2	_kats
khats	12	53	1601	2	khats
kyats	12	50	1244	2	kyats
lats	4	59	6270	2	_lats
mats	6	54	6028	2	_mats
matts	7	68	2918	2	matts
meats	7	50	3405	2	meats
moats	7	58	2764	2	moats
neats	5	59	3190	2	neats
oats	4	65	5421	2	_oats
pats	6	64	6085	2	_pats
peats	7	61	4019	2	peats
plats	7	55	3137	2	plats
prats	7	63	3339	2	prats
qats	13	53	3134	2	_qats
rats	4	62	6037	2	_rats
sabs	6	66	4374	2	s_abs
sacs	6	57	3907	2	s_acs
sags	5	59	4840	2	s_ags
sals	4	68	5167	2	s_als
salts	5	54	3188	2	salts
sans	4	51	5335	2	s_ans
saps	6	53	4637	2	s_aps
sass	4	50	3562	2	s_ass
sat	3	62	8848	2	s_at_
satays	9	44	1168	2	satays
sate	4	55	5610	2	s_ate
sates	5	49	4932	2	sates
sati	4	55	3932	2	s_ati
satis	5	56	3367	2	satis
saws	7	58	3948	2	s_aws
says	7	59	4210	2	s_ays
scabs	9	48	1864	2	scabs
scads	8	54	1995	2	scads
scags	8	55	2097	2	scags
scams	9	44	2397	2	scams
scans	7	46	2510	2	scans
scants	8	52	1972	2	scants
scars	7	54	3353	2	scars
scarts	8	53	2149	2	scarts
scat	6	58	4837	2	scat_
scatt	7	60	3009	2	scatt
scatts	8	59	1466	2	scatts
scots	7	40	2590	2	scots
scuts	7	45	2252	2	scuts
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	s_ets
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
shads	9	51	2448	2	shads
shafts	12	54	1143	2	shafts
shags	9	51	2386	2	shags
shahs	11	59	1951	2	shahs
shams	10	58	2941	2	shams
shat	7	64	5659	2	shat_
shaws	11	62	2626	2	shaws
shays	11	60	2143	2	shays
shits	8	47	3116	2	shits
shoats	9	41	1707	2	shoats
shots	8	47	3083	2	shots
shuts	8	56	2247	2	shuts
sials	5	42	2724	2	sials
sifts	8	49	1892	2	sifts
silts	5	53	3082	2	silts
sitars	6	54	1759	2	sitars
sits	4	50	5020	2	s_its
skags	10	43	1607	2	skags
skas	8	53	2571	2	ska_s
skat	8	70	3789	2	skat_
skate	9	47	2154	2	skate
skates	10	42	1939	2	skates
skits	9	47	2185	2	skits
slabs	7	53	2264	2	slabs
slags	6	65	2590	2	slags
slams	7	49	2790	2	slams
slants	6	48	1908	2	slants
slaps	7	60	2571	2	slaps
slat	4	69	5902	2	slat_
slate	5	54	3828	2	slate
slates	6	49	3406	2	slates
slaty	8	65	2315	2	slaty
slaws	8	52	2271	2	slaws
slays	8	57	2368	2	slays
slits	5	61	2885	2	slits
slots	5	48	3052	2	slots
sluts	5	45	2398	2	sluts
smalts	8	52	1489	2	smalts
smarts	8	62	1800	2	smarts
smuts	7	54	1571	2	smuts
snags	6	44	2131	2	snags
snaps	7	47	1956	2	snaps
snath	8	64	1980	2	snath
snaths	9	51	1291	2	snaths
snaws	8	61	1636	2	snaws
snits	5	41	2483	2	snits
snots	5	52	2510	2	snots
soaks	9	52	2029	2	soaks
soaps	7	51	2071	2	soaps
soars	5	47	3251	2	soars
softs	8	50	1923	2	softs
soots	5	55	3620	2	soots
sorts	5	45	3666	2	sorts
sots	4	55	5244	2	s_ots
spaes	7	60	2997	2	spaes
spaits	8	50	1747	2	spaits
spams	9	49	2219	2	spams
spans	7	45	2873	2	spans
spars	7	54	3154	2	spars
spas	6	70	3672	2	spa_s
spat	6	65	4852	2	spat_
spate	7	47	3158	2	spate
spates	8	50	2817	2	spates
spays	10	55	2051	2	spays
spits	7	44	2955	2	spits
splats	8	48	1730	2	splats
spots	7	44	2410	2	spots
sprats	8	58	1993	2	sprats
squats	15	37	1296	2	squats
stab	6	73	2993	2	sta_b
stack	11	44	2169	2	stack
stacks	12	43	1726	2	stacks
stacte	8	21	1391	2	stacte
stactes	9	19	1463	2	stactes
stade	6	48	2530	2	stade
stades	7	46	2624	2	stades
staff	11	38	1771	2	staff
staffs	12	34	975	2	staffs
stag	5	73	3200	2	sta_g
stage	6	53	3019	2	stage
stages	7	56	2949	2	stages
stagy	9	66	1889	2	stagy
staid	6	67	2207	2	staid
staig	6	55	1963	2	staig
staigs	7	54	1481	2	staigs
stain	5	57	2793	2	stain
stains	6	49	2365	2	stains
stair	5	47	1993	2	stair
stairs	6	54	1633	2	stairs
stake	9	59	2753	2	stake
stakes	10	39	2729	2	stakes
stale	5	56	3710	2	stale
stales	6	55	3829	2	stales
stalk	9	45	1800	2	stalk
stalks	10	46	1455	2	stalks
stall	5	47	2235	2	stall
stalls	6	40	1992	2	stalls
stamp	9	52	1736	2	stamp
stamps	10	56	1402	2	stamps
stand	6	59	2328	2	stand
stands	7	51	1805	2	stands
stane	5	59	3300	2	stane
stanes	6	49	3340	2	stanes
stang	6	64	2468	2	stang
stangs	7	50	1816	2	stangs
stank	9	58	2330	2	stank
stanks	10	49	1770	2	stanks
stapes	8	50	2873	2	stapes
staph	10	43	1465	2	staph
staphs	11	44	1103	2	staphs
star	4	80	3776	2	sta_r
stare	5	44	4026	2	stare
stares	6	60	3875	2	stares
starets	7	35	1592	2	starets
stark	9	54	2562	2	stark
start	5	56	4231	2	start
startsy	10	53	670	2	startsy
stases	6	42	2556	2	stases
stash	8	49	1697	2	stash
stasis	6	31	1687	2	stasis
statal	6	16	1322	2	statal
stated	7	54	2783	2	stated
stater	6	44	2755	2	stater
staters	7	39	2232	2	staters
static	8	31	1867	2	static
statics	9	33	1453	2	statics
statin	6	39	2146	2	statin
statins	7	37	1977	2	statins
statism	9	4	1227	2	statism
statist	7	3	1772	2	statist
stator	6	40	1547	2	stator
stators	7	39	1555	2	stators
statue	6	60	1532	2	statue
statues	7	46	1490	2	statues
statusy	10	45	542	2	statusy
stave	8	53	2499	2	stave
staves	9	45	2519	2	staves
staw	7	86	2769	2	sta_w
stay	7	83	3372	2	sta_y
steads	7	41	1622	2	steads
steaks	10	44	1585	2	steaks
steals	6	40	2006	2	steals
steams	8	49	1690	2	steams
stems	7	52	1995	2	stems
stents	6	50	1945	2	stents
steps	7	66	1988	2	steps
stet	4	59	4732	2	stet_
stews	8	55	1914	2	stews
sties	5	51	3298	2	sties
stilts	6	79	1530	2	stilts
stints	6	51	1976	2	stints
stirs	5	59	2161	2	stirs
stoas	5	51	2602	2	stoas
stoat	5	71	3595	2	stoat_
stobs	7	57	1823	2	stobs
stops	7	48	2728	2	stops
stoss	5	43	1634	2	stoss
stot	4	63	4732	2	stot_
stott	5	69	2978	2	stott
stotts	6	46	1285	2	stotts
stouts	6	50	1900	2	stouts
stows	8	66	2270	2	stows
straits	7	49	1632	2	straits
straps	8	77	2178	2	straps
strass	6	71	1722	2	strass
strata	6	36	1628	2	strata
stratas	7	30	1357	2	stratas
strath	9	32	1636	2	strath
straths	10	27	1171	2	straths
strati	6	35	1889	2	strati
stratus	7	30	1172	2	stratus
straws	9	87	1867	2	straws
strays	9	64	1793	2	strays
struts	6	56	1680	2	struts
stubs	7	50	1607	2	stubs
studs	6	44	1587	2	studs
stums	7	53	2008	2	stums
stuns	5	47	1949	2	stuns
stunts	6	56	1525	2	stunts
sturts	6	39	1514	2	sturts
styes	8	63	1652	2	styes
suets	5	51	2610	2	suets
suits	5	50	2805	2	suits
suttas	6	38	1379	2	suttas
swabs	10	58	1727	2	swabs
swags	9	49	2125	2	swags
swans	8	46	2501	2	swans
swaps	10	48	1920	2	swaps
swat	7	72	4444	2	swat_
swath	11	59	2038	2	swath
swaths	12	53	1264	2	swaths
sways	11	55	1846	2	sways
sweats	9	48	1461	2	sweats
swots	8	55	1842	2	swots
tabs	6	68	4298	2	_tabs
tacts	7	65	2412	2	_tacts
tads	5	71	4394	2	_tads
tags	5	55	4523	2	_tags
tams	6	72	4793	2	_tams
tans	4	61	5481	2	_tans
taos	4	55	4100	2	_taos
taps	6	60	5067	2	_taps
tars	4	67	6395	2	_tars
tarts	5	72	4202	2	_tarts
tas	3	84	7710	2	_ta_s
tass	4	56	4057	2	_tass
tat	3	76	9029	2	_tat_
tate	4	47	4860	2	_tate
tates	5	54	4498	2	_tates
taus	4	63	4273	2	_taus
tauts	5	61	2551	2	_tauts
tavs	7	56	3097	2	_tavs
taws	7	56	4159	2	_taws
teats	5	56	3681	2	teats
tets	4	58	4745	2	_tets
tits	4	61	4503	2	_tits
tots	4	66	5412	2	_tots
tsars	5	67	1710	2	tsars
tuts	4	58	3845	2	_tuts
twats	8	66	1660	2	twats
utas	4	59	2495	2	uta_s
vats	7	68	4174	2	_vats
wats	7	75	5588	2	_wats
watts	8	69	2309	2	watts
whats	11	77	1899	2	whats

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	53800	0.096	1861364.6
2	DLD Change Limit	53800	328	1.890	28465.6
3	Display Results	328	328	0.110	2981.8
	(SQL Overall)	178691	328	2.096	85253.3