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

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

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

161 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
under	6	46	2421	(None)
ender	6	43	2586	1	ender
funder	10	40	1608	1	funder
nuder	6	64	1683	1	nuder
sunder	7	40	1982	1	sunder
udder	7	63	1428	1	udder
unde	5	58	2548	1	unde_
undee	6	53	2727	1	undee
undoer	7	31	1304	1	undoer
adder	7	54	1959	2	adder
aider	6	54	3113	2	aider
alder	6	54	2191	2	alder
anger	6	62	2587	2	anger
asunder	8	5	622	2	asunder
aulder	7	5	1145	2	aulder
bander	9	39	2822	2	bander
bender	9	52	2330	2	bender
bider	8	57	2837	2	bider
binder	9	44	2287	2	binder
blunder	10	38	1315	2	blunder
bonder	9	53	2478	2	bonder
bounder	10	42	1553	2	bounder
budder	10	43	1481	2	budder
bundler	10	40	1172	2	bundler
bunker	12	45	1937	2	bunker
bunter	8	50	2038	2	bunter
ceder	8	53	2224	2	ceder
cider	8	47	2331	2	cider
cinder	9	41	1912	2	cinder
coder	8	61	3422	2	coder
cunner	8	39	1500	2	cunner
cyder	11	46	1113	2	cyder
dander	8	112	2299	2	dander
daunder	9	34	889	2	daunder
dunker	11	36	1646	2	dunker
dunner	7	39	1382	2	dunner
eider	6	46	2474	2	eider
elder	6	40	2002	2	elder
endear	7	41	1001	2	endear
ended	7	44	2126	2	ended
enders	7	43	2405	2	enders
enter	5	47	2638	2	enter
fader	9	44	2151	2	fader
fender	10	37	1872	2	fender
finder	10	40	2023	2	finder
fonder	10	41	2006	2	fonder
founder	11	43	1257	2	founder
funded	11	44	1389	2	funded
funders	11	38	1393	2	funders
funker	13	39	1576	2	funker
funner	9	34	1410	2	funner
gander	8	43	2276	2	gander
gender	8	35	1793	2	gender
guider	8	43	1352	2	guider
gunner	7	38	1398	2	gunner
hander	10	45	2643	2	hander
heder	9	56	2364	2	heder
hider	9	50	2408	2	hider
hinder	10	41	2006	2	hinder
hounder	11	34	1223	2	hounder
hunger	10	40	1520	2	hunger
hunker	13	39	1767	2	hunker
hunter	9	48	1777	2	hunter
index	13	3	1098	2	index
infer	8	42	1503	2	infer
inker	9	44	2109	2	inker
inner	5	49	2063	2	inner
inter	5	50	2849	2	inter
judder	15	43	942	2	judder
junker	17	42	1365	2	junker
kinder	11	37	1684	2	kinder
lader	6	56	3372	2	lader
lander	7	40	2848	2	lander
launder	8	30	914	2	launder
lender	7	39	2127	2	lender
lunger	7	57	2042	2	lunger
lunier	6	46	1760	2	lunier
lunker	10	47	1834	2	lunker
maunder	10	32	868	2	maunder
mender	9	35	2079	2	mender
minder	9	48	2250	2	minder
mudder	10	44	1349	2	mudder
murder	9	36	1378	2	murder
nude	5	66	2627	2	nude_
nudes	6	47	2329	2	nudes
nudger	8	51	1164	2	nudger
odder	7	45	1539	2	odder
older	6	51	2117	2	older
order	6	50	1936	2	order
pander	9	37	2552	2	pander
pinder	9	45	2345	2	pinder
plunder	10	38	1050	2	plunder
ponder	9	45	2169	2	ponder
pounder	10	33	1400	2	pounder
punier	8	45	1922	2	punier
punker	12	37	1882	2	punker
punner	8	49	1815	2	punner
punter	8	43	2002	2	punter
render	7	40	2414	2	render
rider	6	52	3130	2	rider
rounder	8	35	1460	2	rounder
rudder	8	38	1280	2	rudder
ruder	6	53	2054	2	ruder
runner	6	38	1446	2	runner
sander	7	48	2853	2	sander
seder	6	48	2676	2	seder
sender	7	38	2441	2	sender
sneer	5	49	1995	2	sneer
snider	7	44	1391	2	snider
sonder	7	36	2352	2	sonder
sounder	8	33	1538	2	sounder
sunders	8	41	2005	2	sunders
sundew	10	36	969	2	sundew
tender	7	41	2184	2	tender
thunder	11	3	696	2	thunder
tinder	7	38	2180	2	tinder
tuner	5	60	2268	2	tun_er
udders	8	39	1129	2	udders
ulcer	7	3	1075	2	ulcer
umber	9	46	1759	2	umber
unbar	7	19	1361	2	unbar
unbe	6	53	1927	2	unbe_
unbear	8	8	916	2	unbear
undead	8	27	1190	2	undead
underdo	9	3	736	2	underdo
undergo	9	3	704	2	undergo
undid	7	24	1536	2	undid
undies	7	38	2196	2	undies
undo	5	56	2015	2	und_o
undoers	8	29	1058	2	undoers
undoes	7	39	1740	2	undoes
undrew	10	3	791	2	undrew
undue	6	67	1555	2	undue
undy	8	50	1516	2	und_y
undyed	11	3	814	2	undyed
unfed	9	46	1422	2	unfed
uniter	6	46	1914	2	uniter
unled	6	40	2107	2	unled
unlet	5	41	3333	2	unlet
unmet	7	44	2639	2	unmet
unmew	10	36	1007	2	unmew
unpeg	8	30	936	2	unpeg
unpen	7	29	1357	2	unpen
unset	5	45	3243	2	unset
unsew	8	39	1269	2	unsew
unsex	12	35	1263	2	unsex
unwed	9	41	1487	2	unwed
unwet	8	44	2317	2	unwet
upper	9	37	1426	2	upper
urger	6	41	1647	2	urger
user	4	50	2300	2	u_ser
usher	8	45	1776	2	usher
utter	5	42	1876	2	utter
vender	10	34	1842	2	vender
wader	9	53	2536	2	wader
wander	10	44	2371	2	wander
wider	9	48	2635	2	wider
winder	10	40	2526	2	winder
wonder	10	36	1781	2	wonder
yonder	10	32	1413	2	yonder
zander	16	34	1711	2	zander

Search took 2 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	53800	0.310	576422.6
2	DLD Change Limit	53800	161	1.563	34421.0
3	Display Results	161	161	0.046	3500.0
	(SQL Overall)	178691	161	1.919	93116.7