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

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

164 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
deader	8	42	2047	(None)
beader	9	46	2379	1	beader
deaden	8	37	1432	1	deaden
deafer	10	41	1481	1	deafer
dealer	7	41	2214	1	dealer
dearer	7	48	2280	1	dearer
header	10	44	2254	1	header
leader	7	48	2465	1	leader
reader	7	36	2829	1	reader
beaded	10	49	2242	2	beaded
beaders	10	41	2018	2	beaders
beadier	10	35	1391	2	beadier
beaker	12	55	2069	2	beaker
bearer	8	53	2391	2	bearer
beater	8	47	2939	2	beater
beaver	11	48	1925	2	beaver
bedder	10	42	1579	2	bedder
bender	9	52	2330	2	bender
blader	9	36	1858	2	blader
ceder	8	53	2224	2	ce_der
dander	8	112	2299	2	dander
darer	6	52	3079	2	d_arer
dater	6	53	3231	2	d_ater
dead	6	54	3424	2	dead__
deadener	10	3	674	2	deadener
deadens	9	34	1069	2	deadens
deadest	9	30	1488	2	deadest
deadeye	12	4	516	2	deadeye
deadlier	10	3	686	2	deadlier
deadly	11	38	1147	2	deadly
deadmen	11	24	857	2	deadmen
deads	7	57	2691	2	dead_s
deafen	10	38	967	2	deafen
deair	6	58	1719	2	dea_ir
dealers	8	41	1861	2	dealers
deaned	8	46	2045	2	deaned
deanery	11	3	761	2	deanery
dear	5	53	4360	2	dea__r
deave	9	50	2233	2	deave_
deaved	11	49	1655	2	deaved
deaves	10	53	1953	2	deaves
debaser	10	35	1041	2	debaser
debater	10	41	1469	2	debater
decade	10	42	1616	2	decade_
decades	11	36	1551	2	decades
decayer	13	33	935	2	decayer
decider	11	42	1318	2	decider
decker	13	52	1599	2	decker
decoder	11	37	1229	2	decoder
deeded	9	46	1554	2	deeded
deedier	9	30	1159	2	deedier
deeper	9	36	1350	2	deeper
deer	5	67	3902	2	de__er
defacer	13	28	1036	2	defacer
defamer	13	27	1032	2	defamer
defer	9	46	1975	2	de_fer
deffer	13	44	1130	2	deffer
defier	10	51	1865	2	defier
defter	10	42	1592	2	defter
degrader	11	24	791	2	degrader
deicer	9	41	1441	2	deicer
delayer	11	30	1053	2	delayer
deluder	9	16	833	2	deluder
delver	10	49	1349	2	delver
demander	12	23	872	2	demander
denier	7	44	2069	2	denier
denser	7	41	1519	2	denser
denuder	9	16	760	2	denuder
deodar	8	3	771	2	deodar
derider	9	32	1497	2	derider
deter	6	50	2804	2	de_ter
dewater	11	29	1242	2	dewater
dewier	10	40	1346	2	dewier
dexter	14	38	1089	2	dexter
diadem	10	3	758	2	diadem
dialer	7	43	1543	2	dialer
diaper	9	45	1311	2	diaper
dodder	9	47	1291	2	dodder
draper	9	43	1569	2	draper
drawer	10	47	1136	2	drawer
dreaded	10	36	1202	2	dreaded
dreamer	10	41	1084	2	dreamer
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.390	458182.1
2	DLD Change Limit	82551	164	2.313	35690.0
3	Display Results	164	164	0.046	3565.2
	(SQL Overall)	178691	164	2.749	65002.2