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

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

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.

83 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
sporrans	10	4	552	(None)
sporran	9	3	674	1	sporran_
shorans	10	28	1241	2	sho_rans
sovrans	10	3	648	2	s_ovrans
aporias	9	3	1515	3	aporia_s
corbans	11	3	1317	3	_corbans
corrals	9	37	1385	3	_corrals
currans	9	3	1061	3	_currans
jordans	15	6	683	3	_jordans
lorans	6	51	1760	3	_lo_rans
morgans	10	3	1012	3	_morgans
organs	7	9	1291	3	__organs
parians	9	35	1973	3	_parians
parrals	9	44	1457	3	_parrals
partans	9	44	1828	3	_partans
perrons	9	31	1548	3	_perrons
porns	7	55	2734	3	_po_r_ns
portals	9	40	1556	3	_portals
portrays	13	4	529	3	_portrays
prolans	9	3	1427	3	_prolans
pyrans	11	4	1106	3	_p_yrans
sarans	6	42	2443	3	s__arans
saurians	8	3	776	3	saurians
scorns	8	57	1302	3	sco_r_ns
serrano	7	6	846	3	s_errano
serranos	8	5	787	3	s_erranos
shoran	9	40	1604	3	sho_ran_
shortens	11	28	899	3	shortens
sierran	7	3	719	3	sierran_
sierras	7	3	786	3	sierra_s
sirrahs	10	37	730	3	s_irrahs
sirras	6	38	1486	3	s_irra_s
slogans	8	40	798	3	slo_gans
solans	6	41	2249	3	s_o_lans
soldans	8	32	1040	3	s_oldans
somans	8	46	1930	3	s_o_mans
soprani	9	3	740	3	s_oprani
soprano	9	3	700	3	s_oprano
sopranos	10	4	643	3	s_opranos
soras	5	50	4101	3	s_o_ra_s
sorns	5	50	2842	3	s_o_r_ns
sorrels	7	3	1072	3	s_orrels
sorrows	10	27	840	3	s_orrows
soudans	8	30	935	3	s_oudans
sovran	9	3	715	3	s_ovran_
sowans	9	42	1589	3	s_o_wans
spans	7	45	2873	3	sp___ans
sparring	11	31	1222	3	sparring
sparrows	13	4	480	3	sparrows
spartan	9	4	833	3	spartan_
speans	8	54	1714	3	sp__eans
spirals	9	32	1251	3	sp_irals
spirant	9	8	1429	3	sp_irant
spirants	10	8	828	3	sp_irants
spireas	9	44	1251	3	spirea_s
spongins	11	3	656	3	spongins
sponsons	10	4	581	3	sponsons
spoons	8	41	1602	3	spo__ons
spooring	11	31	1146	3	spooring
spoors	8	40	1403	3	spoor__s
sporal	8	29	1545	3	spo_ra_l
spores	8	47	2661	3	spo_r_es
sporing	10	43	1941	3	spo_ring
sporozoans	21	12	276	3	sporozoans
sporters	10	37	1406	3	sporters
sporting	11	24	1546	3	sporting
sports	8	46	1918	3	spo_r_ts
sporules	10	3	770	3	sporules
spousals	10	6	435	3	spousals
sprags	9	57	1582	3	sp__rags
sprains	9	30	1359	3	sp_rains
sprang	9	57	1352	3	sp__rang
sprangs	10	46	1005	3	sp__rangs
sprats	8	58	1993	3	sp__rats
sprays	11	59	1364	3	sp__rays
spreads	10	3	976	3	sp_reads
spurns	8	48	1138	3	sp_ur_ns
spurrers	10	33	846	3	spurrers
spurreys	13	36	460	3	spurreys
spurries	10	23	1132	3	spurries
spurring	11	33	976	3	spurring
superfans	14	4	816	3	superfans
surras	6	59	1953	3	s_urra_s

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	146162	0.406	440125.6
2	DLD Change Limit	146162	83	7.000	20880.3
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	7.436	24030.5