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

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

103 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
stilts	6	79	1531	(None)
silts	5	53	3082	1	s_ilts
stiles	6	43	2877	1	stiles
stills	6	41	1857	1	stills
stilt	5	48	3198	1	stilt_
stints	6	51	1976	1	stints
tilts	5	53	2561	1	_tilts
atilt	5	48	2847	2	atilt_
gilts	6	49	2426	2	_gilts
guilts	7	41	1123	2	guilts
hilts	8	69	2441	2	_hilts
jilts	12	47	1741	2	_jilts
kilts	9	51	2219	2	_kilts
lilts	5	58	2280	2	_lilts
milts	7	54	3071	2	_milts
quilts	15	41	1254	2	quilts
sails	5	57	3810	2	sail_s
saints	6	51	2242	2	saints
salts	5	54	3188	2	s_alts
saults	6	58	1617	2	saults
shifts	12	44	1294	2	shifts
shills	9	45	1961	2	shills
shirts	9	49	1834	2	shirts
shists	9	65	1511	2	shists
shits	8	47	3117	2	shi_ts
sifts	8	49	1892	2	s_ifts
silds	6	55	2053	2	s_ilds
silks	9	46	2068	2	s_ilks
sills	5	51	3599	2	s_ills
silos	5	60	2943	2	s_ilos
silt	4	65	5820	2	s_ilt_
silty	8	47	2163	2	s_ilty
sits	4	50	5021	2	s_i_ts
skills	10	43	1392	2	skills
skirts	10	41	1150	2	skirts
skits	9	47	2187	2	ski_ts
slits	5	61	2885	2	sli_ts
smalts	8	52	1489	2	smalts
smelts	8	54	1277	2	smelts
smiles	8	45	2229	2	smiles
smolts	8	44	1188	2	smolts
snits	5	41	2483	2	sni_ts
soils	5	53	2798	2	soil_s
spelts	8	46	1464	2	spelts
spiles	8	42	2791	2	spiles
spills	8	47	1746	2	spills
spilt	7	55	3222	2	spilt_
spilth	11	46	973	2	spilth
spilths	12	35	602	2	spilths
spirts	8	53	1713	2	spirts
spits	7	44	2955	2	spi_ts
splits	8	54	1641	2	splits
stales	6	55	3829	2	stales
stalks	10	46	1455	2	stalks
stalls	6	40	1993	2	stalls
starts	6	54	2312	2	starts
stats	5	59	3336	2	st_ats
steles	6	37	2566	2	steles
stents	6	50	1945	2	stents
stets	5	54	2391	2	st_ets
stichs	11	45	1165	2	stichs
sticks	12	51	1861	2	sticks
sties	5	51	3298	2	sti_es
stiffs	12	38	996	2	stiffs
stifles	10	30	1339	2	stifles
stile	5	49	3157	2	stil_e
still	5	49	2208	2	stil_l
stilly	9	37	1409	2	stilly
stilted	8	35	1147	2	stilted
stimes	8	59	2057	2	stimes
stings	7	62	2018	2	stings
stinks	10	56	1683	2	stinks
stint	5	70	3766	2	stint_
stipes	8	45	2405	2	stipes
stirks	10	49	1424	2	stirks
stirps	8	50	1182	2	stirps
stirs	5	59	2162	2	sti_rs
stoats	6	51	1748	2	stoats
stoles	6	39	2767	2	stoles
stots	5	48	2855	2	st_ots
stotts	6	46	1286	2	stotts
stouts	6	50	1900	2	stouts
struts	6	56	1680	2	struts
stulls	6	39	1298	2	stulls
stunts	6	56	1525	2	stunts
sturts	6	39	1514	2	sturts
styles	9	44	1865	2	styles
stylets	10	36	921	2	stylets
stylus	9	39	746	2	stylus
suints	6	46	1778	2	suints
suits	5	50	2805	2	sui_ts
swifts	12	40	817	2	swifts
swills	9	42	1336	2	swills
tiles	5	55	4210	2	_tiles
tills	5	46	3171	2	_tills
tils	4	57	3962	2	_til_s
tilt	4	62	5243	2	_tilt_
tilth	8	55	1536	2	_tilth
tilths	9	45	937	2	_tilths
tints	5	60	3092	2	_tints
tits	4	61	4505	2	_ti_ts
uptilts	9	3	473	2	uptilts
wilts	8	50	2350	2	_wilts

Search took 8 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.703	254183.5
2	DLD Change Limit	82551	103	6.656	12402.5
3	Display Results	103	103	0.033	3121.2
	(SQL Overall)	178691	103	7.392	24173.6