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

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

277 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
climate	11	3	1283	(None)
climates	12	3	1197	1	climates
acclimate	15	4	623	2	acclimate
animate	9	16	1721	2	animate
califate	13	3	1048	2	califate
celibate	12	5	931	2	celibate
cellmate	12	3	787	2	cellmate
ciliate	9	5	1460	2	ciliate
clavate	12	3	871	2	clavate
climatal	12	4	440	2	climatal
climatic	14	4	873	2	climatic
climatize	22	13	675	2	climatize
climax	17	3	565	2	clima_x
climaxed	20	4	311	2	climaxed
climaxes	19	4	461	2	climaxes
clime	9	57	2089	2	clim__e
coinmate	12	3	906	2	coinmate
collimate	13	4	817	2	collimate
comate	10	41	2484	2	c_omate
cremate	11	38	1618	2	cremate
ligate	7	25	1925	2	_ligate
limbate	11	3	921	2	_limbate
plicate	11	3	1451	2	plicate
plumate	11	4	980	2	plumate
primate	11	15	1628	2	primate
ultimate	10	4	920	2	ultimate
acclimated	17	4	515	3	acclimated
acclimates	16	4	591	3	acclimates
activate	13	5	1037	3	activate
agemate	10	12	1058	3	agemate
agitate	8	3	1206	3	agitate
alate	5	53	4033	3	al__ate
alginate	9	3	1069	3	alginate
alidade	9	3	699	3	alidade
alienate	8	3	1155	3	alienate
amirate	9	11	1595	3	amirate
animated	11	16	1237	3	animated
animater	10	15	1239	3	animater
animates	10	13	1642	3	animates
animato	9	16	1062	3	animato
aviate	9	3	1520	3	avi_ate
bedmate	12	3	943	3	bedmate
binate	8	4	1977	3	_binate
blate	7	59	3378	3	bl__ate
blite	7	62	2535	3	bli__te
bromate	11	3	1355	3	bromate
cabinmate	15	4	409	3	cabinmate
caiman	10	36	1566	3	caima_n
caimans	11	38	1178	3	caimans
calamata	12	4	755	3	calamata
calamite	12	3	1253	3	calamite
calceate	12	3	986	3	calceate
calibrate	13	4	774	3	calibrate
califates	14	3	1011	3	califates
caliphate	16	4	529	3	caliphate
calycate	15	3	789	3	calycate
capitate	12	17	1218	3	capitate
carate	8	47	3400	3	c_arate
carinate	10	33	2025	3	carinate
caseate	9	3	1478	3	caseate
casemate	12	3	984	3	casemate
cate	6	62	5460	3	c___ate
caudate	10	3	1135	3	caudate
cavitate	13	15	983	3	cavitate
celibates	13	5	863	3	celibates
cellmates	13	4	751	3	cellmates
celomata	12	9	663	3	celomata
cerate	8	48	2946	3	c_erate
chamade	15	13	845	3	chamade
chelate	12	29	1489	3	chelate
chicane	14	8	955	3	chicane
chimar	13	39	1147	3	chima_r
chimars	14	40	1059	3	chimars
chime	12	53	2259	3	chim__e
chimere	14	40	1063	3	chimere
chlorate	13	31	1269	3	chlorate
cholate	12	21	1493	3	cholate
chromate	15	3	1278	3	chromate
cicale	10	3	1450	3	c_icale
ciliated	11	5	1095	3	ciliated
ciliates	10	4	1345	3	ciliates
ciliolate	11	4	597	3	ciliolate
cirrate	9	24	1349	3	cirrate
cite	6	56	4034	3	c_i__te
citrate	9	22	1680	3	citrate
clade	8	58	2101	3	cl__ade
claimable	15	4	570	3	claimable
claimant	12	4	748	3	claimant
claimants	13	4	428	3	claimants
clamant	11	3	1243	3	clamant
clambake	18	4	389	3	clambake
classmate	13	4	486	3	classmate
clave	10	54	2015	3	cl__ave
cleat	7	63	3506	3	cl_eat_
cleated	10	34	1784	3	cl_eated
cleats	8	49	1931	3	cl_eats
cleave	11	42	1251	3	cl_eave
clematis	12	4	865	3	clematis
cliche	13	37	1245	3	cli_che
client	8	3	1634	3	client_
clients	9	3	809	3	clients
clift	10	64	2219	3	cli_ft_
clifts	11	51	915	3	cli_fts
climactic	14	4	342	3	climactic
climatized	24	11	512	3	climatized
climatizes	23	11	613	3	climatizes
climb	11	54	1359	3	clim__b
climbable	17	4	360	3	climbable
climbed	14	33	698	3	climbed
climber	13	44	913	3	climber
climbs	12	49	872	3	clim_bs
climes	10	47	2000	3	clim_es
clinal	8	3	1155	3	clina_l
cline	7	64	2853	3	cli__ne
clipt	9	63	2427	3	cli_pt_
clique	17	28	919	3	cli_que
clodpate	13	4	408	3	clodpate
clypeate	15	4	387	3	clypeate
cnidae	9	7	814	3	cnida_e
coelomate	13	9	811	3	coelomate
cogitate	11	4	855	3	cogitate
cognate	10	3	1220	3	cognate
coinage	10	3	1055	3	coinage
coinmates	13	4	834	3	coinmates
collate	9	29	1968	3	collate
colligate	12	4	829	3	colligate
collimated	15	5	608	3	collimated
collimates	14	4	797	3	collimates
colocate	12	3	1344	3	colocate
comade	11	44	1532	3	c_omade
comae	9	71	2842	3	c_oma_e
comake	14	44	1342	3	c_omake
comates	11	41	2364	3	c_omates
commata	13	3	848	3	commata
commute	13	43	1044	3	commute
comte	9	61	2547	3	c_om_te
connate	9	3	1575	3	connate
copemate	14	3	999	3	copemate
cordate	10	3	1522	3	cordate
costate	9	40	1927	3	costate
crate	7	65	3740	3	c__rate
create	8	51	2638	3	c_reate
cremated	13	34	1296	3	cremated
cremates	12	42	1600	3	cremates
crenate	9	33	1711	3	crenate
crewmate	15	40	563	3	crewmate
crime	9	48	2269	3	crim__e
criminate	13	4	898	3	criminate
crimine	11	24	1347	3	crimine
crimple	13	40	869	3	crimple
crinite	9	5	1363	3	crinite
crispate	12	4	691	3	crispate
cristae	9	3	1061	3	cristae
cristate	10	3	1060	3	cristate
culminate	13	4	781	3	culminate
cultivate	14	4	708	3	cultivate
cultrate	10	3	1087	3	cultrate
cuneate	9	3	1172	3	cuneate
curate	8	52	2624	3	c_urate
curtate	9	3	1264	3	curtate
cuspate	11	3	823	3	cuspate
cyanate	12	25	970	3	cyanate
cyclamate	18	4	379	3	cyclamate
cymae	12	67	1301	3	c_yma_e
decimate	13	4	1112	3	decimate
delicate	11	3	1549	3	delicate
dilate	7	32	2069	3	_dilate
echinate	13	5	940	3	echinate
elate	5	53	3588	3	el__ate
elevate	10	11	1037	3	elevate
eliminate	11	4	773	3	eliminate
elite	5	62	3018	3	eli__te
eluate	6	23	1543	3	el_uate
emirate	9	10	1583	3	emirate
epilate	9	3	1428	3	epilate
estimate	10	9	1200	3	estimate
fermate	12	28	1300	3	fermate
filiate	10	4	1423	3	filiate
fixate	16	3	873	3	_fixate
flatmate	13	4	639	3	flatmate
flite	8	54	2496	3	fli__te
foliate	10	5	1353	3	foli_ate
formate	12	31	1509	3	formate
frigate	11	3	1106	3	frigate
gemmate	12	41	838	3	gemmate
glime	8	56	2019	3	glim__e
glimpse	12	3	376	3	glimpse
gliomata	11	4	354	3	gliomata
globate	10	5	782	3	globate
grimace	12	5	508	3	grimace
hamate	11	33	1983	3	_hamate
helpmate	15	4	560	3	helpmate
humate	11	32	1444	3	_humate
image	8	14	1129	3	__image
imamate	11	3	810	3	imamate
imitate	9	3	1087	3	imitate
inmate	8	29	1736	3	_inmate
intimate	10	10	1383	3	intimate
irate	5	56	2798	3	__irate
kalifate	15	5	649	3	kalifate
lanate	6	4	2126	3	_lanate
late	4	75	6048	3	_l__ate
legate	7	29	1745	3	_legate
liane	5	47	2066	3	_li_ane
librate	9	32	1423	3	_librate
ligase	7	25	991	3	_ligase
ligated	9	24	1414	3	_ligated
ligates	8	23	1838	3	_ligates
lima	6	57	3413	3	_lima__
liman	7	59	2160	3	_lima_n
limans	8	48	1630	3	_limans
limas	7	56	2763	3	_lima_s
lime	6	62	4493	3	_lim__e
limeade	10	7	612	3	_limeade
limit	7	31	2634	3	_limit_
limited	10	23	1023	3	_limited
limiter	9	27	1085	3	_limiter
limites	9	29	1545	3	_limites
limits	8	25	1414	3	_limits
limpet	10	35	1863	3	_limpet
linage	7	7	1340	3	_linage
lineate	7	8	1515	3	_lineate
lipase	8	23	910	3	_lipase
liquate	16	3	842	3	_liquate
lite	4	70	5454	3	_li__te
lobate	8	29	1524	3	_lobate
locate	8	39	1984	3	_locate
lunate	6	3	1604	3	_lunate
luxate	13	3	808	3	_luxate
lyrate	9	41	1210	3	_lyrate
lysate	9	38	810	3	_lysate
mammate	10	44	1127	3	mammate
mate	6	51	5422	3	___mate
militate	10	3	1167	3	militate
misate	8	12	2269	3	_misate
mismate	11	14	1535	3	mismate
nidate	7	3	1378	3	_nidate
obligate	11	19	830	3	obligate
oleate	6	3	1888	3	ol_eate
opiate	8	5	1346	3	opi_ate
oxidate	15	3	702	3	oxidate
palmate	11	32	1523	3	palmate
pileate	9	38	1592	3	pileate
pirate	8	23	2288	3	_pirate
placate	11	3	1243	3	placate
planate	9	3	1457	3	planate
plate	7	46	3511	3	pl__ate
playmate	15	6	646	3	playmate
plicae	10	4	1095	3	plica_e
plicated	13	3	1064	3	plicated
plumage	12	4	550	3	plumage
primage	12	16	914	3	primage
primates	12	15	1593	3	primates
private	12	15	1326	3	private
quinate	16	5	1157	3	quinate
ramate	8	39	2169	3	_ramate
reclinate	11	4	1002	3	reclinate
reimage	10	3	791	3	reimage
remate	8	44	2868	3	_remate
ruinate	7	3	1283	3	ruinate
salivate	11	3	1001	3	salivate
shipmate	15	4	615	3	shipmate
sigmate	10	7	1014	3	sigmate
silicate	10	3	1262	3	silicate
slate	5	54	3828	3	sl__ate
slime	7	49	2575	3	slim__e
spicate	11	32	1419	3	spicate
spinate	9	31	1481	3	spinate
stomate	9	3	1312	3	stomate
sublimate	13	4	744	3	sublimate
summate	11	36	1166	3	summate
ultimata	10	5	556	3	ultimata
ultimated	12	4	731	3	ultimated
ultimates	11	4	843	3	ultimates
ululate	7	4	996	3	ululate
urinate	7	3	1536	3	urinate
validate	12	3	900	3	validate

Search took 9 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.403	443402.0
2	DLD Change Limit	134027	277	7.876	17017.1
3	Display Results	277	277	0.110	2518.2
	(SQL Overall)	178691	277	8.389	21300.6