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

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

460 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
crista	8	3	1180	(None)
arista	6	4	1529	1	arista
crissa	8	3	762	1	crissa
cristae	9	3	1060	1	cristae
aristae	7	3	1252	2	aristae
aristas	7	4	1352	2	aristas
aristo	6	4	1403	2	aristo
barista	9	3	1081	2	barista
casita	8	29	1370	2	casita
cesta	7	54	1948	2	c_esta
chrisma	14	5	682	2	chrisma
christy	15	3	662	2	christy
cist	6	72	4496	2	c_ist_
cists	7	66	2453	2	c_ists
costa	7	55	2373	2	c_osta
crest	7	46	3269	2	crest_
crestal	9	3	1213	2	crestal
crests	8	52	1870	2	crests
cris	6	62	3343	2	cris__
crises	8	45	2943	2	crises
crisic	10	36	1184	2	crisic
crisis	8	37	1634	2	crisis
crisp	9	50	1462	2	cris_p
crisps	10	44	1151	2	crisps
crispy	13	47	856	2	crispy
crissal	9	3	741	2	crissal
cristate	10	3	1059	2	cristate
crit	6	57	4371	2	cri_t_
crits	7	55	2757	2	cri_ts
crust	7	58	2766	2	crust_
crustal	9	3	902	2	crustal
crusts	8	49	1654	2	crusts
crusty	11	49	1134	2	crusty
crystal	12	3	743	2	crystal
cuesta	8	3	851	2	cuesta
frusta	9	3	745	2	frusta
grist	6	55	2987	2	grist_
grists	7	47	1648	2	grists
orisha	9	3	677	2	orisha
riata	5	46	1802	2	_riata
ristra	6	3	1070	2	_ristra
triste	6	38	1864	2	triste
turista	7	3	744	2	turista
vista	8	54	1660	2	_vista
wrist	8	48	2756	2	wrist_
wrists	9	54	1564	2	wrists
wristy	12	50	970	2	wristy
acrasia	9	3	1003	3	acrasia
agist	6	63	2558	3	agist_
agists	7	57	1317	3	agists
agita	6	3	1542	3	agi_ta
alist	5	61	3678	3	alist_
amrita	8	4	1113	3	amri_ta
aorist	6	48	2787	3	aorist_
aorists	7	42	1582	3	aorists
aria	4	62	4542	3	ari__a
arietta	7	8	890	3	arietta
arise	5	64	3643	3	aris_e
arisen	6	53	1679	3	arisen
arises	6	52	3380	3	arises
aristate	8	3	1212	3	aristate
aristos	7	3	1237	3	aristos
artist	6	41	2554	3	artist_
artiste	7	38	1369	3	artiste
artists	7	42	1558	3	artists
aurist	6	50	2725	3	aurist_
aurists	7	46	1578	3	aurists
baristas	10	3	972	3	baristas
biota	7	45	1682	3	_biota
bris	6	55	3961	3	bris__
brises	8	49	2761	3	brises
brisk	11	56	1598	3	bris_k
brisks	12	46	1140	3	brisks
briss	7	58	2427	3	bris_s
bristle	9	19	1010	3	bristle
bristly	12	17	806	3	bristly
bristol	9	3	704	3	bristol
brit	6	63	5015	3	bri_t_
brith	10	49	2437	3	bri_th
brits	7	64	3308	3	bri_ts
britska	13	13	288	3	britska
britt	7	57	3223	3	bri_tt
britts	8	48	1344	3	britts
cabresta	12	4	399	3	cabresta
camisa	10	31	1432	3	camis_a
camisia	11	28	1024	3	camisia
canasta	9	3	836	3	canasta
canst	7	49	3221	3	canst_
capita	10	29	1377	3	capita
capstan	11	3	790	3	capstan
carina	8	43	2532	3	cari_na
carioca	11	3	968	3	carioca
caritas	9	33	1694	3	cari_tas
casa	6	56	3086	3	c_as_a
casitas	9	33	1204	3	casitas
cassata	9	3	814	3	cassata
cassia	8	37	1476	3	cassia
cast	6	71	5990	3	c_ast_
caste	7	59	3236	3	c_aste
casts	7	72	3779	3	c_asts
ceiba	9	3	870	3	cei_ba
celesta	9	4	764	3	celesta
ceria	7	51	2535	3	ceri__a
cerise	8	48	2204	3	ceris_e
cerises	9	47	2225	3	cerises
cerite	8	47	2487	3	ceri_te
cestas	8	50	1854	3	c_estas
cesti	7	52	1742	3	c_esti
chaeta	11	3	1068	3	chaeta
charisma	15	7	635	3	charisma
chaste	11	46	1739	3	chaste
chest	10	49	2614	3	chest_
chests	11	49	1626	3	chests
chesty	14	46	1050	3	chesty
chia	9	60	2662	3	chi__a
chiasma	14	36	698	3	chiasma
chica	12	58	1826	3	chi_ca
chimla	13	3	759	3	chimla
china	10	50	2247	3	chi_na
chints	11	51	1783	3	chints
chintz	20	42	1202	3	chintz
chis	9	59	3331	3	chis__
chisel	11	21	1194	3	chisel
chit	9	69	3746	3	chi_t_
chital	11	43	1388	3	chi_tal
chits	10	54	2457	3	chi_ts
chitty	14	32	943	3	chitty
chrism	13	7	1067	3	chris_m
chrismal	15	7	517	3	chrismal
chrisms	14	9	914	3	chrisms
chrisom	14	6	662	3	chrisom
christen	13	10	670	3	christen
christie	13	4	778	3	christie
cilia	7	30	1676	3	c_ilia
circa	9	3	1140	3	c_irca
cis	5	77	4803	3	c_is__
cisco	9	51	1213	3	c_isco
cissy	10	48	1107	3	c_issy
cisted	9	52	1752	3	c_isted
cistus	8	46	1134	3	c_istus
cite	6	56	4034	3	c_i_te
city	9	51	2262	3	c_i_ty
clast	7	60	3058	3	clast_
clasts	8	48	1729	3	clasts
clift	10	64	2219	3	clift_
clifts	11	51	915	3	clifts
clipt	9	63	2427	3	clipt_
clivia	11	7	723	3	clivia
cnida	8	7	895	3	cni_da
coast	7	52	3626	3	coast_
coastal	9	4	1103	3	coastal
coasts	8	57	1913	3	coasts
coital	8	41	1705	3	coi_tal
coria	7	58	2830	3	cori__a
cost	6	80	5794	3	c_ost_
costae	8	53	1968	3	c_ostae
costal	8	54	1951	3	c_ostal
costar	8	55	1861	3	c_ostar
costs	7	72	3114	3	c_osts
cotta	7	58	1857	3	c_otta
craft	10	53	2766	3	craft_
crafts	11	53	1274	3	crafts
crafty	14	47	891	3	crafty
crania	8	24	1843	3	crania
crases	8	55	3231	3	crases
crash	10	91	2001	3	cras_h
crasis	8	50	2047	3	crasis
crass	7	63	2804	3	cras_s
crate	7	65	3740	3	cr_ate
cravat	11	3	1444	3	cravat
create	8	51	2637	3	create
crept	9	51	2589	3	crept_
cresol	8	3	1020	3	cresol
cress	7	50	2283	3	cres_s
cressy	11	43	911	3	cressy
crested	10	34	1653	3	crested
cresyl	11	3	513	3	cresyl
crib	8	63	2358	3	cri__b
cribs	9	45	1675	3	cri_bs
crick	13	51	1875	3	cri_ck
cricks	14	43	1605	3	cricks
cried	8	46	2428	3	cri_ed
crier	7	47	2446	3	cri_er
criers	8	39	1858	3	criers
cries	7	54	3840	3	cri_es
crikey	15	31	778	3	crikey
crime	9	48	2269	3	cri_me
crimes	10	55	2158	3	crimes
crimp	11	56	1580	3	cri_mp
crimps	12	46	1345	3	crimps
crimpy	15	48	939	3	crimpy
crimson	11	3	564	3	crimson
cringe	9	35	1548	3	cringe
crinite	9	5	1363	3	crinite
crinum	10	3	933	3	crinum
cripe	9	55	2114	3	cri_pe
cripes	10	51	2087	3	cripes
crispate	12	4	691	3	crispate
crisped	12	40	1010	3	crisped
crispen	11	34	820	3	crispen
crisper	11	35	1105	3	crisper
crisply	14	42	652	3	crisply
crissum	11	4	484	3	crissum
cristated	12	4	741	3	crista~~ted~~
critic	10	36	1681	3	critic
critter	9	41	1303	3	critter
crittur	9	31	513	3	crittur
croft	10	56	2268	3	croft_
crofts	11	49	1059	3	crofts
cross	7	51	2450	3	cros_s
crosse	8	52	1630	3	crosse
croute	8	46	1727	3	croute
cruet	7	48	3184	3	cruet_
cruets	8	53	1495	3	cruets
cruise	8	43	1404	3	cruis_e
cruised	10	37	1021	3	cruised
cruiser	9	34	1043	3	cruiser
cruises	9	35	1444	3	cruises
crura	7	3	1258	3	cr_ura
crus	6	58	2848	3	crus__
cruse	7	57	2610	3	crus_e
cruses	8	81	2771	3	cruses
cruset	8	44	2509	3	cruset
crusets	9	38	1104	3	crusets
crush	10	68	1599	3	crus_h
crusted	10	37	1275	3	crusted
crwth	13	3	748	3	cr_wth
cryostat	13	9	574	3	cryostat
crypt	12	37	1523	3	crypt_
cryptal	14	4	568	3	cryptal
crypto	13	36	727	3	crypto
crypts	13	39	774	3	crypts
crystals	13	4	716	3	crystals
cubist	10	42	1444	3	cubist_
cubists	11	35	902	3	cubists
cuestas	9	5	793	3	cuestas
cuish	10	3	1317	3	cuis_h
cuisse	8	31	833	3	cuisse
curia	7	45	2376	3	curi__a
curiosa	9	34	664	3	curiosa
curite	8	52	2294	3	curi_te
curst	7	49	3102	3	curst_
cyst	9	63	2281	3	c_yst_
cysts	10	59	1277	3	c_ysts
czarist	18	7	1022	3	czarist_
czarists	19	6	622	3	czarists
deist	6	46	3359	3	deist_
deists	7	49	1643	3	deists
dicta	8	49	1563	3	_dicta
distal	7	36	1576	3	_distal
dita	5	60	3252	3	_di_ta
drest	6	55	3034	3	drest_
driest	7	47	2275	3	driest_
drift	9	57	2284	3	drift_
drifts	10	49	989	3	drifts
drifty	13	41	822	3	drifty
dript	8	69	2387	3	dript_
egesta	7	42	865	3	egesta
erica	7	3	1654	3	eri_ca
eristic	9	8	1409	3	eristic
errata	6	3	901	3	errata
erst	4	74	3643	3	er_st_
exist	12	46	1894	3	exist_
exists	13	47	1091	3	exists
feist	8	62	3007	3	feist_
feists	9	49	1531	3	feists
feisty	12	44	929	3	feisty
fiesta	9	3	812	3	fiesta
first	8	62	2612	3	first_
firsts	9	51	1092	3	firsts
fist	7	62	4842	3	_fist_
fists	8	55	2754	3	_fists
foist	8	57	3097	3	foist_
foists	9	54	1398	3	foists
frise	8	53	2245	3	fris_e
frisee	9	42	1799	3	frisee
frises	9	41	2427	3	frises
frisk	12	53	1237	3	fris_k
frisks	13	47	926	3	frisks
frisky	16	40	667	3	frisky
frit	7	70	4447	3	fri_t_
frith	11	59	2203	3	fri_th
frits	8	61	2910	3	fri_ts
fritt	8	61	2941	3	fri_tt
fritts	9	46	1319	3	fritts
fritz	17	60	2077	3	fri_tz
frost	8	47	2783	3	frost_
frosts	9	42	1462	3	frosts
frosty	12	47	1063	3	frosty
geisha	10	3	519	3	geisha
gist	5	60	4676	3	_gist_
gists	6	60	2619	3	_gists
grift	9	59	2446	3	grift_
grifts	10	45	1168	3	grifts
gringa	8	3	854	3	gringa
griot	6	53	2841	3	griot_
griots	7	47	1364	3	griots
gript	8	51	2617	3	gript_
grisly	10	43	1058	3	grisly
grison	7	3	1010	3	grison
grister	8	39	1541	3	grister
gristle	8	16	922	3	gristle
gristly	11	18	733	3	gristly
grit	5	52	4724	3	gri_t_
grith	9	55	2037	3	gri_th
grits	6	55	2958	3	gri_ts
gritty	10	33	840	3	gritty
harissa	10	3	550	3	harissa
heist	8	70	3091	3	heist_
heists	9	68	1463	3	heists
hist	7	65	5154	3	_hist_
hists	8	63	2837	3	_hists
hoist	8	64	3321	3	hoist_
hoists	9	55	1602	3	hoists
hosta	8	59	1783	3	_hosta
iota	4	51	2783	3	__iota
iris	4	57	3255	3	iris__
irised	7	39	1315	3	irised
irises	6	42	2117	3	irises
isba	6	13	1088	3	__isba
joist	12	51	2565	3	joist_
joists	13	47	1103	3	joists
jurist	13	46	1639	3	jurist_
jurists	14	40	912	3	jurists
kist	8	65	4079	3	_kist_
kists	9	58	2211	3	_kists
kris	8	64	2360	3	kris__
krises	10	50	1608	3	krises
list	4	70	5534	3	_list_
lists	5	66	2869	3	_lists
lyrist	9	3	1229	3	lyrist_
lyrists	10	3	696	3	lyrists
maist	7	55	3568	3	maist_
maists	8	58	1757	3	maists
mist	6	61	5453	3	_mist_
mists	7	66	3390	3	_mists
misty	10	61	2045	3	_misty
moist	7	60	3358	3	moist_
neist	5	46	2844	3	neist_
odist	6	4	2191	3	odist_
odists	7	4	985	3	odists
orishas	10	3	647	3	orishas
orison	6	4	1166	3	orison
paisa	7	60	2107	3	pais_a
pasta	7	66	2453	3	_pasta
pieta	7	54	2175	3	_pieta
pinta	7	57	2705	3	_pinta
piste	7	58	2460	3	_piste
pita	6	54	3643	3	_pi_ta
pitta	7	50	1869	3	_pitta
poisha	11	3	572	3	poisha
presa	7	43	1904	3	pres_a
prest	7	57	3635	3	prest_
presto	8	42	1620	3	presto
prests	8	40	2126	3	prests
priest	8	41	2542	3	priest_
priests	9	38	1086	3	priests
prima	9	50	1934	3	pri_ma
print	7	48	3746	3	print_
prints	8	43	2010	3	prints
prise	7	46	3261	3	pris_e
prised	9	43	2220	3	prised
prises	8	41	3317	3	prises
prism	9	48	2026	3	pris_m
prisms	10	49	1550	3	prisms
prison	8	5	1402	3	prison
priss	7	46	2389	3	pris_s
prissy	11	34	785	3	prissy
pristane	10	3	1033	3	pristane
prost	7	54	3410	3	prost_
pruta	7	3	1424	3	pr_uta
purist	8	55	2505	3	purist_
purists	9	40	1407	3	purists
quinta	15	33	1237	3	quinta
raita	5	46	2307	3	_raita
reata	5	42	2539	3	_reata
recta	7	42	2026	3	_recta
resat	5	51	3968	3	_resat
rest	4	64	5984	3	_rest_
rests	5	49	3587	3	_rests
rhyta	11	3	508	3	_rhyta
ria	3	67	4550	3	_ri__a
riatas	6	39	1508	3	_riatas
rictal	8	31	1317	3	_rictal
rift	7	56	4233	3	_rift_
rifts	8	57	1864	3	_rifts
rioja	12	3	630	3	_rioja
riot	4	59	4721	3	_riot_
riots	5	49	2201	3	_riots
rise	4	59	4523	3	_ris_e
risen	5	46	2188	3	_risen
riser	5	54	3105	3	_riser
rises	5	52	4404	3	_rises
rishi	8	3	1125	3	_rishi
risk	8	57	2410	3	_ris_k
risks	9	49	1706	3	_risks
risky	12	63	1152	3	_risky
ristras	7	3	1154	3	_ristras
risus	5	42	1639	3	_risus
rite	4	58	4945	3	_ri_te
ritz	13	51	2998	3	_ri_tz
rostra	6	3	1093	3	_rostra
rota	4	58	3434	3	_r_ota
rust	4	55	4491	3	_rust_
rusts	5	50	2699	3	_rusts
rusty	8	52	2105	3	_rusty
sacrist	9	3	1542	3	sacrist_
sacristan	11	4	357	3	sacristan
sacrists	10	3	956	3	sacrists
sacristy	13	4	510	3	sacristy
schist	11	3	1265	3	schist_
schists	12	4	854	3	schists
script	10	57	1790	3	script_
scripts	11	50	937	3	scripts
scrota	8	3	1018	3	scr_ota
shist	8	48	2960	3	shist_
shists	9	65	1510	3	shists
siesta	6	3	950	3	siesta
sistra	6	3	933	3	_sistra
sris	4	54	3415	3	sris__
striata	7	37	995	3	striata
testa	5	48	2204	3	_testa
tourista	8	4	440	3	tourista
triptan	9	4	754	3	triptan
trishaw	13	4	475	3	trishaw
tristate	8	3	1102	3	tristate
tristeza	17	4	293	3	tristeza
trite	5	47	3003	3	tri_te
trivia	9	3	850	3	trivia
trust	5	54	2685	3	trust_
trusts	6	47	1443	3	trusts
trusty	9	47	1011	3	trusty
tryst	8	47	1622	3	tryst_
tryste	9	39	958	3	tryste
trysts	9	44	879	3	trysts
turistas	8	4	669	3	turistas
twist	8	68	2098	3	twist_
twists	9	54	975	3	twists
twisty	12	42	686	3	twisty
ursa	4	41	1690	3	ur_s_a
verist	9	38	2389	3	verist_
verists	10	36	1367	3	verists
vesta	8	66	1830	3	_vesta
visa	7	63	2387	3	_vis_a
vistas	9	45	1327	3	_vistas
vita	7	58	2852	3	_vi_ta
vitta	8	50	1517	3	_vitta
waist	8	61	3238	3	waist_
waists	9	74	1545	3	waists
whist	11	53	2295	3	whist_
whists	12	46	1381	3	whists
wisha	11	49	1085	3	_wisha
wist	7	80	4929	3	_wist_
wists	8	67	2852	3	_wists
wrest	8	49	2543	3	wrest_
wrests	9	53	1308	3	wrests
wriest	9	44	1971	3	wriest_
writ	7	55	3791	3	wri_t_
write	8	55	2283	3	wri_te
writs	8	66	2438	3	wri_ts

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	112716	0.143	1249587.4
2	DLD Change Limit	112716	460	6.953	16211.1
3	Display Results	460	460	0.296	1554.1
	(SQL Overall)	178691	460	7.392	24173.6