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

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

63 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
undergrad	12	4	548	(None)
undergrads	13	4	479	1	undergrads
underbred	13	3	899	2	underbred
undercard	13	4	700	2	undercard
underclad	13	4	556	2	underclad
undergird	12	4	590	2	undergird
undergod	11	3	658	2	underg_od
underload	11	4	637	2	underload
underran	9	4	842	2	under_ran
dunderhead	16	4	297	3	dunderhead
intergrade	12	4	736	3	intergrade
undead	8	27	1190	3	unde___ad
underaged	12	10	1123	3	underaged
underarm	11	4	784	3	underar_m
underarms	12	4	673	3	underarms
underbid	12	10	820	3	under_bid
underbrim	14	4	463	3	underbrim
underbud	12	13	621	3	under_bud
undercards	14	4	556	3	undercards
underclay	15	4	506	3	underclay
undercoat	12	4	873	3	undercoat
underdid	11	12	813	3	under_did
undereat	9	3	1390	3	under_eat
underfed	13	3	1171	3	under_fed
underfeed	14	4	863	3	underfeed
underfund	14	4	537	3	underfund
undergirded	15	4	401	3	undergirded
undergirds	13	4	445	3	undergirds
undergirt	11	4	781	3	undergirt
underglaze	21	4	420	3	underglaze
undergo	9	3	704	3	underg__o
undergods	12	4	633	3	undergods
undergoer	11	4	679	3	undergoer
undergoes	11	3	905	3	undergoes
undergone	11	5	827	3	undergone
underground	14	5	278	3	underground
underhand	14	4	726	3	underhand
underheat	13	4	838	3	underheat
underived	14	3	1051	3	underived
underjaw	19	4	399	3	under_jaw
underlaid	11	4	749	3	underlaid
underlap	11	14	642	3	under_lap
underlay	12	14	765	3	under_lay
underloads	12	4	523	3	underloads
underpaid	13	4	696	3	underpaid
underpart	12	8	851	3	underpart
underpay	14	13	621	3	under_pay
underplay	15	4	519	3	underplay
underprop	14	4	435	3	underprop
underrate	10	4	1189	3	under_rate
underrated	12	3	1084	3	under_rated
underrun	9	8	681	3	under_run
undersea	9	14	988	3	undersea_
underseas	10	8	780	3	underseas
undersold	11	4	688	3	undersold
understand	12	4	618	3	understand
undertax	16	4	611	3	under_tax
underused	11	3	933	3	underused
underway	15	13	634	3	under_way
underwear	13	4	476	3	underwear
underwood	14	4	647	3	underwood
underworld	15	4	427	3	underworld
undesired	11	4	752	3	undesired

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.860	207780.2
2	DLD Change Limit	148641	63	8.063	18434.9
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	8.953	19958.8