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

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

189 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
leader	7	48	2465	(None)
beader	9	46	2379	1	beader
deader	8	42	2047	1	deader
header	10	44	2254	1	header
lader	6	56	3372	1	l_ader
leaded	8	42	2154	1	leaded
leaden	7	45	1522	1	leaden
leaders	8	38	1960	1	leaders
leadier	8	32	1272	1	leadier
leaker	10	46	2007	1	leaker
leaner	6	40	2219	1	leaner
leaper	8	81	1894	1	leaper
leaser	6	53	2267	1	leaser
leaver	9	43	2151	1	leaver
lender	7	39	2128	1	lender
lewder	10	47	961	1	lewder
loader	7	43	1631	1	loader
pleader	10	35	1176	1	pleader
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
bleaker	13	35	1053	2	bleaker
bleater	9	45	1530	2	bleater
bleeder	10	35	964	2	bleeder
blender	10	46	1385	2	blender
ceder	8	53	2224	2	ce_der
cleaner	9	37	1230	2	cleaner
clearer	9	37	1082	2	clearer
cleaver	12	41	1080	2	cleaver
coleader	11	3	918	2	coleader
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	2475	2	_eider
elater	6	47	2420	2	elater
elder	6	40	2002	2	_elder
eluder	7	37	1222	2	eluder
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
gleamer	10	32	851	2	gleamer
gleaner	8	37	977	2	gleaner
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	2365	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
laager	7	43	1278	2	laager
lacer	7	58	3375	2	l_acer
ladder	8	46	1762	2	ladder
lade	5	63	4599	2	l_ade_
laded	7	42	3261	2	l_aded
laden	6	50	2219	2	l_aden
laders	7	49	2776	2	l_aders
lades	6	51	4127	2	l_ades
ladler	7	43	1493	2	l_adler
lager	6	51	3286	2	l_ager
laker	9	54	3287	2	l_aker
lamer	7	52	3370	2	l_amer
lander	7	40	2849	2	lander
larder	7	37	2097	2	larder
laser	5	46	3332	2	l_aser
later	5	48	4392	2	l_ater
lauder	7	38	1501	2	lauder
laver	8	50	3179	2	l_aver
laxer	12	54	2033	2	l_axer
layer	8	46	2647	2	l_ayer
leacher	12	40	1484	2	leacher
lead	5	60	3885	2	lead__
leadens	8	36	1098	2	leadens
leadmen	10	27	790	2	leadmen
leads	6	60	2849	2	lead_s
leady	9	56	1860	2	lead_y
leafed	10	57	1387	2	leafed
leafier	10	32	983	2	leafier
leaguer	8	3	579	2	leaguer
leaked	11	42	1770	2	leaked
leakers	11	34	1542	2	leakers
leakier	11	40	1099	2	leakier
leaned	7	34	2254	2	leaned
leaners	7	37	1817	2	leaners
leaped	9	43	1777	2	leaped
leapers	9	37	1666	2	leapers
lear	4	70	4595	2	lea__r
learier	7	34	1566	2	learier
learner	7	31	938	2	learner
lease	5	52	3026	2	lease_
leased	7	47	2288	2	leased
leasers	7	47	1784	2	leasers
leases	6	54	2811	2	leases
leather	10	38	1578	2	leather
leave	8	47	2372	2	leave_
leaved	10	57	1902	2	leaved
leaven	9	50	1307	2	leaven
leavers	10	37	1778	2	leavers
leaves	9	42	2238	2	leaves
leavier	10	31	999	2	leavier
lecher	11	34	1585	2	lecher
ledger	8	59	1439	2	ledger
leer	4	62	3935	2	le__er
lefter	9	36	1343	2	lefter
leger	6	57	2151	2	le_ger
lenders	8	44	1965	2	lenders
leper	7	48	2074	2	le_per
lesser	6	35	1485	2	lesser
letter	6	37	2258	2	letter
leudes	7	53	1409	2	leudes
lever	8	51	2516	2	le_ver
levier	9	40	1387	2	levier
lieder	7	49	1232	2	lieder
loaded	8	46	1687	2	loaded
loaders	8	34	1343	2	loaders
loafer	9	36	1094	2	loafer
loaner	6	44	1650	2	loaner
louder	7	44	1460	2	louder
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
oleander	9	3	640	2	oleander
pleaded	11	35	1126	2	pleaded
pleaders	11	32	1019	2	pleaders
pleaser	9	39	1234	2	pleaser
pleater	9	39	1633	2	pleater
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
sledder	9	39	920	2	sledder
slender	8	34	1360	2	slender
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	2537	2	_wader
weaker	13	40	1544	2	weaker
weaner	9	38	1677	2	weaner
wearer	9	43	1941	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 4 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.343	520965.0
2	DLD Change Limit	82551	189	2.593	31836.1
3	Display Results	189	189	0.063	3000.0
	(SQL Overall)	178691	189	2.999	59583.5