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

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

181 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
beader	9	46	2379	(None)
beaded	10	49	2242	1	beaded
beaders	10	41	2018	1	beaders
beadier	10	35	1391	1	beadier
beaker	12	55	2069	1	beaker
bearer	8	53	2391	1	bearer
beater	8	47	2939	1	beater
beaver	11	48	1925	1	beaver
bedder	10	42	1579	1	bedder
bender	9	52	2330	1	bender
blader	9	36	1858	1	blader
deader	8	42	2047	1	deader
header	10	44	2254	1	header
leader	7	48	2465	1	leader
reader	7	36	2829	1	reader
abrader	10	3	864	2	abrader
badder	10	38	1751	2	badder
bade	7	51	4088	2	b_ade_
badger	10	54	1508	2	b_adger
baker	11	56	2954	2	b_aker
balder	9	53	1886	2	balder
baler	7	56	3527	2	b_aler
bander	9	39	2822	2	bander
barer	7	45	3580	2	b_arer
baser	7	48	2892	2	b_aser
bead	7	59	3792	2	bead__
beadle	9	33	1468	2	beadle
beadles	10	34	1473	2	beadles
beadmen	12	29	945	2	beadmen
beads	8	54	2950	2	bead_s
beady	11	47	1992	2	bead_y
beaked	13	59	1949	2	beaked
beakers	13	42	1687	2	beakers
beakier	13	40	1216	2	beakier
beamed	11	57	2073	2	beamed
beamier	11	34	1194	2	beamier
beaned	9	56	2147	2	beaned
beanery	12	3	756	2	beanery
bear	6	68	4464	2	bea__r
bearded	11	42	1213	2	bearded
bearers	9	46	1959	2	bearers
beaten	8	46	1706	2	beaten
beaters	9	49	2504	2	beaters
beavers	12	44	1732	2	beavers
bedded	11	51	1407	2	bedded
bedders	11	35	1338	2	bedders
bedel	8	42	1940	2	be_del
bedew	11	45	1304	2	be_dew
beeper	10	37	1409	2	beeper
beer	6	56	3599	2	be__er
beezer	17	40	1052	2	beezer
behaver	15	20	672	2	behaver
beheader	14	3	604	2	beheader
belayer	12	33	950	2	belayer
belier	8	44	2356	2	belier
belter	8	47	2096	2	belter
bended	10	55	2123	2	bended
bendee	9	41	2102	2	bendee
benders	10	40	2106	2	benders
bendier	10	31	1141	2	bendier
better	8	47	2370	2	better
bidder	10	41	1486	2	bidder
bider	8	57	2837	2	b_ider
binder	9	44	2287	2	binder
birder	9	49	1549	2	birder
bladder	11	42	915	2	bladder
blade	8	59	2333	2	blade_
bladed	10	47	1776	2	bladed
bladers	10	42	1468	2	bladers
blades	9	52	2125	2	blades
blamer	10	44	1714	2	blamer
blander	10	37	1516	2	blander
blazer	17	44	1402	2	blazer
bleaker	13	35	1053	2	bleaker
bleater	9	45	1530	2	bleater
bleeder	10	35	964	2	bleeder
blender	10	46	1384	2	blender
boarder	10	39	1032	2	boarder
boater	8	46	2209	2	boater
bolder	9	48	2093	2	bolder
bonder	9	53	2478	2	bonder
border	9	44	1997	2	border
bracer	10	46	2058	2	bracer
braider	10	51	1299	2	braider
brander	10	39	1582	2	brander
braver	11	47	1904	2	braver
brawer	11	42	1633	2	brawer
brayer	11	53	1531	2	brayer
brazer	17	49	1753	2	brazer
breaded	11	50	1406	2	breaded
breaker	13	39	1292	2	breaker
breeder	10	32	1004	2	breeder
broader	10	34	1261	2	broader
budder	10	43	1481	2	budder
ceder	8	53	2224	2	ce_der
deaden	8	37	1432	2	deaden
deafer	10	41	1481	2	deafer
dealer	7	41	2214	2	dealer
dearer	7	48	2280	2	dearer
eager	6	55	2697	2	_eager
eater	5	46	3984	2	_eater
eider	6	46	2474	2	_eider
elder	6	40	2002	2	_elder
ender	6	43	2586	2	_ender
evader	10	3	681	2	evader
fader	9	44	2151	2	_fader
fearer	9	48	2018	2	fearer
feater	9	52	2405	2	feater
feeder	10	35	1384	2	feeder
fender	10	37	1872	2	fender
gelder	8	46	1371	2	gelder
gender	8	35	1793	2	gender
grader	8	49	1969	2	grader
headed	11	40	2047	2	headed
headers	11	38	1939	2	headers
headier	11	32	1295	2	headier
healer	9	42	2180	2	healer
heaper	11	41	1952	2	heaper
hearer	9	43	2364	2	hearer
heater	9	48	2830	2	heater
heaver	12	48	1967	2	heaver
heder	9	56	2364	2	he_der
heeder	10	42	1604	2	heeder
herder	10	45	1646	2	herder
kneader	12	7	589	2	kneader
lader	6	56	3372	2	_lader
leaded	8	42	2154	2	leaded
leaden	7	45	1522	2	leaden
leaders	8	38	1960	2	leaders
leadier	8	32	1272	2	leadier
leaker	10	46	2007	2	leaker
leaner	6	40	2219	2	leaner
leaper	8	81	1894	2	leaper
leaser	6	53	2267	2	leaser
leaver	9	43	2151	2	leaver
lender	7	39	2127	2	lender
lewder	10	47	961	2	lewder
loader	7	43	1631	2	loader
meager	9	45	1520	2	meager
meander	10	4	997	2	meander
meaner	8	46	1784	2	meaner
melder	9	39	1581	2	melder
mender	9	35	2079	2	mender
nearer	6	46	1889	2	nearer
neater	6	44	2431	2	neater
needer	7	36	1495	2	needer
pleader	10	35	1175	2	pleader
readers	8	38	2377	2	readers
readier	8	31	1742	2	readier
realer	6	35	2859	2	realer
reamer	8	43	2521	2	reamer
reaper	8	42	2314	2	reaper
rearer	6	49	2891	2	rearer
reaver	9	45	2473	2	reaver
redder	8	39	1814	2	redder
render	7	40	2414	2	render
sealer	6	39	2896	2	sealer
seamer	8	42	2361	2	seamer
searer	6	54	3202	2	searer
seater	6	45	3416	2	seater
seder	6	48	2676	2	se_der
seeder	7	43	2077	2	seeder
sender	7	38	2441	2	sender
shader	10	42	1876	2	shader
spader	9	43	1713	2	spader
tearer	6	48	2290	2	tearer
teaser	6	54	2152	2	teaser
tedder	8	33	1216	2	tedder
tender	7	41	2184	2	tender
trader	7	52	1876	2	trader
treader	8	41	1383	2	treader
vealer	9	40	1654	2	vealer
vender	10	34	1842	2	vender
wader	9	53	2536	2	_wader
weaker	13	40	1544	2	weaker
weaner	9	38	1677	2	weaner
wearer	9	43	1940	2	wearer
weaver	12	39	1661	2	weaver
wedder	11	36	1230	2	wedder
weeder	10	33	1551	2	weeder
welder	10	29	1441	2	welder

Search took 3 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	82551	0.340	525561.8
2	DLD Change Limit	82551	181	2.236	36919.1
3	Display Results	181	181	0.046	3934.8
	(SQL Overall)	178691	181	2.622	68150.6