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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

235 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
submit	10	3	1267	(None)
submits	11	3	975	1	submits
summit	10	3	1154	1	summit
cubit	9	41	2289	2	cub_it
qubit	16	42	1899	2	qub_it
resubmit	12	4	357	2	resubmit
smit	6	51	3841	2	s__mit
sobeit	8	3	1536	2	sobeit
subedit	10	4	940	2	subedit
subfix	18	3	507	2	subfix
subito	8	4	1045	2	sub_ito
sublet	8	28	2724	2	sublet
sublimit	12	4	751	2	sublimit
sublot	8	23	1552	2	sublot
submiss	11	3	808	2	submiss
subnet	8	25	2093	2	subnet
subset	8	31	2258	2	subset
subsist	9	3	1157	2	subsist
subsite	9	4	1287	2	subsite
subunit	9	4	895	2	subunit
suit	4	56	4987	2	su__it
summits	11	3	798	2	summits
sunlit	6	15	1610	2	sunlit
admit	8	3	1949	3	_admit
albeit	8	3	1434	3	albeit
ambit	9	42	2371	3	amb_it
audit	6	25	2788	3	au_dit
bait	6	65	5600	3	__bait
bit	5	70	7090	3	__b_it
brit	6	63	5015	3	__brit
commit	12	40	1670	3	commit
cubic	11	43	1342	3	cub_ic
cubist	10	42	1444	3	cubist
cubiti	10	39	908	3	cub_iti
cubits	10	37	1403	3	cub_its
cuboid	11	3	950	3	cuboid
cumbia	12	37	989	3	cumbia
cumin	9	46	1697	3	cu_min
cummin	12	8	878	3	cummin
dammit	11	3	1113	3	dammit
debit	8	57	2785	3	deb_it
demit	8	48	3230	3	_demit
dubbin	11	32	926	3	dubbin
duit	5	62	4158	3	du__it
duomi	8	3	1013	3	duomi_
emit	6	54	3842	3	__emit
fumet	10	56	3022	3	fu_met
furmity	15	3	518	3	furmity
gambit	11	47	1421	3	gambit
gummite	12	3	613	3	gummite
habit	10	30	2702	3	hab_it
hermit	11	5	1944	3	hermit
hobbit	13	28	1054	3	hobbit
hubris	11	21	897	3	hubris
humic	12	41	1324	3	hu_mic
humid	11	42	1376	3	hu_mid
limit	7	31	2634	3	_limit
lubric	10	9	798	3	lubric
muskit	12	28	1325	3	muskit
nubbin	10	30	829	3	nubbin
nubia	7	3	1123	3	nub_ia
numbat	10	3	1208	3	numbat
obit	6	68	3708	3	_ob_it
omit	6	53	3737	3	__omit
orbit	7	36	2206	3	orb_it
outfit	9	30	1495	3	outfit
outhit	9	28	1847	3	outhit
outsit	6	36	2089	3	outsit
outwit	9	30	1459	3	outwit
permit	10	3	2168	3	permit
pubic	11	45	1372	3	pub_ic
pubis	9	46	1647	3	pub_is
public	12	23	814	3	public
pulpit	10	3	1093	3	pulpit
pundit	9	29	1418	3	pundit
qubits	17	37	1035	3	qub_its
quit	13	61	3651	3	qu__it
quoit	14	38	1986	3	qu_oit
rabbit	10	29	1456	3	rabbit
rebait	8	3	2040	3	rebait
reemit	8	7	1722	3	reemit
remit	7	57	3722	3	_remit
resubmits	13	4	279	3	resubmits
rubati	8	29	969	3	rubati
rubout	8	3	1356	3	rubout
rubric	10	9	782	3	rubric
sabbat	10	3	1471	3	sabbat
sabin	7	49	2495	3	sab_in
sabir	7	59	1700	3	sab_ir
sabot	7	9	3178	3	sab_ot
saimin	8	3	1366	3	saimin
salmi	7	8	1586	3	salmi_
salmis	8	5	1427	3	salmis
samite	8	30	2060	3	s_amite
schuit	11	3	956	3	schuit
semi	6	51	2722	3	s_emi_
semis	7	46	2353	3	s_emis
sennit	6	31	1792	3	sennit
shit	7	67	4594	3	s__hit
sit	3	58	7775	3	s___it
skit	8	54	3753	3	s__kit
skylit	13	3	828	3	skylit
slit	4	62	5010	3	s__lit
smite	7	52	2487	3	s__mite
smith	10	78	1805	3	s__mith
smut	6	66	2978	3	s__mut
snit	4	63	4247	3	s__nit
soffit	12	3	788	3	soffit
somite	8	45	1937	3	s_omite
spait	7	56	3160	3	s_pait
spirit	8	35	1992	3	spirit
spit	6	55	4508	3	s__pit
split	7	57	2901	3	s_plit
sprit	7	67	3640	3	s_prit
strait	6	40	2589	3	strait
stymie	11	3	762	3	stymie
suavity	13	3	631	3	suavity
sub	5	54	4555	3	sub___
suba	6	49	2660	3	sub__a
subacid	12	4	847	3	subacid
subah	10	60	1521	3	sub_ah
subahs	11	45	1238	3	subahs
subarid	10	3	1065	3	subarid
subas	7	47	2407	3	sub_as
subbed	11	41	1667	3	subbed
subbing	12	39	1558	3	subbing
subcult	11	4	960	3	subcult
subdeb	11	3	752	3	subdeb
subduct	12	10	758	3	subduct
subdue	9	12	849	3	subdue
subedits	11	4	671	3	subedits
suber	7	49	2450	3	sub_er
suberic	11	3	1221	3	suberic
suberin	9	3	1456	3	suberin
subers	8	57	2264	3	subers
subfile	12	20	1050	3	subfile
subgum	11	3	613	3	subgum
subhumid	16	4	283	3	subhumid
subitem	11	3	855	3	sub_item
subject	18	25	863	3	subject
subjoin	16	4	544	3	subjoin
sublate	9	3	1536	3	sublate
sublets	9	26	1670	3	sublets
sublime	11	3	1036	3	sublime
sublimits	13	4	556	3	sublimits
sublimity	16	4	493	3	sublimity
subline	9	3	1689	3	subline
sublots	9	24	1091	3	sublots
submenu	11	4	836	3	submenu
submittal	13	4	388	3	submittal
submitted	14	4	523	3	submitted
submitter	13	4	528	3	submitter
subnets	9	25	1208	3	subnets
suborn	8	3	1001	3	suborn
subpar	10	4	866	3	subpar
subpart	11	3	1112	3	subpart
subplot	11	5	813	3	subplot
subrent	9	3	1508	3	subrent
subring	10	41	1626	3	subring
subs	6	60	3712	3	sub__s
subsea	8	26	1019	3	subsea
subsect	11	26	1184	3	subsect
subsets	9	28	1310	3	subsets
subside	10	4	1045	3	subside
subsidy	13	4	597	3	subsidy
subsists	10	3	799	3	subsists
subsites	10	3	1278	3	subsites
subsoil	9	6	729	3	subsoil
subtest	9	5	1396	3	subtest
subtext	16	4	765	3	subtext
subtile	9	19	1262	3	subtile
subtilty	13	4	545	3	subtilty
subtitle	10	4	660	3	subtitle
subtle	8	21	1343	3	subtle
subtly	11	24	926	3	subtly
subunits	10	4	662	3	subunits
suburb	10	3	716	3	suburb
subvert	12	3	1289	3	subvert
subway	14	4	707	3	subway
suet	4	67	5482	3	su__et
suffix	19	3	523	3	suffix
suint	5	56	3818	3	su_int
suite	5	48	2956	3	su__ite
suits	5	50	2805	3	su__its
sukkot	9	3	664	3	sukkot
sulci	7	6	1505	3	sulci_
sulfid	10	3	906	3	sulfid
sulfite	10	3	1047	3	sulfite
sum	5	63	4601	3	su_m__
sumac	9	95	1488	3	su_mac
summa	9	47	1331	3	su_mma
summae	10	39	1101	3	summae
summas	10	43	1316	3	summas
summate	11	36	1166	3	summate
summed	11	40	1404	3	summed
summer	10	40	1771	3	summer
summing	12	29	1238	3	summing
summital	12	4	470	3	summital
summited	13	24	641	3	summited
summitry	15	4	332	3	summitry
summon	10	3	762	3	summon
sumo	6	73	2631	3	su_m_o
sumoist	9	3	1161	3	sumoist
sumos	7	57	2009	3	su_mos
sump	8	63	3153	3	su_m_p
sumps	9	50	2343	3	su_mps
sums	6	58	3758	3	su_m_s
sunbelt	9	3	923	3	sunbelt
sunket	10	37	2136	3	sunket
sunset	6	37	2363	3	sunset
sunsuit	7	4	869	3	sunsuit
surest	6	50	2676	3	surest
surfeit	10	3	1034	3	surfeit
surimi	8	3	910	3	surimi
surimis	9	3	884	3	surimis
surmise	9	3	1108	3	surmise
sushi	8	3	1049	3	sushi_
sushis	9	3	1118	3	sushis
suslik	10	3	637	3	suslik
swami	10	56	1452	3	swami_
swamis	11	42	1229	3	swamis
symbiot	14	6	527	3	symbiot
tubaist	9	3	870	3	tubaist
tubist	8	30	1316	3	tubist
tumid	8	41	1402	3	tu_mid
turbit	8	7	1511	3	turbit
unfit	8	45	1856	3	_unfit
unit	4	51	4007	3	_u_nit
unlit	5	50	2546	3	_unlit
unmet	7	44	2639	3	_unmet
unmix	14	38	897	3	_unmix
unmixt	15	37	870	3	_unmixt
unwit	8	44	1752	3	_unwit
uplit	7	60	2080	3	_uplit
vomit	10	26	2257	3	_vomit

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	112716	0.373	479064.3
2	DLD Change Limit	112716	235	4.766	23650.0
3	Display Results	235	235	0.076	3092.1
	(SQL Overall)	178691	235	5.215	34264.8