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

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

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.

90 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
underskirts	16	5	320	(None)
undershirts	15	5	412	1	undershirts
underskirt	15	4	502	1	underskirt_
undershirt	14	4	645	2	undershirt_
undershorts	15	4	369	2	undershorts
overskirts	17	4	371	3	_overskirts
undergirds	13	4	445	3	under_girds
undergirt	11	4	781	3	under_girt_
underhairs	14	4	545	3	underhair_s
underkills	15	4	380	3	under_kills
underparts	13	4	611	3	under_parts
underscores	14	4	537	3	underscores
undersets	10	12	932	3	unders__ets
undershirted	17	5	347	3	undershirted
undershoots	15	5	345	3	undershoots
undersides	12	4	869	3	unders_ides
undersigns	12	6	583	3	unders_igns
undersoils	11	5	606	3	undersoi_ls
underspins	13	4	683	3	underspi_ns
undertints	11	4	828	3	under_tints
underwires	14	4	702	3	under_wires
midiskirts	17	5	113	4	mid_iskirts
overshirts	16	4	478	4	_overshirts
overskirt	16	4	621	4	_overskirt_
underacts	12	4	858	4	under__acts
underarms	12	4	673	4	under__arms
underbids	13	13	724	4	under_bi_ds
underbite	12	4	981	4	under_bi_te
underbites	13	4	789	4	under_bites
underbrims	15	4	406	4	underbri_ms
undercards	14	4	556	4	under_cards
undercoats	13	4	662	4	under_coats
undercounts	14	4	409	4	undercounts
undercrofts	17	15	330	4	undercrofts
undercuts	12	4	664	4	under__cuts
undereats	10	3	1022	4	under__eats
underfurs	13	5	549	4	under_fur_s
undergird	12	4	590	4	under_gir_d
undergoers	12	4	500	4	undergoer_s
underhair	13	4	573	4	underhair__
underheats	14	4	605	4	under_heats
underkill	14	4	507	4	under_ki_ll
underlets	10	15	889	4	under__lets
underlies	10	14	1420	4	under_li_es
underlines	11	15	1211	4	under_lines
underlings	12	17	814	4	under_lings
underlips	12	14	767	4	under_li_ps
underlit	9	13	1153	4	under_li_t_
undermines	13	17	1066	4	under_mines
underpants	13	4	691	4	under_pants
underpart	12	8	851	4	under_part_
underpins	12	3	973	4	under_pi_ns
underplots	13	4	540	4	under_plots
underprices	16	4	472	4	underprices
underreacts	14	5	302	4	underreacts
underreports	15	7	177	4	underreports
underscore	13	4	580	4	underscor_e
underscored	15	4	514	4	underscored
underseas	10	8	780	4	unders__eas
undersells	11	4	473	4	unders_ells
underset	9	14	1713	4	unders__et_
undershoot	14	4	510	4	undershoot_
undershot	13	4	689	4	unders_hot_
undershrub	16	10	268	4	unders_hrub
undershrubs	17	10	213	4	undershrubs
underside	11	3	1014	4	unders_i_de
undersign	11	7	711	4	unders_i_gn
undersize	19	4	951	4	unders_i_ze
undersized	21	4	821	4	unders_ized
undersoil	10	5	677	4	undersoi__l
undersongs	12	4	533	4	unders_ongs
underspin	12	4	665	4	underspi__n
understands	13	4	465	4	understands
understate	11	4	886	4	unders_tate
understates	12	4	770	4	understates
understeers	12	5	376	4	understeers
understories	13	6	556	4	understories
understory	14	4	512	4	understor_y
undertakers	16	4	381	4	undertaker_s
undertakings	18	9	403	4	undertakings
undertint	10	4	1486	4	under_tint_
undertricks	18	7	301	4	undertricks
undervests	14	6	474	4	under_vests
underweights	20	5	235	4	underweights
underwings	15	14	640	4	under_wings
underwire	13	4	812	4	under_wir_e
underworks	18	4	571	4	under_works
underwrite	14	4	631	4	underwri_te
underwrites	15	4	518	4	underwrites
undesired	11	4	752	4	unde_s_ired

Search took 10 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	148819	0.436	409841.7
2	DLD Change Limit	148819	90	8.596	17312.6
3	Display Results	90	90	0.046	1956.5
	(SQL Overall)	178691	90	9.078	19684.0