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

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

74 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
subunit	9	4	895	(None)
subunits	10	4	662	1	subunits
subedit	10	4	940	2	subedit
submit	10	3	1267	2	sub_mit
subnet	8	25	2093	2	sub_net
subtunic	12	4	426	2	subtunic
autunite	8	5	669	3	autunite
binit	7	64	3158	3	__binit
bubonic	13	6	624	3	bubonic
bundt	8	58	2485	3	__bundt
bunt	6	58	5085	3	__bun_t
cubit	9	41	2289	3	cub__it
qubit	16	42	1899	3	qub__it
schuit	11	3	956	3	schu_it
sennit	6	31	1792	3	s_ennit
shunt	8	52	2651	3	s_hun_t
snit	4	63	4247	3	s___nit
sobeit	8	3	1536	3	sob_eit
squint	15	42	1479	3	s_quint
strunt	6	49	1891	3	strun_t
stunt	5	53	2817	3	s_tun_t
subacid	12	4	847	3	subacid
subarid	10	3	1065	3	subarid
subbing	12	39	1558	3	subbing
subcult	11	4	960	3	subcult
subcutis	12	4	629	3	subcutis
subduct	12	10	758	3	subduct
subduing	12	3	582	3	subduing
subedits	11	4	671	3	subedits
suberic	11	3	1221	3	suberic
suberin	9	3	1456	3	suberin
subfix	18	3	507	3	sub_fix
subhumid	16	4	283	3	subhumid
subito	8	4	1045	3	sub__ito
subject	18	25	863	3	subject
subjoin	16	4	544	3	subjoin
sublet	8	28	2724	3	sub_let
sublimit	12	4	751	3	sublimit
subline	9	3	1689	3	subline
sublot	8	23	1552	3	sub_lot
sublunar	10	4	410	3	sublunar
submits	11	3	975	3	sub_mits
subnets	9	25	1208	3	sub_nets
subpart	11	3	1112	3	subpart
subplot	11	5	813	3	subplot
subpubic	16	4	307	3	subpubic
subrent	9	3	1508	3	subrent
subring	10	41	1626	3	subring
subsect	11	26	1184	3	subsect
subset	8	31	2258	3	sub_set
subsist	9	3	1157	3	subsist
subsite	9	4	1287	3	sub_site
subsoil	9	6	729	3	subsoil
subsonic	12	4	575	3	subsonic
subtest	9	5	1396	3	subtest
subtext	16	4	765	3	subtext
subtonic	12	4	692	3	subtonic
subtunics	13	4	335	3	subtunics
subulate	10	3	1274	3	subulate
suburb	10	3	716	3	subu_rb
suburbia	12	4	396	3	suburbia
suburbs	11	3	650	3	suburbs
subvert	12	3	1289	3	subvert
suint	5	56	3818	3	su_in_t
suit	4	56	4987	3	s__u_it
summit	10	3	1154	3	su_mmit
sunburnt	10	4	560	3	sunburnt
sunburst	10	4	518	3	sunburst
sunlit	6	15	1610	3	su_nlit
sunsuit	7	4	869	3	sunsuit
surfeit	10	3	1034	3	surfeit
tubulin	9	11	643	3	tubulin
unit	4	51	4007	3	___unit
unknit	10	6	859	3	_unknit

Search took 7 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	134027	0.390	458182.1
2	DLD Change Limit	134027	74	6.030	22226.7
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	6.450	27704.0