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

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

347 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
baler	7	56	3527	(None)
abler	7	56	2431	1	abler
bailer	8	54	2525	1	bailer
baker	11	56	2954	1	baker
balder	9	53	1886	1	balder
bale	6	63	5384	1	bale_
baled	8	54	3644	1	baled
balers	8	56	2693	1	balers
bales	7	62	5008	1	bales
balker	12	45	1916	1	balker
baller	8	38	2520	1	baller
barer	7	45	3580	1	barer
baser	7	48	2892	1	baser
bawler	11	43	1505	1	bawler
haler	8	50	3352	1	haler
paler	7	54	3693	1	paler
taler	5	60	3486	1	taler
waler	8	42	2926	1	waler
abaser	8	64	1434	2	abaser
abater	8	55	1812	2	abater
able	6	63	4053	2	able_
abled	8	69	2683	2	abled
ables	7	59	3554	2	ables
ager	5	59	3584	2	_ager
alar	4	63	4007	2	_alar
alder	6	54	2191	2	_alder
ale	3	65	7234	2	_ale_
alec	6	64	3006	2	_alec
alee	4	66	5232	2	_alee
alef	7	63	4069	2	_alef
alert	5	47	4065	2	_alert
ales	4	70	6710	2	_ales
alter	5	48	2850	2	_alter
aper	6	63	3623	2	_aper
aver	7	59	3188	2	_aver
baaed	8	52	1816	2	baaed
babbler	10	40	1282	2	babbler
babe	8	68	3582	2	babe_
babel	9	58	2169	2	babel
babes	9	58	3411	2	babes
babier	10	35	1557	2	babier
backer	14	45	2553	2	backer
badder	10	38	1751	2	badder
bade	7	51	4089	2	bade_
badger	10	54	1508	2	badger
baffler	15	41	811	2	baffler
bagel	8	51	1679	2	bagel
bagger	10	46	1920	2	bagger
bailed	9	47	2665	2	bailed
bailee	8	45	2601	2	bailee
bailers	9	42	2135	2	bailers
bailey	11	50	1567	2	bailey
bailor	8	34	1260	2	bailor
baiter	8	44	2256	2	baiter
bake	10	56	3751	2	bake_
baked	12	61	3077	2	baked
bakers	12	53	2345	2	bakers
bakery	15	59	1100	2	bakery
bakes	11	70	3537	2	bakes
bal	5	66	6272	2	bal__
balas	7	69	3721	2	balas
bald	7	64	3290	2	bal_d
balded	10	54	1751	2	balded
balds	8	55	2464	2	balds
baldy	11	55	1893	2	baldy
baleen	8	6	1305	2	baleen
balk	10	51	3222	2	bal_k
balked	13	52	1941	2	balked
balkers	13	49	1572	2	balkers
balkier	13	41	1198	2	balkier
balks	11	49	2629	2	balks
balky	14	54	1824	2	balky
ball	6	60	4332	2	bal_l
balled	9	49	2689	2	balled
ballers	9	44	2101	2	ballers
ballet	8	47	3397	2	ballet
balls	7	62	3641	2	balls
bally	10	55	3010	2	bally
balm	8	55	3420	2	bal_m
balmier	11	38	1151	2	balmier
balms	9	57	2392	2	balms
balmy	12	52	1747	2	balmy
bals	6	63	5404	2	bal_s
balsa	7	79	2041	2	balsa
bander	9	39	2822	2	bander
bane	6	52	5043	2	bane_
baned	8	54	3635	2	baned
banes	7	49	4558	2	banes
banger	9	44	2364	2	banger
banker	12	42	2273	2	banker
banner	8	44	2150	2	banner
banter	8	48	2534	2	banter
bar	5	80	7055	2	ba__r
barber	10	44	1932	2	barber
bare	6	54	6052	2	bare_
bared	8	51	4448	2	bared
bares	7	54	5713	2	bares
barker	12	48	2286	2	barker
barley	11	51	1676	2	barley
barre	7	59	2955	2	barre
barter	8	55	2538	2	barter
base	6	48	4702	2	base_
based	8	53	3158	2	based
bases	7	56	4435	2	bases
basher	11	51	2381	2	basher
baster	8	53	3360	2	baster
bate	6	65	5242	2	bate_
bated	8	59	3553	2	bated
bates	7	58	4634	2	bates
bather	11	53	2251	2	bather
batter	8	49	2888	2	batter
battler	9	41	1338	2	battler
bawled	12	44	1569	2	bawled
bawlers	12	44	1273	2	bawlers
bayed	11	54	2302	2	bayed
bazar	16	38	1600	2	bazar
beader	9	46	2379	2	beader
beaker	12	55	2069	2	beaker
bearer	8	53	2391	2	bearer
beater	8	47	2939	2	beater
beaver	11	48	1925	2	beaver
beer	6	56	3599	2	b_eer
belier	8	44	2356	2	belier
belter	8	47	2096	2	belter
bider	8	57	2838	2	bider
bier	6	55	3184	2	b_ier
biker	11	60	2256	2	biker
bile	6	61	4719	2	bile_
biles	7	55	4214	2	biles
bilker	12	49	1344	2	bilker
biller	8	49	2348	2	biller
biner	7	59	3069	2	biner
birler	8	57	1508	2	birler
biter	7	50	3003	2	biter
blader	9	36	1858	2	blader
blae	6	61	3464	2	blae_
blamer	10	44	1714	2	blamer
blare	7	58	2623	2	blare
blazer	17	44	1402	2	blazer
blear	7	59	1868	2	b_lear
bleb	8	54	2522	2	b_leb
bled	7	57	2931	2	b_led
blet	6	62	4767	2	b_let
blew	9	47	2243	2	b_lew
bluer	7	49	1849	2	bluer
blur	6	60	2053	2	b_lur
boater	8	46	2209	2	boater
boiler	8	43	1927	2	boiler
bolar	7	51	2347	2	bolar
bolder	9	48	2093	2	bolder
bole	6	64	4869	2	bole_
bolero	8	4	1209	2	bolero
boles	7	54	4860	2	boles
bolter	8	39	2075	2	bolter
boner	7	51	3308	2	boner
borer	7	51	3127	2	borer
bower	10	73	2818	2	bower
bowler	11	42	1731	2	bowler
boxer	14	50	1652	2	boxer
bracer	10	46	2058	2	bracer
braver	11	47	1904	2	braver
brawer	11	42	1633	2	brawer
brawler	12	43	1023	2	brawler
brayer	11	53	1531	2	brayer
brazer	17	49	1753	2	brazer
brier	7	45	2740	2	brier
bugler	9	47	1772	2	bugler
bulger	9	49	1735	2	bulger
burler	8	47	2383	2	burler
butler	8	42	2003	2	butler
buyer	10	50	1309	2	buyer
caber	9	51	2683	2	caber
cabler	10	45	1917	2	cabler
cager	8	52	2922	2	cager
calker	12	49	1708	2	calker
caller	8	51	2548	2	caller
calmer	10	52	1693	2	calmer
caner	7	53	3477	2	caner
caper	9	48	3162	2	caper
carer	7	49	4233	2	carer
cater	7	48	4072	2	cater
caver	10	56	2906	2	caver
coaler	8	41	2171	2	coaler
dale	5	56	4398	2	dale_
dales	6	64	3974	2	dales
darer	6	52	3079	2	darer
dater	6	53	3231	2	dater
dealer	7	41	2214	2	dealer
dialer	7	43	1543	2	dialer
eager	6	55	2697	2	eager
eater	5	46	3984	2	eater
fabler	11	61	1581	2	fabler
facer	10	55	2505	2	facer
fader	9	44	2151	2	fader
faker	12	48	2459	2	faker
faller	9	46	2123	2	faller
falser	9	39	1241	2	falser
falter	9	45	1905	2	falter
farer	8	67	3314	2	farer
filer	8	54	3300	2	filer
gager	7	47	2629	2	gager
gale	5	63	4732	2	gale_
galea	6	47	2294	2	galea
galere	7	37	1668	2	galere
gales	6	54	4248	2	gales
gamer	8	49	2894	2	gamer
gaoler	7	39	1357	2	gaoler
gaper	8	61	2512	2	gaper
gater	6	45	3365	2	gater
gayer	9	45	1919	2	gayer
gazer	15	57	2007	2	gazer
hailer	9	47	2034	2	hailer
hale	7	60	5283	2	hale_
haled	9	53	3582	2	haled
halers	9	49	2691	2	halers
haleru	9	42	1207	2	haleru
hales	8	54	4984	2	hales
halter	9	44	2088	2	halter
hater	8	50	3475	2	hater
hauler	9	50	1512	2	hauler
haver	11	51	2446	2	haver
hayer	11	46	2024	2	hayer
hazer	17	48	2023	2	hazer
healer	9	42	2180	2	healer
idler	6	50	1566	2	idler
iller	5	48	2129	2	iller
jager	13	43	1813	2	jager
jailer	13	43	1668	2	jailer
japer	14	62	1888	2	japer
kale	8	65	3376	2	kale_
kales	9	57	3098	2	kales
lacer	7	58	3375	2	lacer
lader	6	56	3372	2	lader
ladler	7	43	1493	2	ladler
lager	6	51	3286	2	lager
laker	9	54	3287	2	laker
lamer	7	52	3370	2	lamer
laser	5	46	3332	2	laser
later	5	48	4392	2	later
laver	8	50	3179	2	laver
laxer	12	54	2033	2	laxer
layer	8	46	2647	2	layer
macer	9	121	2694	2	macer
mailer	8	47	2418	2	mailer
maker	11	41	2781	2	maker
malar	7	64	2444	2	malar
male	6	60	5230	2	male_
males	7	50	4979	2	males
maser	7	50	2997	2	maser
mater	7	44	3886	2	mater
mauler	8	44	1671	2	mauler
mazer	16	57	2242	2	mazer
miler	7	57	3306	2	miler
nailer	6	41	1936	2	nailer
naled	6	55	2505	2	naled
namer	7	56	2210	2	namer
oater	5	54	3373	2	oater
ogler	6	59	1744	2	ogler
oiler	5	46	2828	2	oiler
pacer	9	61	3161	2	pacer
pager	8	47	2820	2	pager
pale	6	60	5501	2	pale_
palea	7	50	2866	2	palea
paled	8	55	3872	2	paled
pales	7	57	5380	2	pales
palet	7	46	5080	2	palet
palier	8	50	2356	2	palier
palmer	10	58	1654	2	palmer
palter	8	44	2326	2	palter
paper	9	51	2866	2	paper
parer	7	58	3990	2	parer
pater	7	47	4072	2	pater
paver	10	42	2583	2	paver
pawer	10	44	2297	2	pawer
payer	10	51	2572	2	payer
poler	7	44	3179	2	poler
puler	7	48	2662	2	puler
racer	7	52	3302	2	racer
railer	6	45	2493	2	railer
raker	9	45	2979	2	raker
rale	4	50	5056	2	rale_
rales	5	49	4749	2	rales
raper	7	49	3275	2	raper
rarer	5	47	3170	2	rarer
raser	5	56	3341	2	raser
rater	5	49	4328	2	rater
raver	8	56	3149	2	raver
rawer	8	46	2373	2	rawer
razer	14	48	2427	2	razer
realer	6	35	2859	2	realer
ruler	5	49	2334	2	ruler
saber	7	53	3024	2	saber
safer	8	47	2181	2	safer
sager	6	54	3205	2	sager
sailer	6	35	2610	2	sailer
saker	9	51	3202	2	saker
sale	4	49	5970	2	sale_
salep	7	70	2295	2	salep
sales	5	60	5559	2	sales
salter	6	43	2508	2	salter
salver	9	46	1775	2	salver
saner	5	43	3432	2	saner
saver	8	48	3125	2	saver
sawer	8	50	2621	2	sawer
sayer	8	49	2655	2	sayer
scaler	8	43	2160	2	scaler
sealer	6	39	2896	2	sealer
staler	6	40	2582	2	staler
taber	7	38	2582	2	taber
tailer	6	38	2373	2	tailer
taker	9	52	2900	2	taker
talar	5	62	2538	2	talar
tale	4	61	5416	2	tale_
talers	6	46	2814	2	talers
tales	5	54	5137	2	tales
talker	10	39	1622	2	talker
taller	6	37	2196	2	taller
tamer	7	52	3010	2	tamer
taper	7	48	2977	2	taper
tater	5	41	3861	2	tater
tawer	8	52	2344	2	tawer
taxer	12	50	1936	2	taxer
thaler	9	46	1310	2	thaler
tiler	5	61	3102	2	tiler
vale	7	49	3734	2	vale_
vales	8	54	3426	2	vales
valet	8	43	3787	2	valet
valor	8	36	1489	2	valor
valuer	9	39	1144	2	valuer
vealer	9	40	1654	2	vealer
viler	8	63	2416	2	viler
wader	9	53	2536	2	wader
wafer	11	44	1764	2	wafer
wager	9	59	2505	2	wager
wailer	9	37	2032	2	wailer
waker	12	55	2659	2	waker
wale	7	45	4643	2	wale_
waled	9	43	3099	2	waled
walers	9	48	2446	2	walers
wales	8	61	4283	2	wales
walker	13	39	1399	2	walker
water	8	47	3331	2	water
waver	11	50	2570	2	waver
waxer	15	43	1748	2	waxer
whaler	12	46	1197	2	whaler
yager	9	56	1675	2	yager
yarer	8	43	2157	2	yarer

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	53800	0.313	570897.8
2	DLD Change Limit	53800	347	1.766	30464.3
3	Display Results	347	347	0.093	3731.2
	(SQL Overall)	178691	347	2.172	82270.3