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

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

80 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
undersign	11	7	711	(None)
undersigns	12	6	583	1	undersigns
underling	11	15	1461	2	underling
underpin	11	3	884	2	underpi_n
underside	11	3	1014	2	underside
undersigned	14	11	497	2	undersigned
undersize	19	4	951	2	undersize
undersong	11	4	799	2	undersong
underspin	12	4	665	2	underspin
underusing	12	4	726	2	underusing
underwing	14	14	1088	2	underwing
codesign	12	7	450	3	code_sign
countersign	14	4	724	3	countersign
deraign	9	3	657	3	__deraign
design	8	40	893	3	__de_sign
endorsing	11	4	730	3	endorsing
indorsing	11	3	714	3	indorsing
inversing	13	8	962	3	inversing
inversion	12	4	721	3	inversion
outdesign	11	4	251	3	outde_sign
redesign	10	4	507	3	rede_sign
sundering	11	3	1232	3	sunder_ing
unbenign	11	4	253	3	unbe_nign
unceasing	12	3	965	3	unceasing
undaring	10	4	1275	3	undar_ing
underage	10	10	1227	3	under_age
underbid	12	10	820	3	underbi_d
underbids	13	13	724	3	underbids
underbite	12	4	981	3	underbite
underdid	11	12	813	3	underdi_d
underdog	11	4	535	3	underdog_
underdogs	12	4	575	3	underdogs
underdoing	13	4	680	3	underdoing
underdosing	14	4	449	3	underdosing
undergird	12	4	590	3	undergird
undergirt	11	4	781	3	undergirt
undergo	9	3	704	3	under__go
undergoing	13	4	708	3	undergoing
underhung	14	4	518	3	underhung
underkill	14	4	507	3	underkill
underlain	10	4	868	3	underlain
underlie	9	14	1312	3	underli_e
underlies	10	14	1420	3	underlies
underline	10	17	1467	3	underline
underlings	12	17	814	3	underlings
underlip	11	15	720	3	underli_p
underlips	12	14	767	3	underlips
underlit	9	13	1153	3	underli_t
underlying	15	13	637	3	underlying
undermine	12	20	1223	3	undermine
underpins	12	3	973	3	underpins
underran	9	4	842	3	under_ran
underripe	12	4	783	3	underripe
underrun	9	8	681	3	under_run
undersea	9	14	988	3	unders_ea
underseas	10	8	780	3	underseas
undersell	10	4	576	3	undersell
underset	9	14	1713	3	unders_et
undersets	10	12	932	3	undersets
undershirt	14	4	645	3	undershirt
undershot	13	4	689	3	undershot
undersides	12	4	869	3	undersides
undersigning	15	5	346	3	undersigning
undersized	21	4	821	3	undersized
underskirt	15	4	502	3	underskirt
underslung	12	4	379	3	underslung
undersoil	10	5	677	3	undersoil
undersoils	11	5	606	3	undersoils
undersold	11	4	688	3	undersold
undersongs	12	4	533	3	undersongs
underspins	13	4	683	3	underspins
understand	12	4	618	3	understand
undertint	10	4	1486	3	undertint
underwings	15	14	640	3	underwings
underwire	13	4	812	3	underwire
undressing	12	4	653	3	undressing
unerring	9	3	1127	3	un_erring
unhorsing	13	3	685	3	unhorsing
unnerving	13	3	663	3	unnerving
unperson	10	4	638	3	unpers_on

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	148641	0.406	440125.6
2	DLD Change Limit	148641	80	6.780	21923.5
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	7.219	24752.9