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

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

109 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
snorts	6	41	1649	(None)
shorts	9	53	2173	1	shorts
skorts	10	42	1129	1	skorts
snoots	6	42	1666	1	snoots
snores	6	43	2431	1	snores
snort	5	48	3375	1	snort_
snots	5	52	2510	1	sno_ts
snouts	6	49	1586	1	snouts
sorts	5	45	3666	1	s_orts
sports	8	46	1918	1	sports
aborts	8	49	1618	2	aborts
assorts	7	33	1015	2	assorts
borts	7	67	3545	2	_borts
escorts	9	41	840	2	escorts
forts	8	60	3445	2	_forts
inerts	6	45	1702	2	inerts
intorts	7	3	1096	2	intorts
knots	9	56	1472	2	kno_ts
knouts	10	43	831	2	knouts
morts	7	55	3356	2	_morts
nerts	5	59	2498	2	_nerts
noris	5	49	2827	2	_noris
norms	7	60	1930	2	_norms
north	8	60	1827	2	_north
norths	9	68	1232	2	_norths
nowts	8	69	1585	2	_nowts
orts	4	65	3833	2	__orts
ports	7	59	3459	2	_ports
scarts	8	53	2149	2	scarts
scoots	8	53	1593	2	scoots
scores	8	47	2592	2	scores
scorns	8	57	1301	2	scorns
scots	7	40	2590	2	sco_ts
scouts	8	48	1794	2	scouts
senoras	7	27	1495	2	senoras
senores	7	32	1811	2	senores
senors	6	36	2078	2	senor_s
shirts	9	49	1833	2	shirts
shoats	9	41	1707	2	shoats
shoots	9	46	1934	2	shoots
shores	9	48	3040	2	shores
shorls	9	45	1619	2	shorls
short	8	50	4052	2	short_
shorty	12	43	1319	2	shorty
shots	8	47	3083	2	sho_ts
shotts	9	36	1468	2	shotts
shouts	9	40	1771	2	shouts
skirts	10	41	1150	2	skirts
skort	9	49	2563	2	skort_
slots	5	48	3052	2	slo_ts
smarts	8	62	1800	2	smarts
smolts	8	44	1188	2	smolts
snares	6	53	2903	2	snares
snarfs	9	51	1342	2	snarfs
snarks	10	48	1573	2	snarks
snarls	6	40	1687	2	snarls
snits	5	41	2483	2	sn_its
snobs	7	47	1615	2	sno_bs
snogs	6	60	1749	2	sno_gs
snoods	7	43	1244	2	snoods
snooks	10	44	1282	2	snooks
snools	6	57	1587	2	snools
snoops	8	43	1416	2	snoops
snoot	5	50	3013	2	snoot_
snooty	9	42	1150	2	snooty
snore	5	54	2495	2	snor_e
snored	7	48	1954	2	snored
snorer	6	43	1676	2	snorer
snorers	7	43	1379	2	snorers
snorted	8	38	1349	2	snorted
snorter	7	44	1265	2	snorter
snorters	8	34	1056	2	snorters
snot	4	47	4544	2	sno_t_
snotty	9	48	919	2	snotty
snout	5	45	3063	2	snout_
snouty	9	41	995	2	snouty
snows	8	47	1988	2	sno_ws
softs	8	50	1923	2	s_ofts
soots	5	55	3620	2	s_oots
soras	5	50	4101	2	s_oras
sorbs	7	50	2210	2	s_orbs
sords	6	45	2780	2	s_ords
sores	5	54	5428	2	s_ores
sorns	5	50	2841	2	s_orns
sort	4	62	6481	2	s_ort_
sorta	5	71	2541	2	s_orta
sorus	5	45	2758	2	s_orus
sots	4	55	5244	2	s_o_ts
spirts	8	53	1713	2	spirts
spores	8	47	2661	2	spores
sport	7	59	3598	2	sport_
sporty	11	51	1249	2	sporty
spots	7	44	2410	2	spo_ts
spouts	8	51	1511	2	spouts
spurts	8	48	1497	2	spurts
starts	6	54	2312	2	starts
stoats	6	51	1748	2	stoats
stores	6	55	3364	2	stores
storks	10	61	1593	2	storks
storms	8	58	1460	2	storms
stots	5	48	2854	2	sto_ts
stotts	6	46	1285	2	stotts
stouts	6	50	1900	2	stouts
sturts	6	39	1514	2	sturts
swords	10	45	1079	2	swords
swots	8	55	1842	2	swo_ts
torts	5	61	3812	2	_torts
whorts	12	51	1143	2	whorts
worts	8	86	3118	2	_worts

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.233	766914.2
2	DLD Change Limit	82551	109	4.983	16566.5
3	Display Results	109	109	0.080	1362.5
	(SQL Overall)	178691	109	5.296	33740.7