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

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

331 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
iterate	7	11	1911	(None)
iterated	9	12	1382	1	iterated
iterates	8	13	1782	1	iterates
literate	8	12	1689	1	literate
acerate	9	28	1891	2	acerate
aerate	6	48	3055	2	_aerate
aliterate	9	16	1133	2	aliterate
berate	8	47	2902	2	_berate
cerate	8	48	2946	2	_cerate
citrate	9	22	1680	2	cit_rate
derate	7	45	3123	2	_derate
ideate	7	3	1368	2	ide_ate
ingrate	8	7	1512	2	ingrate
integrate	10	9	1115	2	integrate
interage	9	3	1449	2	interage
irate	5	56	2798	2	i__rate
iterance	10	4	952	2	iterance
iterant	7	3	1778	2	iterant
iterative	12	4	1071	2	iterative
itinerate	9	11	625	2	itinerate
liberate	10	11	1338	2	liberate
literates	9	14	1565	2	literates
literati	8	12	1080	2	literati
nitrate	7	20	1701	2	nit_rate
operate	9	6	1573	2	operate
overate	10	6	2096	2	overate
reiterate	9	4	1293	2	reiterate
stearate	8	3	972	2	stearate
terete	6	3	1933	2	_terete
ternate	7	4	1548	2	_ternate
titrate	7	22	1557	2	titrate
acerated	11	31	1398	3	acerated
acerbate	12	4	753	3	acerbate
acervate	13	3	698	3	acervate
acetate	9	25	1475	3	acetate
acierate	10	3	1181	3	acierate
aerated	8	53	2237	3	_aerated
aerates	7	46	2749	3	_aerates
agemate	10	12	1058	3	agemate
aliterates	10	15	1075	3	aliterates
alliterate	10	8	662	3	~~all~~iterate
altercate	11	4	785	3	altercate
alternate	9	4	811	3	alternate
ameerate	10	3	963	3	ameerate
amirate	9	11	1595	3	amirate
antedate	9	4	969	3	antedate
asperate	10	3	1237	3	asperate
attrite	7	3	1183	3	attrite
aurate	6	44	2647	3	_aurate
aureate	7	25	1528	3	aureate
average	11	5	885	3	average
berake	12	42	1608	3	_berake
berated	10	44	2213	3	_berated
berates	9	41	2687	3	_berates
biforate	13	4	690	3	biforate
birthrate	14	4	530	3	birthrate
biseriate	11	4	767	3	biseriate
biserrate	11	4	578	3	biserrate
biteplate	13	4	446	3	biteplate
borate	8	50	2615	3	_borate
butyrate	13	4	620	3	butyrate
carate	8	47	3400	3	_carate
catenate	10	3	1283	3	catenate
cerated	10	39	2247	3	_cerated
cerates	9	54	2825	3	_cerates
cerite	8	47	2487	3	_cerite
chelate	12	29	1489	3	chelate
cirrate	9	24	1349	3	cirrate
citrated	11	27	1225	3	cit_rated
citrates	10	23	1509	3	cit_rates
crate	7	65	3740	3	__crate
create	8	51	2638	3	cre_ate
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
curate	8	52	2624	3	_curate
deaerate	9	3	1417	3	deaerate
debate	9	44	1919	3	_debate
delate	7	38	2775	3	_delate
derat	6	50	4408	3	_derat_
derated	9	36	2350	3	_derated
derates	8	40	2889	3	_derates
derats	7	46	2506	3	_derats
deuterate	10	4	951	3	deuterate
digerati	10	4	740	3	digerati
disrate	8	14	1852	3	disrate
elate	5	53	3588	3	__elate
elevate	10	11	1037	3	elevate
emeerate	10	4	1010	3	emeerate
emirate	9	10	1583	3	emirate
enate	5	44	2815	3	__enate
enervate	11	4	846	3	enervate
erase	5	49	2549	3	__erase
ergate	7	3	1514	3	__ergate
esterase	8	4	948	3	esterase
eterne	6	3	1172	3	eter_ne
execrate	17	3	965	3	execrate
federate	12	3	1088	3	federate
fermate	12	28	1300	3	_fermate
ferrate	10	30	1404	3	ferrate
figurate	12	3	719	3	figurate
filtrate	11	4	822	3	filtrate
gelate	7	34	2125	3	_gelate
generate	9	3	1290	3	generate
grate	6	49	3288	3	__grate
gyrate	10	49	1252	3	_gyrate
hibernate	14	4	499	3	hibernate
hydrate	14	23	981	3	hydrate
ideated	9	3	1097	3	ide_ated
ideates	8	3	1373	3	ide_ates
illiterate	10	12	589	3	~~ill~~iterate
imamate	11	3	810	3	imamate
imbrute	11	4	491	3	imbrute
imitate	9	3	1087	3	imitate
impetrate	13	4	572	3	impetrate
increate	10	3	1220	3	increate
indurate	9	3	1187	3	indurate
inearth	10	3	704	3	inearth
inebriate	11	4	664	3	inebriate
inert	5	32	3437	3	iner_t_
inerts	6	45	1702	3	iner_ts
inflate	10	3	1231	3	inflate
ingate	7	30	1824	3	i_ngate
ingrates	9	5	1417	3	ingrates
inmate	8	29	1736	3	i_nmate
innate	6	39	1731	3	i_nnate
innervate	12	4	660	3	innervate
instate	7	16	1648	3	instate
integrated	12	8	929	3	integrated
integrates	11	10	1078	3	integrates
intenerate	10	4	874	3	intenerate
interact	10	3	1647	3	interact
interacted	13	4	1121	3	interacted
interacts	11	3	1212	3	interacts
intercaste	12	4	928	3	intercaste
interface	14	4	1017	3	interface
interlace	11	3	1191	3	interlace
intermale	11	7	1230	3	intermale
intermat	10	11	1461	3	intermat_
intermats	11	14	1245	3	intermats
interne	7	32	1815	3	inter_ne
internee	8	27	1852	3	internee
interrace	11	3	1255	3	interrace
interstate	10	7	1097	3	interstate
intertie	8	3	1761	3	intertie
intervale	12	9	1159	3	intervale
intestate	9	15	987	3	intestate
intimate	10	10	1383	3	intimate
intonate	8	3	1092	3	intonate
intreat	7	4	1630	3	intreat_
intreated	10	3	1266	3	intreated
intreats	8	3	1154	3	intreats
intubate	10	4	753	3	intubate
inveterate	13	4	525	3	i~~nve~~terate
iodate	7	3	1350	3	i_odate
irade	6	56	1815	3	i__rade
irater	6	52	1835	3	i__rater
isolate	7	3	1392	3	isolate
itemise	9	9	745	3	itemise
itemize	18	10	615	3	itemize
iterances	11	4	891	3	iterances
iterating	10	3	1425	3	iterating
iteration	9	5	1503	3	iteration
iterum	8	3	790	3	iter_um
itinerated	11	12	493	3	itinerated
itinerates	10	12	613	3	itinerates
karate	10	53	2092	3	_karate
lacerate	10	22	1470	3	lacerate
laterite	8	7	1633	3	laterite
legate	7	29	1745	3	_legate
liberated	12	9	947	3	liberated
liberates	11	10	1294	3	liberates
librate	9	32	1423	3	librate
lineate	7	8	1515	3	line_ate
literacy	13	4	680	3	literacy
literal	7	6	1327	3	litera_l
literals	8	3	1229	3	literals
literary	11	4	775	3	literary
literately	13	4	530	3	literately
literatim	11	12	718	3	literatim
literator	9	4	868	3	literator
literature	10	9	419	3	literature
literatus	9	14	682	3	literatus
litigate	9	4	830	3	litigate
littermate	12	4	319	3	littermate
lyrate	9	41	1210	3	_lyrate
macerate	12	23	1407	3	macerate
maturate	10	3	1262	3	maturate
metate	8	27	2053	3	_metate
meterage	11	4	793	3	meterage
micturate	13	6	664	3	micturate
migrate	10	13	1417	3	migrate
misrate	9	13	1914	3	misrate
mitigate	11	4	869	3	mitigate
moderate	11	7	1099	3	moderate
narrate	7	3	1349	3	narrate
negate	7	29	1557	3	_negate
nervate	10	3	953	3	_nervate
niterie	7	3	1374	3	niter_ie
nitrated	9	22	1315	3	nit_rated
nitrates	8	25	1622	3	nit_rates
nitrite	7	23	1446	3	nit_rite
numerate	10	16	1039	3	numerate
obliterate	12	4	507	3	~~obl~~iterate
obturate	10	7	777	3	obturate
ocreate	9	37	1174	3	ocreate
oleate	6	3	1888	3	ole_ate
operated	11	5	1222	3	operated
operates	10	5	1541	3	operates
orate	5	51	3330	3	__orate
outrate	7	23	2318	3	outrate
overage	11	5	1405	3	overage
overawe	13	5	1146	3	overawe
overhate	14	3	1279	3	overhate
overlate	11	7	1628	3	overlate
overrate	11	6	1569	3	overrate
pedate	9	31	1776	3	_pedate
peerage	10	8	980	3	peerage
petrale	9	3	1262	3	petrale
phenate	12	4	1220	3	phenate
phorate	12	4	1336	3	phorate
picrate	11	20	1414	3	picrate
pileate	9	38	1592	3	pile_ate
pirate	8	23	2288	3	_pirate
prate	7	51	3598	3	__prate
predate	10	6	1689	3	predate
prelate	9	5	1969	3	prelate
prerace	11	4	1412	3	prerace
prorate	9	4	1873	3	prorate
rate	4	54	5876	3	___rate
rebate	8	44	2411	3	_rebate
recrate	9	26	2166	3	recrate
redate	7	41	2468	3	_redate
regrate	8	26	1866	3	regrate
reiterated	11	4	1015	3	reiterated
reiterates	10	4	1200	3	reiterates
relate	6	40	3363	3	_relate
remate	8	44	2868	3	_remate
retrace	9	14	1734	3	retrace
saturate	8	3	1281	3	saturate
sedate	7	30	1981	3	_sedate
senate	6	37	2517	3	_senate
serape	8	48	1841	3	_serape
seriate	7	37	2247	3	_seriate
serrate	7	30	1754	3	serrate
siderite	9	4	1136	3	siderite
situate	7	4	1078	3	sit_uate
state	5	62	3733	3	st__ate
stearates	9	3	945	3	stearates
steerage	9	4	683	3	steerage
stelae	6	37	1648	3	stela_e
stellate	8	3	1050	3	stellate
stere	5	53	2854	3	ster__e
sterile	7	3	1660	3	sterile
sterlet	7	13	1847	3	sterlet
sternite	8	3	1054	3	sternite
stomate	9	3	1312	3	stomate
storage	8	3	1047	3	storage
strafe	9	52	1598	3	st_rafe
strake	10	40	1739	3	st_rake
strata	6	36	1628	3	st_rata
strath	9	32	1637	3	st_rath
strati	6	35	1890	3	st_rati
strette	7	3	1076	3	strette
striate	7	42	1895	3	striate
stylate	10	17	977	3	stylate
tate	4	47	4860	3	_t__ate
tease	5	54	2871	3	_te_ase
teat	4	59	6363	3	_te_at_
teated	7	49	2402	3	_te_ated
teats	5	56	3681	3	_te_ats
telae	5	43	2329	3	_tela_e
tenace	8	27	1569	3	_tenace
terabyte	13	5	355	3	_terabyte
terai	5	35	2548	3	_tera_i
terais	6	40	2351	3	_terais
teraph	11	31	909	3	_teraph
terce	7	57	2184	3	_ter_ce
tercet	8	36	2491	3	_tercet
tergite	8	3	1100	3	_tergite
termite	9	3	1389	3	_termite
terne	5	64	2615	3	_ter_ne
terrace	9	33	1184	3	_terrace
terrae	6	29	1521	3	_terrae
terrane	7	28	1423	3	_terrane
terret	6	34	2562	3	_terret
terse	5	50	2682	3	_ter_se
testae	6	42	1625	3	_testae
testate	7	39	1623	3	_testate
thecate	12	32	1002	3	thecate
thrave	12	60	1027	3	_thrave
tierce	8	33	984	3	tier_ce
tirade	7	3	1169	3	_tirade
titanate	8	9	717	3	titanate
titivate	11	4	680	3	titivate
titrated	9	26	1168	3	titrated
titrates	8	23	1466	3	titrates
togate	7	45	1568	3	_togate
tolerate	8	3	1232	3	tolerate
torte	5	54	3170	3	_tor_te
trace	7	58	2961	3	_t_race
trade	6	50	2604	3	_t_rade
trave	8	52	2303	3	_t_rave
treat	5	62	4035	3	_treat_
treated	8	36	1870	3	_treated
treater	7	42	1983	3	_treater
treats	6	48	2169	3	_treats
treaty	9	44	1435	3	_treaty
trite	5	47	3003	3	_t_rite
triturate	9	4	748	3	triturate
tubate	8	28	1317	3	_tubate
ulcerate	10	3	973	3	ulcerate
uncrate	9	4	1595	3	uncrate
underate	9	9	1860	3	underate
uprate	8	39	1654	3	_uprate
urate	5	54	3216	3	__urate
uterine	7	3	1519	3	uterine
valerate	11	3	1147	3	valerate
velate	9	37	2014	3	_velate
venerate	11	3	1290	3	venerate
verite	9	43	2344	3	_verite
verste	9	45	1563	3	_verste
vibrate	12	28	1152	3	vibrate
vicarate	13	7	860	3	vicarate
vitiate	10	34	1295	3	vit_iate
vittate	10	40	973	3	vit_tate
vituperate	15	5	241	3	vituperate
vizierate	21	4	366	3	vizierate
vizirate	20	4	535	3	vizirate
waterage	12	4	866	3	waterage
witherite	15	4	669	3	witherite
yperite	12	4	989	3	yperite

Search took 7 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.393	454684.5
2	DLD Change Limit	134027	331	5.843	22938.0
3	Display Results	331	331	0.123	2691.1
	(SQL Overall)	178691	331	6.359	28100.5