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

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

71 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
underfoot	13	4	703	(None)
tenderfoot	14	5	278	2	tenderfoot
undercoat	12	4	873	2	undercoat
undercook	16	4	492	2	undercook
undercool	12	4	553	2	undercool
underflow	16	4	394	2	underflow
undermost	12	4	796	2	undermost
underplot	12	4	682	2	underplot
undershoot	14	4	510	2	undershoot
undershot	13	4	689	2	undershot
undertook	14	4	509	2	undertook
underwood	14	4	647	2	underwood
underwool	13	4	501	2	underwool
tenderfoots	15	5	168	3	tenderfoots
underact	11	3	1151	3	under_act
underbody	16	4	472	3	underbody
underboss	12	4	643	3	underboss
undercoats	13	4	662	3	undercoats
undercooks	17	4	443	3	undercooks
undercools	13	4	497	3	undercools
undercount	13	4	638	3	undercount
undercroft	16	15	496	3	undercroft
undercut	11	4	866	3	under_cut
underdo	9	3	736	3	under_do_
underdoes	11	3	910	3	underdoes
underdog	11	4	535	3	under_dog
underdogs	12	4	575	3	underdogs
underdone	11	5	821	3	underdone
underdose	11	5	759	3	underdose
undereat	9	3	1390	3	under_eat
underfed	13	3	1171	3	underf_ed
underfeed	14	4	863	3	underfeed
underflows	17	4	394	3	underflows
underfund	14	4	537	3	underfund
underfur	12	4	509	3	underf_ur
underfurs	13	5	549	3	underfurs
undergirt	11	4	781	3	undergirt
undergo	9	3	704	3	under_go_
undergod	11	3	658	3	under_god
undergods	12	4	633	3	undergods
undergoer	11	4	679	3	undergoer
undergoes	11	3	905	3	undergoes
undergone	11	5	827	3	undergone
underheat	13	4	838	3	underheat
underlet	9	15	1621	3	under_let
underlit	9	13	1153	3	under_lit
underload	11	4	637	3	underload
underpart	12	8	851	3	underpart
underplots	13	4	540	3	underplots
underproof	16	4	357	3	underproof
underprop	14	4	435	3	underprop
underset	9	14	1713	3	under_set
undershoots	15	5	345	3	undershoots
undersoil	10	5	677	3	undersoil
undersold	11	4	688	3	undersold
undersong	11	4	799	3	undersong
understood	12	4	414	3	understood
undertint	10	4	1486	3	undertint
undertone	10	5	1020	3	undertone
undertow	12	6	623	3	under_tow
undertows	13	6	668	3	undertows
undervest	13	9	867	3	undervest
undervote	13	5	775	3	undervote
underwent	13	4	905	3	underwent
underwoods	15	4	571	3	underwoods
underwools	14	4	443	3	underwools
underwork	17	4	642	3	underwork
underwrote	14	4	527	3	underwrote
undevout	12	4	608	3	unde_vout
unperfect	16	4	364	3	unperfect
unroot	6	3	1555	3	un__r_oot

Search took 9 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.453	394461.4
2	DLD Change Limit	148641	71	7.673	19372.0
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	8.156	21909.1