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

Here are the results of your fuzzy-string dictionary search for “gestate” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

307 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
gestate	8	36	1407	(None)
estate	6	47	1976	1	_estate
gestated	10	29	1057	1	gestated
gestates	9	32	1373	1	gestates
restate	7	38	2488	1	restate
testate	7	39	1623	1	testate
bistate	9	3	1382	2	bistate
costate	9	40	1927	2	costate
dentate	8	3	1515	2	dentate
estated	8	37	1557	2	_estated
estates	7	45	2018	2	_estates
gelate	7	34	2126	2	ge_late
gemmate	12	41	838	2	gemmate
gestalt	8	4	1117	2	gestalt
gestalten	10	4	271	2	gestalten
gestalts	9	5	549	2	gestalts
gestapo	10	4	449	2	gestapo
gestative	13	4	730	2	gestative
geste	6	59	2069	2	ges__te
gesture	8	3	924	2	gesture
guttate	8	32	890	2	guttate
hastate	10	3	1391	2	hastate
hesitate	11	6	997	2	hesitate
instate	7	16	1648	2	instate
metate	8	27	2053	2	me_tate
pectate	11	22	1469	2	pectate
peltate	9	20	1377	2	peltate
reslate	7	35	2059	2	reslate
restage	8	33	1619	2	restage
restated	9	31	2018	2	restated
restates	8	34	2344	2	restates
septate	9	5	1187	2	septate
state	5	62	3733	2	__state
testae	6	42	1625	2	testa_e
testates	8	36	1545	2	testates
unstate	7	19	1621	2	unstate
upstate	9	16	1049	2	upstate
acetate	9	25	1475	3	acetate
aerate	6	48	3055	3	ae_rate
aesthete	11	4	585	3	aesthete
aestivate	12	12	766	3	aestivate
agemate	10	12	1058	3	age_mate
agitate	8	3	1206	3	agitate
ansate	6	45	1786	3	ans_ate
apostate	10	4	985	3	apostate
aristate	8	3	1213	3	aristate
astute	6	3	1076	3	_astute
bedmate	12	3	943	3	bedmate
berate	8	47	2902	3	be_rate
beshame	14	4	748	3	beshame
bespake	15	43	696	3	bespake
betake	12	45	1270	3	be_take
caseate	9	3	1478	3	caseate
castrate	10	3	1386	3	castrate
centare	9	31	1370	3	centare
cerate	8	48	2946	3	ce_rate
cesta	7	54	1948	3	cesta__
cestas	8	50	1854	3	cesta_s
cestode	10	3	796	3	cestode
cetane	8	3	1528	3	ce_tane
costae	8	53	1968	3	costa_e
cristate	10	3	1060	3	cristate
curtate	9	3	1264	3	curtate
cuspate	11	3	823	3	cuspate
dealate	8	36	1784	3	dealate
debate	9	44	1919	3	de_bate
deflate	11	36	1394	3	deflate
delate	7	38	2775	3	de_late
dentated	10	4	1170	3	dentated
derate	7	45	3123	3	de_rate
desolate	9	4	1199	3	desolate
despite	10	4	1012	3	despite
destain	8	4	1208	3	destain
destine	8	37	1995	3	destine
devastate	13	4	495	3	devastate
deviate	11	3	1272	3	deviate
dictate	10	3	1166	3	dictate
disrate	8	14	1852	3	disrate
distaste	9	3	994	3	distaste
edentate	9	4	770	3	edentate
egesta	7	42	865	3	egesta__
egestive	12	4	683	3	egestive
elate	5	53	3588	3	_e_late
eluate	6	23	1543	3	_eluate
enate	5	44	2815	3	_e_nate
equate	15	20	1246	3	_equate
ergate	7	3	1514	3	_ergate
escape	10	38	1166	3	_escape
esthete	10	4	743	3	_esthete
estimate	10	9	1200	3	_estimate
estivate	11	10	1000	3	_estivate
etape	7	44	1370	3	_e_tape
fellate	10	3	1343	3	fellate
fermate	12	28	1300	3	fermate
ferrate	10	30	1404	3	ferrate
festal	9	42	1356	3	festa_l
festinate	12	4	947	3	festinate
festive	13	3	977	3	festive
fissate	10	30	1003	3	fissate
fossate	10	38	860	3	fossate
galeate	8	39	1679	3	galeate
gallate	8	34	1713	3	gallate
gate	5	57	4657	3	g___ate
gelated	9	36	1564	3	ge_lated
gelates	8	32	1959	3	ge_lates
gelati	7	38	1453	3	ge_lati
gelato	7	38	1296	3	ge_lato
geminate	11	4	1181	3	geminate
gemmae	11	50	779	3	gemma_e
gemmated	14	33	629	3	gemmated
gemmates	13	30	767	3	gemmates
gemote	9	46	1302	3	ge_mote
gemstone	11	4	584	3	gemstone
generate	9	3	1290	3	generate
genette	8	3	886	3	genette
gentile	8	35	1529	3	gentile
gentle	7	40	1451	3	gent_le
geotaxes	16	4	474	3	geotaxes
germane	10	4	966	3	germane
gest	5	61	4913	3	ges__t_
gestapos	11	5	391	3	gestapos
gestating	11	22	998	3	gestating
gestation	10	3	1066	3	gestation
gestatory	13	4	452	3	gestatory
gestes	7	57	2139	3	gest_es
gestic	9	3	1277	3	gest_ic
gests	6	60	2881	3	ges__ts
gestured	10	3	699	3	gestured
gesturer	9	3	598	3	gesturer
gestures	9	3	1001	3	gestures
geta	5	66	2744	3	ge_ta__
getable	10	17	1255	3	ge_table
getas	6	54	2148	3	ge_ta_s
gettable	11	17	813	3	gettable
getter	7	41	1761	3	ge_t_ter
globate	10	5	782	3	globate
gradate	9	5	1123	3	gradate
grate	6	49	3288	3	g__rate
gustable	11	13	820	3	gustable
gustative	13	4	568	3	gustative
guttae	7	32	1058	3	gutta_e
guttated	10	26	687	3	guttated
gyrate	10	49	1252	3	g_yrate
hebetate	13	4	705	3	hebetate
hectare	12	3	847	3	hectare
hektare	14	3	551	3	hektare
heptane	12	3	836	3	heptane
hesitated	13	7	778	3	hesitated
hesitater	12	7	692	3	hesitater
hesitates	12	6	979	3	hesitates
hessite	10	3	899	3	hessite
hostage	11	31	1123	3	hostage
imitate	9	3	1087	3	imitate
instated	9	16	1334	3	instated
instates	8	16	1583	3	instates
intestate	9	15	987	3	intestate
lactate	9	3	1270	3	lactate
legate	7	29	1745	3	le_gate
levitate	11	3	793	3	levitate
lustrate	8	3	1044	3	lustrate
lysate	9	38	810	3	lys_ate
mediate	10	34	1521	3	mediate
meditate	11	3	1062	3	meditate
meltage	10	3	795	3	meltage
message	10	3	783	3	message
messmate	12	4	639	3	messmate
mestee	8	45	2388	3	mest_ee
metage	9	31	1445	3	me_tage
metates	9	27	2001	3	me_tates
misate	8	12	2269	3	mis_ate
misdate	10	14	1396	3	misdate
mismate	11	14	1535	3	mismate
misrate	9	13	1914	3	misrate
misstate	10	7	1134	3	misstate
mistake	13	13	1262	3	mistake
mutate	8	30	1748	3	_mutate
negate	7	29	1557	3	ne_gate
neonate	7	3	1133	3	neonate
nervate	10	3	953	3	nervate
nestable	10	16	1367	3	nestable
nestle	6	30	1395	3	nest_le
nictate	9	3	1022	3	nictate
notate	6	32	1786	3	_notate
nutate	6	30	1737	3	_nutate
onstage	8	3	836	3	onstage
outate	6	29	2340	3	_outate
outstate	8	14	1199	3	outstate
overstate	12	10	1086	3	overstate
pectase	11	24	1036	3	pectase
pectates	12	22	1395	3	pectates
pedate	9	31	1776	3	pe_date
pennate	9	33	1403	3	pennate
pentane	9	4	1574	3	pentane
pesade	9	3	1110	3	pes_ade
pestle	8	32	1584	3	pest_le
petite	8	43	2065	3	pe_tite
postage	10	32	1485	3	postage
postdate	11	3	965	3	postdate
prostate	10	3	1453	3	prostate
rebate	8	44	2411	3	re_bate
recrate	9	26	2166	3	recrate
redate	7	41	2468	3	re_date
reflate	10	35	1626	3	reflate
regrate	8	26	1866	3	regrate
reinstate	9	4	890	3	reinstate
relate	6	40	3363	3	re_late
remate	8	44	2868	3	re_mate
replate	9	34	2005	3	replate
resale	6	40	2554	3	res_ale
resat	5	51	3968	3	res_at_
rescale	9	32	1548	3	rescale
reseat	6	41	3149	3	reseat_
reseated	9	32	2026	3	reseated
reseats	7	43	1959	3	reseats
reshape	12	4	904	3	reshape
reshave	13	3	860	3	reshave
resinate	8	3	1677	3	resinate
resite	6	41	2845	3	res_ite
resituate	9	4	861	3	resituate
reslated	9	35	1752	3	reslated
reslates	8	36	1951	3	reslates
resonate	8	5	1351	3	resonate
respace	11	3	1091	3	respace
respade	10	3	957	3	respade
respite	9	5	1303	3	respite
restable	10	16	1844	3	restable
restack	13	3	943	3	restack
restaff	13	3	901	3	restaff
restaged	10	30	1186	3	restaged
restages	9	28	1577	3	restages
restamp	11	4	648	3	restamp
restart	7	3	2003	3	restart
restarted	10	4	1005	3	restarted
restarts	8	3	1087	3	restarts
restive	10	3	1593	3	restive
restoke	11	61	1390	3	restoke
restore	7	58	2298	3	restore
restyle	10	3	876	3	restyle
retake	10	47	1853	3	re_take
retape	8	39	1768	3	re_tape
retaste	7	23	1313	3	re_taste
roseate	7	6	1345	3	roseate
rostrate	8	3	1384	3	rostrate
rotate	6	33	2034	3	_rotate
sate	4	55	5610	3	__s_ate
scutate	9	3	1032	3	scutate
seatmate	10	4	857	3	seatmate
sedate	7	30	1981	3	se_date
senate	6	37	2517	3	se_nate
sensate	7	3	1189	3	sensate
septage	10	7	840	3	septage
seriate	7	37	2247	3	seriate
serrate	7	30	1754	3	serrate
sesame	8	3	1101	3	ses_ame
sestet	6	8	2620	3	sestet_
sestets	7	9	1147	3	sestets
sestine	7	30	1792	3	sestine
setae	5	60	2622	3	se_ta_e
skate	9	47	2155	3	__skate
slate	5	54	3828	3	__slate
spate	7	47	3158	3	__spate
spectate	12	24	883	3	spectate
stacte	8	21	1391	3	__stacte
stade	6	48	2530	3	__stade
stage	6	53	3019	3	__stage
stake	9	59	2753	3	__stake
stale	5	56	3710	3	__stale
stane	5	59	3300	3	__stane
stare	5	44	4026	3	__stare
stat	4	73	5269	3	__stat_
stated	7	54	2783	3	__stated
stater	6	44	2756	3	__stater
states	6	43	3708	3	__states
stats	5	59	3336	3	__stats
statue	6	60	1532	3	__statue
stave	8	53	2499	3	__stave
substate	10	17	1109	3	substate
tate	4	47	4860	3	___tate
tectite	9	3	1058	3	tectite
tektite	11	3	688	3	tektite
tentage	8	10	1064	3	tentage
ternate	7	4	1548	3	ternate
testa	5	48	2204	3	testa__
testable	10	14	1262	3	testable
testacy	12	3	596	3	testacy
testator	8	4	737	3	testator
testee	6	43	2330	3	test_ee
tristate	8	3	1103	3	tristate
unstated	9	16	1581	3	unstated
unstates	8	13	1499	3	unstates
upstage	10	16	744	3	upstage
upstare	9	15	868	3	upstare
upstater	10	15	666	3	upstater
upstates	10	18	964	3	upstates
vegetate	12	4	667	3	vegetate
velate	9	37	2014	3	ve_late
ventage	11	10	962	3	ventage
vesicate	13	12	1005	3	vesicate
vesta	8	66	1830	3	vesta__
vestal	9	46	1557	3	vesta_l
vestals	10	46	1233	3	vestals
vestas	9	59	1668	3	vesta_s
vestee	9	43	1915	3	vest_ee
vestige	11	3	743	3	vestige
vesture	10	3	1037	3	vesture
vittate	10	40	973	3	vittate
wastage	11	10	925	3	wastage

Search took 8 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	134027	0.390	458182.1
2	DLD Change Limit	134027	307	7.003	19138.5
3	Display Results	307	307	0.123	2495.9
	(SQL Overall)	178691	307	7.516	23774.7