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

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

324 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
ristra	6	3	1071	(None)
ristras	7	3	1156	1	ristras
rostra	6	3	1093	1	rostra
sistra	6	3	933	1	sistra
arista	6	4	1529	2	arist_a
bistre	8	38	1502	2	bistre
bistro	8	33	994	2	bistro
crista	8	3	1180	2	crist_a
lustra	6	35	889	2	lustra
mistral	9	10	1364	2	mistral
riata	5	46	1802	2	riat_a
riser	5	54	3105	2	riser_
risers	6	46	2478	2	risers
rostral	7	3	1133	2	rostral
vista	8	54	1660	2	vist_a
antra	5	65	2192	3	_antra
arietta	7	8	890	3	arietta
aristae	7	3	1253	3	aristae
aristas	7	4	1352	3	aristas
aristo	6	4	1403	3	arist_o
aristos	7	3	1237	3	aristos
artistry	11	4	445	3	artistry
astral	6	69	1928	3	_astral
astray	9	56	1554	3	_astray
austral	7	34	1151	3	austral
barista	9	3	1081	3	barist_a
biota	7	45	1682	3	biot_a
bister	8	49	2276	3	bister
bisters	9	39	2261	3	bisters
bistort	9	12	1652	3	bistort
bistred	10	33	1185	3	bistred
bistres	9	40	1721	3	bistres
bistros	9	28	1098	3	bistros
bristle	9	19	1010	3	bristle
bristly	12	17	806	3	bristly
bristol	9	3	704	3	bristol
britska	13	13	288	3	britska
centra	8	41	1388	3	centra
cesta	7	54	1948	3	cest_a
cesura	8	3	876	3	cesura
cist	6	72	4496	3	cist__
cisted	9	52	1752	3	cisted
cistern	9	33	1070	3	cistern
cisterna	10	37	636	3	cisterna
cistron	9	29	988	3	cistron
cists	7	66	2453	3	cist_s
cistus	8	46	1134	3	cistus
citral	8	11	1389	3	ci_tral
contra	8	33	1470	3	contra
costa	7	55	2373	3	cost_a
costar	8	55	1861	3	costar
crissa	8	3	762	3	cris_sa
cristae	9	3	1061	3	cristae
diastral	9	4	699	3	diastral
dicta	8	49	1563	3	dict_a
diptera	10	3	721	3	diptera
disarm	9	3	1047	3	disarm
disbar	9	3	851	3	disbar
dishrag	12	4	627	3	dishrag
distal	7	36	1577	3	distal
distil	7	36	1643	3	distil
distort	8	11	2033	3	distort
distract	11	3	1302	3	distract
distrain	9	4	1224	3	distrain
distrait	9	4	1434	3	distrait
disturb	10	4	623	3	disturb
dita	5	60	3252	3	di_t_a
drosera	8	3	620	3	drosera
dustrag	9	4	536	3	dustrag
elytra	9	3	489	3	elytra
eristic	9	8	1409	3	eristic
estral	6	47	1651	3	_estral
estray	9	57	1333	3	_estray
extra	12	3	900	3	_extra
fiesta	9	3	812	3	fiest_a
fist	7	62	4842	3	fist__
fisted	10	42	1870	3	fisted
fistic	11	8	1257	3	fistic
fists	8	55	2754	3	fist_s
fistula	10	4	550	3	fistula
frusta	9	3	745	3	frust_a
gastral	8	32	955	3	gastral
gastrea	8	4	723	3	gastrea
gist	5	60	4676	3	gist__
gists	6	60	2619	3	gist_s
grist	6	55	2987	3	grist__
grister	8	39	1541	3	grister
gristers	9	40	1340	3	gristers
gristle	8	16	922	3	gristle
gristly	11	18	733	3	gristly
grists	7	47	1648	3	grist_s
hijra	15	3	564	3	hi_jra
hist	7	65	5154	3	hist__
histed	10	44	2024	3	histed
history	13	3	942	3	history
hists	8	63	2837	3	hist_s
hosta	8	59	1783	3	host_a
infra	8	3	864	3	_infra
instar	6	3	1001	3	instar
intro	5	49	1585	3	_intro
iota	4	51	2783	3	_iot_a
isba	6	13	1088	3	_is_ba
istle	5	22	1471	3	_istle
ixora	12	3	691	3	_ixora
kinara	10	3	1037	3	kinara
kishka	12	3	296	3	kishka
kist	8	65	4080	3	kist__
kists	9	58	2211	3	kist_s
libra	7	47	1242	3	li_bra
lira	4	69	2868	3	li__ra
list	4	70	5534	3	list__
listed	7	43	2283	3	listed
listee	6	42	2306	3	listee
listel	6	42	1474	3	listel
listen	6	48	1681	3	listen
lister	6	45	2725	3	lister
listeria	8	3	943	3	listeria
listers	7	40	2653	3	listers
lists	5	66	2869	3	list_s
litre	5	54	2146	3	li_tre
lustral	7	33	965	3	lustral
lustre	6	40	1168	3	lustre
mantra	8	41	1609	3	mantra
micra	9	62	1497	3	mi_cra
mikra	11	46	1031	3	mi_kra
misdraw	13	4	562	3	misdraw
miser	7	54	3040	3	miser_
misers	8	50	2570	3	misers
misery	11	41	1354	3	misery
mist	6	61	5453	3	mist__
misted	9	36	2582	3	misted
mister	8	47	2856	3	mister
misterm	11	43	1451	3	misterm
misters	9	39	2751	3	misters
mistrace	12	3	1264	3	mistrace
mistrain	10	3	1194	3	mistrain
mistrals	10	12	1262	3	mistrals
mistreat	10	3	1311	3	mistreat
mistrial	10	3	1138	3	mistrial
mists	7	66	3390	3	mist_s
misty	10	61	2045	3	mist_y
mitral	8	13	1432	3	mi_tral
mitre	7	55	2242	3	mi_tre
nitre	5	75	1968	3	ni_tre
nitro	5	49	1435	3	ni_tro
olestra	7	4	617	3	olestra
orisha	9	3	677	3	oris_ha
osetra	6	6	742	3	osetra
ossetra	7	4	407	3	ossetra
ostia	5	23	1558	3	_ostia
pasta	7	66	2453	3	past_a
pastry	11	49	1303	3	pastry
philtra	12	10	368	3	philtra
piastre	9	30	789	3	piastre
picara	10	3	1190	3	picara
pieta	7	54	2175	3	piet_a
pinta	7	57	2705	3	pint_a
piste	7	58	2460	3	pist_e
pistes	8	53	2563	3	pistes
pistil	8	39	1507	3	pistil
pistol	8	33	1333	3	pistol
piston	8	35	1592	3	piston
pistou	8	32	1184	3	pistou
pita	6	54	3643	3	pi_t_a
pitta	7	50	1869	3	pi_tta
prisere	9	3	1094	3	prisere
qintar	15	35	914	3	qintar
raiser	6	66	2010	3	raiser_
raisers	7	36	1739	3	raisers
raita	5	46	2307	3	rait_a
rasbora	9	4	594	3	rasbora
raser	5	56	3341	3	raser_
rasers	6	45	2678	3	rasers
raster	6	47	3144	3	raster
rasters	7	46	2902	3	rasters
rasure	6	3	1142	3	rasure
rattrap	9	4	526	3	rattrap
reata	5	42	2539	3	reat_a
recta	7	42	2026	3	rect_a
registrar	10	4	278	3	registrar
registry	12	4	463	3	registry
remora	8	4	1459	3	remora
reseda	7	3	970	3	reseda
resorb	8	49	1435	3	resorb
resort	6	57	2862	3	resort
respray	12	3	650	3	respray
rest	4	64	5984	3	rest__
restart	7	3	2003	3	restart
rested	7	44	3078	3	rested
rester	6	38	3243	3	rester
resters	7	41	3040	3	resters
restoral	8	8	1098	3	restoral
restore	7	58	2298	3	restore
restrain	8	3	1170	3	restrain
rests	5	49	3587	3	rest_s
retia	5	53	2611	3	r_etia
retral	6	44	1974	3	r_etral
retro	5	50	2095	3	r_etro
retry	8	47	1808	3	r_etry
rhyta	11	3	508	3	rhyt_a
ria	3	67	4550	3	ri___a
riatas	6	39	1509	3	riatas
ricer	7	47	2661	3	ricer_
ricers	8	41	2099	3	ricers
ricotta	9	5	543	3	ricotta
ricrac	10	3	701	3	ri_crac
rictal	8	31	1318	3	rictal
rictus	8	37	919	3	rictus
rider	6	52	3130	3	rider_
riders	7	41	2390	3	riders
rifer	8	47	2198	3	rifer_
rift	7	56	4233	3	rift__
rifted	10	41	1531	3	rifted
rifts	8	57	1864	3	rift_s
rigor	6	27	1405	3	rigor_
rigors	7	28	1371	3	rigors
rimer	7	54	2924	3	rimer_
rimers	8	45	2255	3	rimers
rinser	6	43	1721	3	rinser_
rinsers	7	38	1574	3	rinsers
rioja	12	3	630	3	ri_oja
riot	4	59	4721	3	riot__
rioted	7	34	1637	3	rioted
rioter	6	48	1728	3	rioter
rioters	7	36	1551	3	rioters
riots	5	49	2201	3	riot_s
riper	7	43	2840	3	riper_
riprap	10	5	551	3	ri_prap
ripstop	11	7	476	3	ripstop
rise	4	59	4523	3	ris__e
risen	5	46	2188	3	ris_en
rises	5	52	4404	3	ris_es
rishi	8	3	1125	3	ris_hi
rishis	9	3	1245	3	rishis
rising	7	40	2588	3	rising
risk	8	57	2410	3	ris__k
risked	11	55	1463	3	risked
risker	10	54	1449	3	risker
riskers	11	40	1199	3	riskers
risks	9	49	1706	3	ris_ks
risky	12	63	1152	3	ris_ky
risotto	7	4	432	3	risotto
risque	15	22	745	3	risque
risus	5	42	1639	3	ris_us
ritard	7	48	1208	3	ritard
rite	4	58	4945	3	ri_t_e
rites	5	44	4255	3	ri_tes
ritter	6	38	2242	3	ritter
ritters	7	40	2062	3	ritters
ritual	6	3	1062	3	ri_tual
ritz	13	51	2998	3	ri_t_z
ritzy	17	56	1116	3	ri_tzy
river	8	57	3169	3	river_
rivers	9	46	2654	3	rivers
riviera	10	3	507	3	riviera
roister	7	35	1620	3	roister
roisters	8	36	1555	3	roisters
rosaria	7	4	925	3	rosaria
rosary	9	28	1035	3	rosary
rosery	9	38	1328	3	rosery
roster	6	43	2908	3	roster
rosters	7	37	2754	3	rosters
rostrate	8	3	1384	3	rostrate
rostrum	9	4	721	3	rostrum
rota	4	58	3434	3	r_ot_a
rust	4	55	4491	3	rust__
rusted	7	50	2092	3	rusted
rustic	8	7	1267	3	rustic
rustle	6	36	1541	3	rustle
rusts	5	50	2699	3	rust_s
rusty	8	52	2105	3	rust_y
sera	4	61	4139	3	__sera
sierra	6	3	731	3	sierra
siesta	6	3	950	3	siest_a
sirra	5	44	1632	3	si_rra
sister	6	44	2158	3	sister
sisters	7	37	2159	3	sisters
sistrum	9	4	656	3	sistrum
sitar	5	48	2054	3	si_tar
sora	4	57	4691	3	__sora
star	4	80	3776	3	__star
stoa	4	54	2591	3	__stoa
strap	7	79	2526	3	__strap
straw	8	133	2129	3	__straw
stray	8	85	2557	3	__stray
stria	5	57	2321	3	__stria
sura	4	57	4029	3	__sura
sutra	5	42	1793	3	_sutra
tantra	6	37	1335	3	tantra
testa	5	48	2204	3	test_a
tetra	5	34	1795	3	_tetra
tiara	5	3	1591	3	ti_ara
titre	5	46	1939	3	ti_tre
trictrac	12	4	441	3	trictrac
triste	6	38	1864	3	trist_e
tristeza	17	4	293	3	tristeza
turista	7	3	744	3	turist_a
ultra	5	3	936	3	_ultra
unstrap	9	4	678	3	unstrap
vesta	8	66	1830	3	vest_a
vestral	10	41	1101	3	vestral
vestry	12	3	862	3	vestry
visa	7	63	2387	3	vis__a
visard	10	39	1012	3	visard
viscera	12	3	508	3	viscera
visor	8	25	1283	3	visor_
visors	9	29	1222	3	visors
vistas	9	45	1327	3	vistas
vita	7	58	2852	3	vi_t_a
vitta	8	50	1517	3	vi_tta
wastry	12	38	877	3	wastry
wintry	12	49	892	3	wintry
wirra	8	32	1082	3	wi_rra
wiser	8	55	2280	3	wiser_
wisha	11	49	1085	3	wis_ha
wist	7	80	4929	3	wist__
wistaria	11	4	662	3	wistaria
wisted	10	41	2027	3	wisted
wisteria	11	4	775	3	wisteria
wists	8	67	2852	3	wist_s
wrist	8	48	2756	3	wrist__
wrists	9	54	1564	3	wrist_s
wristy	12	50	970	3	wrist_y
yantra	9	44	962	3	yantra

Search took 6 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.373	479064.3
2	DLD Change Limit	112716	324	4.970	22679.3
3	Display Results	324	324	0.110	2945.5
	(SQL Overall)	178691	324	5.453	32769.3