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

Here are the results of your fuzzy-string dictionary search for “styles” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

98 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
styles	9	44	1865	(None)
stales	6	55	3829	1	stales
steles	6	37	2566	1	steles
stiles	6	43	2876	1	stiles
stoles	6	39	2767	1	stoles
styes	8	63	1652	1	sty_es
style	8	55	1936	1	style_
styled	10	56	1310	1	styled
styler	9	40	1330	1	styler
stylers	10	35	934	1	stylers
stylet	9	40	1857	1	stylet
stylets	10	36	921	1	stylets
stylus	9	39	746	1	stylus
chyles	14	48	1328	2	chyles
hoyles	12	3	1501	2	hoyles
istles	6	28	1498	2	ist_les
kayles	13	47	1200	2	kayles
odyles	10	34	856	2	odyles
restyles	11	3	919	2	restyles
sables	8	50	2669	2	sables
sales	5	60	5559	2	s_ales
scales	8	45	2931	2	scales
selles	6	44	2698	2	selles
settles	7	39	1600	2	settles
shales	9	47	3125	2	shales
sidles	7	47	2115	2	sidles
slypes	11	44	1048	2	slypes
smiles	8	45	2229	2	smiles
snyes	8	50	1275	2	sny_es
socles	8	4	1845	2	socles
soles	5	55	4792	2	s_oles
spales	8	47	2810	2	spales
spiles	8	42	2791	2	spiles
stables	9	32	1907	2	stables
stades	7	46	2624	2	stades
stages	7	56	2949	2	stages
stakes	10	39	2729	2	stakes
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
stanes	6	49	3340	2	stanes
stapes	8	50	2873	2	stapes
staples	9	36	1721	2	staples
stares	6	60	3875	2	stares
stases	6	42	2556	2	stases
states	6	43	3708	2	states
staves	9	45	2519	2	staves
steels	6	41	1798	2	steels
stele	5	50	2684	2	stele_
steres	6	39	2953	2	steres
sties	5	51	3298	2	st_ies
stifles	10	30	1338	2	stifles
stile	5	49	3157	2	stile_
stills	6	41	1856	2	stills
stilts	6	79	1530	2	stilts
stimes	8	59	2057	2	stimes
stipes	8	45	2405	2	stipes
stokes	10	48	2179	2	stokes
stole	5	49	2881	2	stole_
stoled	7	45	2159	2	stoled
stolen	6	43	1506	2	stolen
stones	6	51	3003	2	stones
stopes	8	45	2589	2	stopes
stores	6	55	3364	2	stores
stoves	9	38	1892	2	stoves
stulls	6	39	1297	2	stulls
stupes	8	41	1695	2	stupes
stye	7	62	1897	2	sty_e_
styed	9	58	1548	2	sty_ed
stylar	9	35	811	2	stylar
styli	8	39	1117	2	styl_i
stylise	10	20	895	2	stylise
stylises	11	18	894	2	stylises
stylish	13	19	744	2	stylish
stylist	10	21	1028	2	stylist
stylites	11	16	869	2	stylites
stylizes	20	20	711	2	stylizes
styluses	11	20	477	2	styluses
stymies	12	3	921	2	stymies
swales	9	39	2076	2	swales
syces	10	64	1646	2	s_yces
sykes	12	48	1686	2	s_ykes
sylis	8	43	1602	2	s_ylis
tales	5	54	5137	2	_tales
teles	5	45	3600	2	_teles
tiles	5	55	4210	2	_tiles
toles	5	51	4713	2	_toles
tules	5	45	3279	2	_tules
tyees	8	60	1945	2	_tyees
tyes	7	64	3337	2	_ty_es
tykes	12	58	1706	2	_tykes
tynes	8	59	2030	2	_tynes
types	10	57	2106	2	_types
tyres	8	47	2523	2	_tyres
wyles	11	46	1532	2	_wyles

Search took 6 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.110	1624463.6
2	DLD Change Limit	82551	98	5.313	15537.5
3	Display Results	98	98	0.060	1633.3
	(SQL Overall)	178691	98	5.483	32590.0