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

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

472 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
gane	5	51	4530	(None)
ane	3	78	6695	1	_ane
bane	6	52	5043	1	bane
cane	6	66	5312	1	cane
fane	7	53	4357	1	fane
gae	4	64	5770	1	ga_e
gaen	5	73	2960	1	gaen
gage	6	59	3610	1	gage
gale	5	63	4732	1	gale
game	7	66	4432	1	game
gan	4	80	6013	1	gan_
ganef	9	63	2246	1	ganef
ganev	9	55	1386	1	ganev
gang	6	60	3197	1	gang
gape	7	51	3451	1	gape
gate	5	57	4657	1	gate
gave	8	46	3405	1	gave
gaze	14	50	3241	1	gaze
gene	5	62	3722	1	gene
gone	5	56	3904	1	gone
jane	11	50	3148	1	jane
kane	8	51	3397	1	kane
lane	4	51	5333	1	lane
mane	6	50	5203	1	mane
pane	6	49	5029	1	pane
sane	4	59	5434	1	sane
vane	7	55	3469	1	vane
wane	7	63	4472	1	wane
ace	5	96	5683	2	_ace
acne	6	66	2587	2	acne
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
agene	6	56	2158	2	agene
agone	6	59	2455	2	agone
ague	5	57	2592	2	ague
alane	5	61	3561	2	alane
ale	3	65	7234	2	_ale
an	2	118	7908	2	_an_
ana	3	95	5983	2	_ana
and	4	72	4417	2	_and
anes	4	52	5593	2	_anes
anew	7	66	2313	2	_anew
ani	3	77	5118	2	_ani
ant	3	72	7079	2	_ant
ante	4	65	3890	2	_ante
any	6	84	4049	2	_any
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
aye	6	71	5176	2	_aye
babe	8	68	3582	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
ban	5	83	6684	2	ban_
band	7	67	4091	2	band
baned	8	54	3635	2	baned
banes	7	49	4558	2	banes
bang	7	48	3700	2	bang
bani	6	53	3496	2	bani
bank	10	58	3575	2	bank
bans	6	65	5514	2	bans
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
bene	6	64	3949	2	bene
bine	6	66	5086	2	bine
bone	6	59	4932	2	bone
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
came	8	76	4875	2	came
can	5	77	6014	2	can_
caned	8	58	3809	2	caned
caner	7	53	3477	2	caner
canes	7	53	5037	2	canes
canoe	7	56	2725	2	canoe
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
cape	8	72	4278	2	cape
care	6	69	6837	2	care
case	6	58	4808	2	case
cate	6	62	5460	2	cate
cave	9	59	4126	2	cave
cine	6	62	4294	2	cine
cone	6	72	5696	2	cone
crane	7	53	3160	2	crane
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dan	4	68	5967	2	dan_
dance	8	52	2313	2	dance
dang	6	51	3154	2	dang
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
dene	5	66	4341	2	dene
dine	5	55	5533	2	dine
done	5	57	4791	2	done
dune	5	61	3758	2	dune
dyne	8	53	2093	2	dyne
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
erne	4	67	2743	2	erne
esne	4	70	1879	2	esne
eyne	7	63	2246	2	eyne
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
fan	6	71	5886	2	fan_
fanes	8	46	3989	2	fanes
fang	8	54	3255	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fare	7	63	5446	2	fare
fate	7	54	4428	2	fate
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fine	7	51	4795	2	fine
gab	6	71	5599	2	ga_b
gable	8	53	2552	2	gable
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
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
gags	6	64	4106	2	gags
gain	5	60	4216	2	gain
gained	8	46	1746	2	gained
gainer	7	41	1749	2	gainer
gains	6	57	2951	2	gains
gait	5	61	5019	2	gait
gal	4	60	5551	2	ga_l
gala	5	56	3516	2	gala
galea	6	47	2293	2	galea
gales	6	54	4248	2	gales
gall	5	63	3599	2	gall
gals	5	79	4650	2	gals
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
gamed	9	51	2639	2	gamed
gamer	8	49	2894	2	gamer
games	8	62	3855	2	games
gamey	11	53	2055	2	gamey
gamine	9	46	2015	2	gamine
gamp	9	88	3321	2	gamp
gams	7	66	4888	2	gams
gamy	10	54	2753	2	gamy
gander	8	43	2276	2	gander
ganefs	10	48	920	2	ganefs
ganevs	10	45	691	2	ganevs
ganged	9	46	1919	2	ganged
ganger	8	37	2146	2	ganger
gangs	7	62	2257	2	gangs
gangue	8	13	1057	2	gangue
ganja	13	14	1000	2	ganja
gannet	7	43	2185	2	gannet
ganof	9	54	2036	2	ganof
gaol	5	69	2541	2	gaol
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
garner	7	39	1700	2	garner
garnet	7	39	2841	2	garnet
garni	6	3	1570	2	garni
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
gaum	7	57	2642	2	gaum
gaun	5	64	2771	2	gaun
gaunt	6	54	3040	2	gaunt
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
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
gen	4	59	5051	2	gen_
genes	6	51	3309	2	genes
genet	6	60	3868	2	genet
genie	6	61	2492	2	genie
genre	6	60	1680	2	genre
gens	5	57	4007	2	gens
gent	5	69	5439	2	gent
genu	5	59	2907	2	genu
ghee	8	57	2611	2	ghee
giant	6	54	3059	2	giant
gibe	7	59	2778	2	gibe
gie	4	71	4954	2	g_ie
gien	5	63	3002	2	gien
gin	4	60	5575	2	gin_
gink	9	71	2952	2	gink
gins	5	55	4395	2	gins
gite	5	54	3861	2	gite
give	8	58	2935	2	give
glace	8	74	2015	2	glace
glade	7	51	2196	2	glade
glance	9	43	1231	2	glance
gland	7	52	1771	2	gland
glans	6	51	2583	2	glans
glare	6	52	2295	2	glare
glaze	15	54	1816	2	glaze
glee	5	52	3906	2	glee
glen	5	60	2720	2	glen
glue	5	56	2849	2	glue
gnar	5	60	2138	2	gnar
gnat	5	60	3443	2	gnat
gnaw	8	65	1574	2	gnaw
gnu	4	55	2204	2	g_nu
gonef	9	52	2129	2	gonef
goner	6	60	2516	2	goner
gong	6	68	2719	2	gong
gore	5	57	4496	2	gore
grace	8	51	2454	2	grace
grade	7	51	2609	2	grade
gran	5	63	3501	2	gran_
grana	6	57	2209	2	grana
grand	7	51	2269	2	grand
grange	8	37	1620	2	grange
grans	6	48	3254	2	grans
grant	6	48	4002	2	grant
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
guan	5	53	2558	2	guan_
guano	6	92	1398	2	guano
guans	6	44	1944	2	guans
gude	6	54	2333	2	gude
gun	4	72	4080	2	gun_
gunk	9	54	2357	2	gunk
guns	5	55	3348	2	guns
gwine	9	55	1366	2	gwine
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
haen	7	62	2945	2	haen
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
hame	9	70	4313	2	hame
hance	10	54	2415	2	hance
hand	8	68	3371	2	hand
hang	8	55	3555	2	hang
hank	11	51	3414	2	hank
hanse	8	57	2279	2	hanse
hant	7	54	6159	2	hant
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
have	10	61	3707	2	have
haze	16	48	3339	2	haze
hone	7	75	4932	2	hone
inane	5	28	2034	2	inane
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
janes	12	49	2812	2	janes
jape	13	49	2342	2	jape
kae	7	67	4454	2	ka_e
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kana	8	59	2853	2	kana
kanes	9	55	2937	2	kanes
kine	8	56	4343	2	kine
kune	8	54	2457	2	kune
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lance	7	51	2672	2	lance
land	5	63	3731	2	land
lanes	5	49	4679	2	lanes
lang	5	66	3738	2	lang
lank	8	47	3445	2	lank
lase	4	61	4851	2	lase
late	4	75	6048	2	late
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
liane	5	47	2066	2	liane
line	4	69	6557	2	line
lone	4	58	4913	2	lone
lune	4	71	4049	2	lune
mabe	8	57	3336	2	mabe
mace	8	73	4579	2	mace
made	7	54	4024	2	made
mae	5	76	5911	2	ma_e
mage	7	57	3913	2	mage
make	10	55	3789	2	make
male	6	60	5230	2	male
man	5	74	6587	2	man_
mana	6	53	4196	2	mana
maned	8	66	3410	2	maned
manes	7	66	4896	2	manes
mange	8	49	3019	2	mange
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
manse	7	55	2823	2	manse
many	9	57	3186	2	many
mare	6	47	5933	2	mare
mate	6	51	5422	2	mate
maze	15	54	3498	2	maze
mine	6	72	5617	2	mine
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nan	3	78	5488	2	nan_
nana	4	66	3290	2	nana
nance	7	47	2184	2	nance
nans	4	61	3940	2	nans
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
ne	2	70	4510	2	__ne
nene	4	59	3206	2	nene
nine	4	58	4217	2	nine
none	4	57	4317	2	none
one	3	70	5091	2	_one
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pale	6	60	5501	2	pale
pan	5	84	6645	2	pan_
paned	8	54	3718	2	paned
panel	7	60	2362	2	panel
panes	7	61	4869	2	panes
pang	7	53	3629	2	pang
panne	7	66	2365	2	panne
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
pare	6	67	6084	2	pare
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
pave	9	61	3389	2	pave
pine	6	77	5571	2	pine
plane	7	49	2914	2	plane
pone	6	57	4753	2	pone
race	6	67	4626	2	race
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
ran	3	82	6662	2	ran_
rance	7	50	2851	2	rance
rand	5	58	3957	2	rand
ranee	5	54	3810	2	ranee
rang	5	69	3916	2	rang
range	6	47	2841	2	range
rani	4	66	4011	2	rani
rank	8	51	3553	2	rank
rant	4	58	6468	2	rant
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
rune	4	52	3630	2	rune
sabe	6	61	4057	2	sabe
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
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sand	5	53	3847	2	sand
saned	6	56	3627	2	saned
saner	5	43	3432	2	saner
sanes	5	56	4907	2	sanes
sang	5	54	4123	2	sang
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
sate	4	55	5610	2	sate
save	7	57	4136	2	save
sene	4	68	4805	2	sene
sine	4	65	6062	2	sine
sone	4	66	4998	2	sone
stane	5	59	3300	2	stane
syne	7	57	2576	2	syne
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tame	6	63	4366	2	tame
tan	3	71	6757	2	tan_
tang	5	61	3867	2	tang
tank	8	51	3402	2	tank
tans	4	61	5482	2	tans
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
tate	4	47	4860	2	tate
thane	8	61	2253	2	thane
tine	4	58	5513	2	tine
tone	4	69	5374	2	tone
tune	4	56	3586	2	tune
tyne	7	63	2505	2	tyne
vale	7	49	3734	2	vale
van	6	62	4633	2	van_
vaned	9	46	2242	2	vaned
vanes	8	51	3097	2	vanes
vang	8	49	2604	2	vang
vans	7	62	3673	2	vans
vase	7	56	2965	2	vase
vine	7	56	4368	2	vine
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
wale	7	45	4643	2	wale
wame	9	50	3548	2	wame
wan	6	67	6194	2	wan_
wand	8	58	3388	2	wand
waned	9	58	3178	2	waned
wanes	8	50	4088	2	wanes
waney	11	51	2032	2	waney
wank	11	56	3251	2	wank
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wany	10	64	3236	2	wany
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
wine	7	49	5342	2	wine
yang	8	56	2607	2	yang
yank	11	54	2367	2	yank
yare	7	56	3694	2	yare
zany	16	73	1699	2	zany
zine	13	70	3615	2	zine
zone	13	52	3108	2	zone

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	472	1.093	27330.3
3	Display Results	472	472	0.110	4290.9
	(SQL Overall)	178691	472	1.483	120492.9