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

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

290 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
stares	6	60	3875	(None)
scares	8	50	3300	1	scares
shares	9	52	3641	1	shares
snares	6	53	2903	1	snares
spares	8	48	3455	1	spares
stades	7	46	2624	1	stades
stages	7	56	2949	1	stages
stakes	10	39	2729	1	stakes
stales	6	55	3829	1	stales
stanes	6	49	3340	1	stanes
stapes	8	50	2873	1	stapes
stare	5	44	4026	1	stare_
stared	7	54	2987	1	stared
starer	6	40	2736	1	starer
starers	7	45	2231	1	starers
starets	7	35	1592	1	starets
stars	5	58	3657	1	star_s
starts	6	54	2312	1	starts
starves	10	46	1455	1	starves
stases	6	42	2556	1	stases
states	6	43	3708	1	states
staves	9	45	2519	1	staves
steres	6	39	2953	1	steres
stores	6	55	3364	1	stores
tares	5	74	5656	1	_tares
ares	4	58	7102	2	__ares
bares	7	54	5713	2	_bares
blares	8	50	2163	2	blares
cares	7	73	6918	2	_cares
chares	11	56	3180	2	chares
dares	6	61	4670	2	_dares
estates	7	45	2017	2	estates
etapes	8	54	1529	2	etapes
fares	8	58	5287	2	_fares
flares	9	45	2170	2	flares
glares	7	55	1886	2	glares
hares	8	62	5554	2	_hares
lares	5	48	5263	2	_lares
mares	7	64	5763	2	_mares
matres	8	45	2223	2	matres
nares	5	55	4415	2	_nares
pares	7	71	6448	2	_pares
rares	5	52	4744	2	_rares
sabes	7	64	3746	2	s_abes
sabres	8	55	2086	2	sabres
sades	6	52	3989	2	s_ades
safes	8	52	2672	2	s_afes
sages	6	53	3906	2	s_ages
sakes	9	55	4075	2	s_akes
sales	5	60	5559	2	s_ales
sanes	5	56	4907	2	s_anes
sards	6	47	3618	2	s_ards
saree	5	50	4466	2	s_aree
sarees	6	53	2994	2	s_arees
sarges	7	51	2859	2	s_arges
saris	5	45	4495	2	s_aris
sarks	9	66	3246	2	s_arks
saros	5	52	3806	2	s_aros
sataras	7	3	1505	2	sataras
sates	5	49	4932	2	s_ates
satires	7	26	1757	2	satires
saves	8	58	3863	2	s_aves
saxes	12	52	2934	2	s_axes
scales	8	45	2931	2	scales
scapes	10	51	2226	2	scapes
scare	7	53	3446	2	scare_
scared	9	52	2729	2	scared
scarer	8	45	2460	2	scarer
scarers	9	46	1850	2	scarers
scarey	11	50	1698	2	scarey
scarfs	11	47	1468	2	scarfs
scarps	10	47	1860	2	scarps
scars	7	54	3353	2	scar_s
scarts	8	53	2149	2	scarts
scarves	12	45	1162	2	scarves
scores	8	47	2592	2	scores
seared	7	52	3284	2	seared
searer	6	54	3202	2	searer
searest	7	33	2202	2	searest
sears	5	47	4491	2	sear_s
seres	5	54	4889	2	s_eres
shades	10	59	2453	2	shades
shakes	13	50	2459	2	shakes
shales	9	47	3125	2	shales
shames	11	47	2622	2	shames
shapes	11	51	2494	2	shapes
shards	10	43	1917	2	shards
share	8	64	3708	2	share_
shared	10	58	2906	2	shared
sharer	9	50	2548	2	sharer
sharers	10	47	2062	2	sharers
sharks	13	50	1972	2	sharks
sharns	9	55	1698	2	sharns
sharps	11	55	1608	2	sharps
shaves	12	52	2493	2	shaves
shires	9	52	2557	2	shires
shores	9	48	3040	2	shores
sires	5	59	4537	2	s_ires
sitars	6	54	1759	2	sitar_s
skates	10	42	1939	2	skates
slakes	10	40	2188	2	slakes
slates	6	49	3406	2	slates
slaves	9	50	2302	2	slaves
smarms	10	57	1253	2	smarms
smarts	8	62	1800	2	smarts
smazes	17	43	1166	2	smazes
snakes	10	39	1960	2	snakes
snare	5	44	2998	2	snare_
snared	7	48	2455	2	snared
snarer	6	46	2084	2	snarer
snarers	7	42	1666	2	snarers
snarfs	9	51	1342	2	snarfs
snarks	10	48	1573	2	snarks
snarls	6	40	1687	2	snarls
snores	6	43	2431	2	snores
soared	7	43	2429	2	soared
soarer	6	45	2224	2	soarer
soarers	7	41	1809	2	soarers
soars	5	47	3251	2	soar_s
soaves	9	42	1867	2	soaves
sores	5	54	5428	2	s_ores
spaces	10	47	2263	2	spaces
spades	9	42	2258	2	spades
spaes	7	60	2997	2	spa_es
spales	8	47	2810	2	spales
spare	7	51	3556	2	spare_
spared	9	54	2748	2	spared
sparer	8	45	2496	2	sparer
sparers	9	45	1961	2	sparers
sparest	9	46	1642	2	sparest
sparges	10	40	1633	2	sparges
sparks	12	46	1636	2	sparks
spars	7	54	3154	2	spar_s
sparse	8	45	1634	2	sparse
spates	8	50	2817	2	spates
spires	8	46	2811	2	spires
spores	8	47	2661	2	spores
squares	16	37	1445	2	squares
stables	9	32	1907	2	stables
stabs	7	62	2138	2	sta_bs
stacks	12	43	1726	2	stacks
stactes	9	19	1463	2	stactes
stade	6	48	2530	2	stade_
staffs	12	34	975	2	staffs
stage	6	53	3019	2	stage_
staged	8	45	2156	2	staged
stager	7	48	2134	2	stager
stagers	8	41	1667	2	stagers
stagey	10	59	1558	2	stagey
stags	6	62	2674	2	sta_gs
staigs	7	54	1481	2	staigs
stains	6	49	2365	2	stains
stairs	6	54	1633	2	stairs
stake	9	59	2753	2	stake_
staked	11	46	2194	2	staked
stale	5	56	3710	2	stale_
staled	7	47	2810	2	staled
staler	6	40	2582	2	staler
stalest	7	37	2017	2	stalest
stalks	10	46	1455	2	stalks
stalls	6	40	1992	2	stalls
stamen	8	41	1594	2	stamen
stamens	9	34	1148	2	stamens
stamps	10	56	1402	2	stamps
stances	9	37	1596	2	stances
stands	7	51	1805	2	stands
stane	5	59	3300	2	stane_
staned	7	48	2464	2	staned
stangs	7	50	1816	2	stangs
stanks	10	49	1770	2	stanks
staphs	11	44	1103	2	staphs
staples	9	36	1721	2	staples
star	4	80	3776	2	star__
starch	11	30	1320	2	starch
starches	13	19	1291	2	starches
stark	9	54	2562	2	star_k
starker	11	41	1469	2	starker
starkers	12	37	1239	2	starkers
starkest	12	3	972	2	starkest
starless	8	16	1084	2	starless
starlet	7	16	2012	2	starlet
starlets	8	16	1008	2	starlets
starred	8	50	1345	2	starred
starry	9	49	1167	2	starry
start	5	56	4231	2	star_t
started	8	42	1732	2	started
starter	7	38	1787	2	starter
starters	8	37	1476	2	starters
startles	8	21	1196	2	startles
startsy	10	53	670	2	startsy
starve	9	46	1374	2	starve
starved	11	49	1157	2	starved
starver	10	46	1199	2	starver
starvers	11	45	964	2	starvers
stashes	10	39	1616	2	stashes
stasis	6	31	1687	2	stasis
state	5	62	3733	2	state_
stated	7	54	2783	2	stated
stater	6	44	2755	2	stater
staters	7	39	2232	2	staters
stats	5	59	3336	2	sta_ts
statues	7	46	1490	2	statues
statures	8	37	1111	2	statures
status	6	55	1521	2	status
stave	8	53	2499	2	stave_
staved	10	39	1805	2	staved
stayed	10	48	1727	2	stayed
stayer	9	45	1648	2	stayer
stayers	10	38	1363	2	stayers
stays	8	60	2202	2	sta_ys
steers	6	38	2098	2	steers
steles	6	37	2566	2	steles
stere	5	53	2854	2	stere_
stereo	6	53	1791	2	stereo
stereos	7	43	1497	2	stereos
sterns	6	46	1675	2	sterns
sties	5	51	3298	2	st_ies
stiles	6	43	2876	2	stiles
stimes	8	59	2057	2	stimes
stipes	8	45	2405	2	stipes
stirks	10	49	1423	2	stirks
stirpes	9	50	1129	2	stirpes
stirps	8	50	1181	2	stirps
stirs	5	59	2161	2	stir_s
stokes	10	48	2179	2	stokes
stoles	6	39	2767	2	stoles
stones	6	51	3003	2	stones
stopes	8	45	2589	2	stopes
store	5	63	3381	2	store_
stored	7	55	2421	2	stored
storer	6	47	2167	2	storer
storers	7	50	1868	2	storers
storey	9	52	1761	2	storey
storeys	10	55	965	2	storeys
stories	7	3	2427	2	stories
storks	10	61	1593	2	storks
storms	8	58	1460	2	storms
stoures	7	46	1416	2	stoures
stoves	9	38	1892	2	stoves
strafes	10	45	1599	2	strafes
strakes	11	42	1807	2	strakes
straps	8	77	2178	2	straps
strass	6	71	1722	2	strass
straws	9	87	1867	2	straws
strays	9	64	1793	2	strays
strep	7	71	2085	2	st_rep
streps	8	62	1806	2	st_reps
stress	6	66	1667	2	st_ress
strew	8	92	2065	2	st_rew
strews	9	68	1709	2	st_rews
stupes	8	41	1695	2	stupes
sturts	6	39	1514	2	sturts
styes	8	63	1652	2	st_yes
styles	9	44	1865	2	styles
sucres	8	42	1889	2	sucres
sutures	7	3	1422	2	sutures
swages	10	44	1707	2	swages
swales	9	39	2076	2	swales
swards	10	54	1513	2	swards
sware	8	58	2821	2	sware_
swarfs	12	56	1206	2	swarfs
swarms	11	61	1216	2	swarms
tabes	7	60	3392	2	_tabes
taces	7	62	3780	2	_taces
tajes	12	49	2069	2	_tajes
takes	9	44	3779	2	_takes
tales	5	54	5137	2	_tales
tames	7	52	4201	2	_tames
tapes	7	58	3860	2	_tapes
tare	4	59	5762	2	_tare_
tared	6	93	4005	2	_tared
targes	7	45	2459	2	_targes
tarns	5	64	3395	2	_tarns
taros	5	56	4082	2	_taros
tarps	7	65	2711	2	_tarps
tarres	6	47	2304	2	_tarres
tars	4	67	6395	2	_tar_s
tarts	5	72	4202	2	_tarts
tates	5	54	4498	2	_tates
taxes	12	47	3082	2	_taxes
tires	5	54	3749	2	_tires
tores	5	53	5267	2	_tores
tres	4	65	4290	2	_t_res
tsades	7	43	1099	2	tsades
tsars	5	67	1710	2	tsar_s
tsores	6	51	1366	2	tsores
tyres	8	47	2523	2	_tyres
upstares	10	17	858	2	upstares
urares	6	45	1909	2	urares
wares	8	82	5058	2	_wares

Search took 5 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	82551	0.126	1418182.5
2	DLD Change Limit	82551	290	4.296	19215.8
3	Display Results	290	290	0.093	3118.3
	(SQL Overall)	178691	290	4.515	39577.2