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

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

75 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
superfan	13	4	745	(None)
superfans	14	4	816	1	superfans
superman	12	3	1023	1	superman
superbad	13	4	726	2	superbad
superbank	17	4	638	2	superbank
supercar	12	4	900	2	supercar
superfarm	16	8	613	2	superfarm
superfast	14	4	854	2	superfast
superfine	14	4	1144	2	superfine
superfix	20	4	546	2	superfix
superfund	15	4	567	2	superfund
superlain	11	4	899	2	superlain
superlay	13	4	775	2	superlay
supermen	12	3	1130	2	supermen
supernal	10	3	987	2	supernal
supertax	17	4	597	2	supertax
sierran	7	3	719	3	s_ierran
spartan	9	4	833	3	s_partan
spean	7	46	2051	3	s_pe__an
spearman	12	4	494	3	s_pearman
spelean	9	3	712	3	s_pelean
sporran	9	3	674	3	s_porran
suberin	9	3	1456	3	suber_in
suburban	12	4	445	3	suburban
super	7	49	2448	3	super___
superadd	12	4	665	3	superadd
superb	10	44	1099	3	super__b
superbanks	18	4	598	3	superbanks
superber	12	3	969	3	superber
superbly	15	4	698	3	superbly
superbug	13	4	533	3	superbug
supercars	13	4	1014	3	supercars
superclean	14	4	540	3	superclean
supercop	14	4	646	3	supercop
supered	10	3	1612	3	super_ed
superego	11	4	607	3	superego
superfarms	17	7	538	3	superfarms
superfirm	16	7	620	3	superfirm
superflack	21	5	334	3	superflack
superfunds	16	4	491	3	superfunds
supergene	12	5	1023	3	supergene
supergiant	13	4	856	3	supergiant
superheat	14	4	1089	3	superheat
superhit	13	4	1050	3	superhit
superhot	13	4	1022	3	superhot
superhuman	17	5	377	3	superhuman
supering	11	3	1768	3	supering
superior	10	3	1088	3	superior
superjet	17	4	1178	3	superjet
superlie	10	3	1212	3	superlie
superlong	12	4	728	3	superlong
supermale	13	4	998	3	supermale
supermind	14	4	904	3	supermind
supermini	13	4	895	3	supermini
supermom	14	4	699	3	supermom
supernate	11	3	1327	3	supernate
superplane	14	4	720	3	superplane
superpro	12	13	611	3	superpro
superrace	13	4	948	3	superrace
superreal	11	4	777	3	superreal
superroad	12	4	674	3	superroad
supers	8	46	2240	3	super__s
supersafe	14	4	845	3	supersafe
supersale	11	4	1132	3	supersale
supersaur	11	10	715	3	supersaur
supersex	17	3	842	3	supersex
superspy	15	4	500	3	superspy
superstar	11	4	757	3	superstar
superthin	14	4	683	3	superthin
supervene	14	6	944	3	supervene
superwave	17	4	677	3	superwave
superwoman	17	4	528	3	superwoman
supra	7	36	1425	3	sup_r_a_
surfman	12	3	620	3	su__rfman
suzerain	17	4	576	3	suzerain

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	75	6.640	22012.3
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	7.079	25242.4