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

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

473 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
gale	5	63	4732	(None)
ale	3	65	7234	1	_ale
bale	6	63	5384	1	bale
dale	5	56	4398	1	dale
gable	8	53	2552	1	gable
gae	4	64	5770	1	ga_e
gage	6	59	3610	1	gage
gal	4	60	5551	1	gal_
gala	5	56	3516	1	gala
galea	6	47	2294	1	galea
gales	6	54	4248	1	gales
gall	5	63	3599	1	gall
gals	5	79	4650	1	gals
game	7	66	4432	1	game
gane	5	51	4530	1	gane
gape	7	51	3451	1	gape
gate	5	57	4657	1	gate
gave	8	46	3405	1	gave
gaze	14	50	3241	1	gaze
hale	7	60	5283	1	hale
kale	8	65	3375	1	kale
male	6	60	5230	1	male
pale	6	60	5501	1	pale
rale	4	50	5056	1	rale
sale	4	49	5970	1	sale
tale	4	61	5416	1	tale
vale	7	49	3734	1	vale
wale	7	45	4643	1	wale
aal	3	90	5867	2	aal_
aals	4	99	4114	2	aals
able	6	63	4053	2	able
ace	5	96	5683	2	_ace
ae	2	125	9029	2	_a_e
agape	8	56	1484	2	agape
agate	6	65	2515	2	agate
agave	9	53	1403	2	agave
agaze	15	61	1366	2	agaze
age	4	71	5433	2	_age
agee	5	62	4149	2	agee
agile	6	51	2226	2	agile
aglee	6	57	2849	2	aglee
aglet	6	55	3414	2	aglet
agley	9	69	1733	2	agley
agly	8	68	2180	2	agly
ague	5	57	2592	2	ague
al	2	106	7404	2	_al_
ala	3	124	6360	2	_ala
alae	4	56	4375	2	_alae
alb	5	73	4265	2	_alb
alec	6	64	3006	2	_alec
alee	4	66	5232	2	_alee
alef	7	63	4069	2	_alef
ales	4	70	6710	2	_ales
all	3	61	4823	2	_all
alme	6	58	3216	2	_alme
aloe	4	55	4019	2	_aloe
alp	5	66	4113	2	_alp
als	3	66	6302	2	_als
alt	3	64	6796	2	_alt
ane	3	78	6695	2	_ane
ape	5	72	5118	2	_ape
are	3	78	7457	2	_are
ate	3	70	5924	2	_ate
ave	6	77	4870	2	_ave
awe	6	77	4662	2	_awe
axe	10	82	3949	2	_axe
axle	11	64	2460	2	axle
aye	6	71	5176	2	_aye
babe	8	68	3582	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bal	5	66	6272	2	bal_
bald	7	64	3290	2	bald
baled	8	54	3644	2	baled
baler	7	56	3527	2	baler
bales	7	62	5008	2	bales
balk	10	51	3222	2	balk
ball	6	60	4332	2	ball
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
bile	6	61	4718	2	bile
blae	6	61	3464	2	blae
bole	6	64	4869	2	bole
cable	9	53	2991	2	cable
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
calf	9	63	3956	2	calf
calk	10	55	2766	2	calk
call	6	68	3867	2	call
calm	8	50	3236	2	calm
calo	6	49	3644	2	calo
calve	10	59	1992	2	calve
calx	13	57	2279	2	calx
came	8	76	4875	2	came
cane	6	66	5312	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
carle	7	45	3570	2	carle
case	6	58	4808	2	case
cate	6	62	5460	2	cate
cave	9	59	4126	2	cave
cole	6	69	5611	2	cole
dace	7	69	3492	2	dace
dal	4	75	5495	2	dal_
dales	6	64	3974	2	dales
dals	5	71	4512	2	dals
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
dele	5	68	4308	2	dele
dole	5	65	5000	2	dole
eagle	6	42	1948	2	eagle
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
egal	5	51	1943	2	egal_
fable	10	58	2475	2	fable
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
fall	7	55	3531	2	fall
false	8	48	1812	2	false
falx	14	71	2078	2	falx
fame	9	56	3939	2	fame
fane	7	53	4357	2	fane
fare	7	63	5446	2	fare
farle	8	69	2924	2	farle
fate	7	54	4428	2	fate
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
file	7	54	4664	2	file
gab	6	71	5599	2	ga_b
gabble	11	38	1572	2	gabble
gabled	10	55	1845	2	gabled
gables	9	42	2233	2	gables
gabs	7	67	4042	2	gabs
gaby	10	71	2319	2	gaby
gad	5	75	5665	2	ga_d
gadi	6	63	2972	2	gadi
gadje	14	5	774	2	gadje
gads	6	78	4338	2	gads
gaed	6	60	3151	2	gaed
gaen	5	73	2960	2	gaen
gaes	5	63	4803	2	gaes
gaff	11	48	2815	2	gaff
gaffe	12	41	1165	2	gaffe
gag	5	77	5363	2	ga_g
gaga	6	66	2555	2	gaga
gaged	8	55	2231	2	gaged
gager	7	47	2629	2	gager
gages	7	45	2997	2	gages
gaggle	9	34	1262	2	gaggle
gags	6	64	4106	2	gags
gaily	9	50	2097	2	gaily
gain	5	60	4216	2	gain
gait	5	61	5019	2	gait
galah	9	59	1764	2	galah
galas	6	57	3164	2	galas
galax	13	53	1446	2	galax
galeae	7	47	1745	2	galeae
galeas	7	46	1851	2	galeas
galena	7	49	1109	2	galena
galere	7	37	1668	2	galere
galled	8	46	2286	2	galled
gallet	7	36	3085	2	gallet
galley	10	42	1545	2	galley
galls	6	47	2932	2	galls
gally	9	50	2617	2	gally
galop	8	47	1622	2	galop
galore	7	35	1487	2	galore
gam	6	70	6006	2	ga_m
gama	7	70	3552	2	gama
gamb	9	63	3184	2	gamb
gambe	10	62	1921	2	gambe
gamble	11	54	1718	2	gamble
gamed	9	51	2639	2	gamed
gamer	8	49	2894	2	gamer
games	8	62	3855	2	games
gamey	11	53	2055	2	gamey
gamp	9	88	3321	2	gamp
gams	7	66	4888	2	gams
gamy	10	54	2753	2	gamy
gan	4	80	6013	2	ga_n
ganef	9	63	2246	2	ganef
ganev	9	55	1386	2	ganev
gang	6	60	3197	2	gang
gaol	5	69	2541	2	gaol
gaoled	8	48	1450	2	gaoled
gaoler	7	39	1357	2	gaoler
gaols	6	67	1757	2	gaols
gap	6	70	5561	2	ga_p
gaped	9	61	2353	2	gaped
gaper	8	61	2512	2	gaper
gapes	8	60	3082	2	gapes
gaps	7	60	4297	2	gaps
gapy	10	63	2091	2	gapy
gar	4	72	5990	2	ga_r
garb	7	53	3267	2	garb
garble	9	41	1845	2	garble
gargle	8	42	1546	2	gargle
gars	5	57	5074	2	gars
gas	4	88	7025	2	ga_s
gases	6	56	3399	2	gases
gash	8	68	3302	2	gash
gasp	7	62	2733	2	gasp
gast	5	60	5256	2	gast
gat	4	68	8051	2	ga_t
gated	7	53	2977	2	gated
gater	6	45	3365	2	gater
gates	6	59	3951	2	gates
gats	5	67	5344	2	gats
gaud	6	70	2543	2	gaud
gauge	7	61	1790	2	gauge
gault	6	51	2848	2	gault
gaum	7	57	2642	2	gaum
gaun	5	64	2771	2	gaun
gaur	5	67	2335	2	gaur
gauze	15	57	1297	2	gauze
gavel	9	58	1518	2	gavel
gawk	12	67	1669	2	gawk
gawp	10	76	1863	2	gawp
gay	7	68	5649	2	ga_y
gayer	9	45	1919	2	gayer
gayly	12	45	1309	2	gayly
gays	8	73	3802	2	gays
gazed	16	55	2033	2	gazed
gazer	15	57	2007	2	gazer
gazes	15	54	2591	2	gazes
gee	4	53	5920	2	g_ee
gel	4	56	4243	2	gel_
geld	6	58	2843	2	geld
gelee	6	36	2698	2	gelee
gels	5	68	3610	2	gels
gelt	5	64	4801	2	gelt
gene	5	62	3722	2	gene
ghee	8	57	2611	2	ghee
gibe	7	59	2778	2	gibe
gie	4	71	4954	2	g_ie
gild	6	55	2651	2	gild
gill	5	63	3618	2	gill
gilt	5	63	4854	2	gilt
gite	5	54	3861	2	gite
give	8	58	2935	2	give
glace	8	74	2016	2	glace
glad	6	56	2401	2	glad
glade	7	51	2196	2	glade
glam	7	65	2934	2	glam
glare	6	52	2296	2	glare
glaze	15	54	1816	2	glaze
gled	6	56	3114	2	g_led
glee	5	52	3906	2	glee
gleg	6	62	1980	2	g_leg
glen	5	60	2720	2	g_len
gley	8	57	2465	2	g_ley
glue	5	56	2849	2	glue
goal	5	58	2930	2	goal_
goaled	8	50	1436	2	goaled
goalie	7	4	1316	2	goalie
goals	6	55	2129	2	goals
gold	6	54	3016	2	gold
golem	8	4	1611	2	golem
golf	8	57	3118	2	golf
gone	5	56	3904	2	gone
gore	5	57	4496	2	gore
grace	8	51	2454	2	grace
grade	7	51	2609	2	grade
grape	8	48	2466	2	grape
grate	6	49	3288	2	grate
grave	9	46	2487	2	grave
graze	15	58	2005	2	graze
gree	5	66	4156	2	gree
grue	5	58	2571	2	grue
gude	6	54	2333	2	gude
guile	6	45	2113	2	guile
gul	4	58	3279	2	gul_
gules	6	48	3104	2	gules
gulf	8	49	2942	2	gulf
gull	5	48	2845	2	gull
gulp	7	55	2136	2	gulp
guls	5	59	3085	2	guls
gybe	10	59	1624	2	gybe
gyre	8	47	2276	2	gyre
gyve	11	62	1508	2	gyve
hade	8	54	4019	2	hade
hae	6	73	6400	2	ha_e
hake	11	56	3784	2	hake
haled	9	53	3582	2	haled
haler	8	50	3352	2	haler
hales	8	54	4984	2	hales
half	10	62	3845	2	half
hall	7	57	4116	2	hall
halm	9	58	3497	2	halm
halo	7	64	3732	2	halo
halt	7	60	5630	2	halt
halve	11	48	1892	2	halve
hame	9	70	4313	2	hame
haole	8	48	2008	2	haole
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
have	10	61	3707	2	have
haze	16	48	3339	2	haze
hole	7	75	5339	2	hole
idle	5	54	2376	2	idle
isle	4	51	2170	2	isle
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
jole	11	72	3382	2	jole
kae	7	67	4454	2	ka_e
kales	9	57	3098	2	kales
kame	10	57	2823	2	kame
kane	8	51	3397	2	kane
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
ladle	6	63	2044	2	ladle
lake	8	57	4160	2	lake
lall	4	55	3131	2	lall
lame	6	68	4929	2	lame
lane	4	51	5333	2	lane
lase	4	61	4851	2	lase
late	4	75	6048	2	late
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
mabe	8	57	3336	2	mabe
mace	8	73	4579	2	mace
macle	9	61	2700	2	macle
made	7	54	4024	2	made
mae	5	76	5911	2	ma_e
mage	7	57	3913	2	mage
maile	7	52	3222	2	maile
make	10	55	3789	2	make
males	7	50	4979	2	males
mall	6	46	3937	2	mall
malm	8	51	2998	2	malm
malt	6	62	5481	2	malt
mane	6	50	5203	2	mane
maple	9	55	2114	2	maple
mare	6	47	5933	2	mare
mate	6	51	5422	2	mate
maze	15	54	3498	2	maze
mile	6	63	5257	2	mile
mole	6	62	5183	2	mole
mule	6	52	3697	2	mule
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
nala	4	69	3039	2	nala
naled	6	55	2505	2	naled
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
ogle	5	63	2505	2	ogle
ole	3	71	5521	2	_ole
orle	4	56	3046	2	orle
pace	8	63	4577	2	pace
padle	8	45	2234	2	padle
page	7	60	3610	2	page
pal	5	67	6167	2	pal_
palea	7	50	2866	2	palea
paled	8	55	3872	2	paled
paler	7	54	3693	2	paler
pales	7	57	5380	2	pales
palet	7	46	5080	2	palet
pall	6	50	3934	2	pall
palm	8	53	3136	2	palm
palp	8	58	2857	2	palp
pals	6	69	5135	2	pals
paly	9	58	3553	2	paly
pane	6	49	5029	2	pane
pare	6	67	6084	2	pare
parle	7	58	3616	2	parle
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
pave	9	61	3389	2	pave
pele	6	55	3955	2	pele
pile	6	56	4969	2	pile
pole	6	59	5130	2	pole
pule	6	50	4095	2	pule
quale	14	36	1785	2	quale
race	6	67	4626	2	race
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rales	5	49	4749	2	rales
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rate	4	54	5876	2	rate
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
regale	7	48	2145	2	regale
rile	4	56	5053	2	rile
role	4	58	5182	2	role
rule	4	99	3842	2	rule
sabe	6	61	4057	2	sabe
sable	7	47	3216	2	sable
sade	5	55	4447	2	sade
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
sake	8	52	4496	2	sake
sal	3	64	6288	2	sal_
salep	7	70	2295	2	salep
sales	5	60	5559	2	sales
sall	4	45	4468	2	sall
salp	6	45	3409	2	salp
sals	4	68	5167	2	sals
salt	4	57	5852	2	salt
salve	8	50	2213	2	salve
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sate	4	55	5610	2	sate
save	7	57	4136	2	save
scale	7	46	2914	2	scale
shale	8	53	3283	2	shale
sole	4	60	5367	2	sole
spale	7	49	2921	2	spale
stale	5	56	3710	2	stale
swale	8	52	2159	2	swale
table	7	54	2960	2	table
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
tael	4	60	3071	2	tael
take	8	47	3926	2	take
tala	4	59	3805	2	tala
talc	6	62	2681	2	talc
taler	5	60	3486	2	taler
tales	5	54	5137	2	tales
tali	4	68	3716	2	tali
talk	8	62	3009	2	talk
tall	4	72	4021	2	tall
tame	6	63	4366	2	tame
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
tate	4	47	4860	2	tate
tele	4	50	4087	2	tele
tile	4	54	5144	2	tile
tole	4	60	5290	2	tole
tule	4	57	3587	2	tule
vales	8	54	3426	2	vales
valet	8	43	3787	2	valet
valse	8	51	1752	2	valse
value	8	57	1909	2	value
valve	11	45	1593	2	valve
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vile	7	61	3980	2	vile
vole	7	52	3698	2	vole
wade	8	52	3706	2	wade
wae	6	75	5695	2	wa_e
wage	8	48	3408	2	wage
wake	11	49	3570	2	wake
waled	9	43	3099	2	waled
waler	8	42	2926	2	waler
wales	8	61	4283	2	wales
walk	11	56	2561	2	walk
wall	7	62	3610	2	wall
waly	10	58	3090	2	waly
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
whale	11	55	1743	2	whale
wile	7	59	4437	2	wile
wyle	10	55	1938	2	wyle
yald	8	69	2061	2	yald
yare	7	56	3694	2	yare
yule	7	57	2514	2	yule

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	29872	0.280	638182.1
2	DLD Change Limit	29872	473	0.906	32971.3
3	Display Results	473	473	0.110	4300.0
	(SQL Overall)	178691	473	1.296	137878.9