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

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

409 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
grison	7	3	1010	(None)
grisons	8	3	899	1	grisons
orison	6	4	1166	1	orison
prison	8	5	1402	1	prison
arisen	6	53	1679	2	arisen
arson	5	51	1883	2	ar_son
bison	7	57	1698	2	_bison
crimson	11	3	564	2	crimson
foison	9	4	893	2	foison
frisson	10	4	531	2	frisson
garrison	9	4	398	2	garrison
gibson	9	3	512	2	gibson
gipon	8	42	1241	2	g_ipon
giron	6	61	1899	2	g_iron
godson	8	5	738	2	godson
greisen	8	5	650	2	greisen
griffon	14	4	310	2	griffon
grin	5	57	3372	2	gri__n
griot	6	53	2841	2	gri_ot
griskin	12	3	601	2	griskin
grisly	10	43	1058	2	grisly
grist	6	55	2987	2	gris_t
grists	7	47	1648	2	grists
guidon	8	3	737	2	guidon
orisons	7	3	1056	2	orisons
poison	8	3	1222	2	poison
prion	7	51	1999	2	pri_on
prisons	9	3	1322	2	prisons
risen	5	46	2188	2	_risen
trigon	7	45	1310	2	trigon
triton	6	39	1489	2	triton
unison	6	4	903	2	unison
warison	10	3	708	2	warison
agrimony	14	4	234	3	agrimony
anion	5	50	2881	3	ani_on
archon	11	3	1175	3	archon
argon	6	55	2059	3	ar_gon
ariose	6	48	1872	3	ariose
ariosi	6	43	1303	3	ariosi
arioso	6	43	1240	3	arioso
ariosos	7	40	985	3	ariosos
arise	5	64	3643	3	aris_e
arises	6	52	3380	3	arises
arising	8	36	1997	3	arising
arista	6	4	1529	3	arista
aristo	6	4	1403	3	aristo
aristos	7	3	1237	3	aristos
arsino	6	41	1351	3	arsino
arsons	6	39	1721	3	ar_sons
artisan	7	5	946	3	artisan
avion	8	42	1834	3	avi_on
aviso	8	57	1396	3	aviso_
avisos	9	54	1048	3	avisos
axion	12	113	1691	3	axi_on
basion	8	43	1585	3	basion
benison	9	3	712	3	benison
bisons	8	39	1437	3	_bisons
bolson	8	4	1068	3	bolson
boson	7	60	1973	3	_boson
bridoon	10	4	620	3	bridoon
brin	6	70	3819	3	bri__n
brio	6	54	3249	3	bri_o_
briony	11	4	904	3	bri_ony
brios	7	47	2572	3	bri_os
bris	6	55	3961	3	bris__
brisant	9	3	1268	3	brisant
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
bristol	9	3	704	3	bristol
caisson	9	3	659	3	caisson
chiton	11	26	1239	3	chiton
chrismon	15	4	464	3	chrismon
chrisom	14	6	662	3	chrisom
cion	6	133	3091	3	_ci_on
craton	8	45	1719	3	craton
crayon	11	41	1000	3	crayon
crepon	10	3	993	3	crepon
cresol	8	3	1020	3	cresol
crimsons	12	4	563	3	crimsons
cris	6	62	3343	3	cris__
crises	8	45	2943	3	crises
crisic	10	36	1184	3	crisic
crisis	8	37	1634	3	crisis
crisp	9	50	1462	3	cris_p
crispen	11	34	820	3	crispen
crisps	10	44	1151	3	crisps
crispy	13	47	856	3	crispy
crissa	8	3	762	3	crissa
crista	8	3	1180	3	crista
croon	7	55	2278	3	cr_oon
croton	8	44	1545	3	croton
daikon	11	21	724	3	daikon
daimon	9	25	971	3	daimon
damson	9	3	806	3	damson
derision	9	3	906	3	derision
disown	10	3	695	3	_disown
dobson	9	3	659	3	dobson
dragon	8	3	884	3	dragon
driven	10	52	1014	3	driven
dromon	9	3	936	3	dromon
durion	7	5	1096	3	duri_on
eikon	9	3	946	3	_eikon
elision	7	23	1110	3	elision
epigon	9	3	796	3	epigon
erasion	7	3	1196	3	erasion
erosion	7	3	1110	3	erosion
foisons	10	4	761	3	foisons
frijol	16	3	412	3	frijol
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
frissons	11	4	504	3	frissons
frivol	12	3	511	3	frivol
fusion	9	3	977	3	fusion
gabion	9	32	1103	3	gabion
gaboon	9	32	1177	3	gaboon
gaijin	14	4	597	3	gaijin
gain	5	60	4216	3	gai__n
gallon	7	37	1581	3	gallon
gammon	11	3	890	3	gammon
garcon	9	29	1248	3	garcon
garish	10	45	1692	3	garis_h
garrisons	10	4	379	3	garrisons
garron	7	31	1349	3	garron
gascon	9	33	972	3	gascon
geisha	10	3	519	3	geisha
gesso	6	4	960	3	gesso_
ghis	8	50	2016	3	ghis__
gibbon	11	3	532	3	gibbon
gibsons	10	4	504	3	gibsons
gien	5	63	3002	3	g_i_en
gigot	7	40	2307	3	g_igot
gin	4	60	5575	3	g_i__n
gipons	9	38	960	3	g_ipons
girasol	8	7	462	3	girasol
girn	5	60	2686	3	g_i_rn
giro	5	58	2863	3	g_iro_
girons	7	50	1437	3	g_irons
giros	6	57	2265	3	g_iros
girosol	8	8	530	3	girosol
girsh	9	53	1002	3	girs_h
gismo	8	4	886	3	g_ismo
gismos	9	5	718	3	g_ismos
gist	5	60	4676	3	g_is_t
gists	6	60	2619	3	g_ists
given	9	59	1528	3	g_iven
glisten	8	41	808	3	glisten
gluon	6	3	1122	3	g_luon
gnomon	9	3	618	3	gnomon
godsons	9	6	666	3	godsons
gonion	7	36	1283	3	gonion
goon	5	72	3617	3	g__oon
gorgon	8	3	1024	3	gorgon
gossan	7	4	723	3	gossan
gossoon	8	6	566	3	gossoon
graben	9	41	972	3	graben
gradin	8	35	1748	3	gradin
grain	6	51	2625	3	gr_ain
gran	5	63	3501	3	gr__an
grandson	10	5	541	3	grandson
grasp	8	48	1448	3	gras_p
grasps	9	48	925	3	grasps
grass	6	61	2520	3	gras_s
grassy	10	61	909	3	grassy
gratin	7	45	2058	3	gratin
graven	10	45	1352	3	graven
graviton	12	4	430	3	graviton
green	6	55	2214	3	gr_een
grego	7	3	1052	3	grego_
gregos	8	4	753	3	gregos
greisens	9	5	465	3	greisens
grid	6	58	2961	3	gri__d
gride	7	52	2358	3	gri_de
grided	9	51	1704	3	grided
grides	8	44	2236	3	grides
griding	10	30	1497	3	griding
gridiron	10	7	251	3	gridiron
grids	7	53	2139	3	gri_ds
grief	9	53	1978	3	gri_ef
griefs	10	41	872	3	griefs
grieve	10	4	724	3	grieve
griff	12	44	1646	3	gri_ff
griffe	13	43	809	3	griffe
griffin	14	3	451	3	griffin
griffons	15	4	257	3	griffons
griffs	13	39	899	3	griffs
grift	9	59	2446	3	gri_ft
grifts	10	45	1168	3	grifts
grig	6	54	2477	3	gri__g
grigri	8	3	385	3	grigri
grigs	7	53	1819	3	gri_gs
grill	6	46	1789	3	gri_ll
grille	7	43	1574	3	grille
grills	7	43	1480	3	grills
grilse	7	39	950	3	grilse
grilses	8	31	915	3	grilses
grim	7	69	2942	3	gri__m
grime	8	50	2132	3	gri_me
grimed	10	47	1409	3	grimed
grimes	9	46	1903	3	grimes
griming	11	36	1249	3	griming
grimly	12	45	993	3	grimly
grimy	11	43	1260	3	gri_my
grinch	12	3	847	3	grinch
grind	7	59	1756	3	gri_nd
grinds	8	45	1184	3	grinds
gringa	8	3	854	3	gringa
gringo	8	3	864	3	gringo
gringos	9	3	667	3	gringos
grins	6	54	2722	3	gri_ns
griots	7	47	1364	3	griots
grip	7	61	2702	3	gri__p
gripe	8	46	2296	3	gri_pe
griped	10	41	1471	3	griped
griper	9	41	1461	3	griper
gripes	9	46	1987	3	gripes
gripey	12	41	1120	3	gripey
griping	11	30	1206	3	griping
gripman	12	3	446	3	gripman
gripmen	12	3	503	3	gripmen
grippe	11	53	1032	3	grippe
grippy	14	44	776	3	grippy
grips	8	55	2013	3	gri_ps
gript	8	51	2617	3	gri_pt
gripy	11	51	1525	3	gri_py
griseous	9	4	561	3	griseous
griskins	13	3	595	3	griskins
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
griths	10	52	1165	3	griths
grits	6	55	2958	3	gri_ts
gritty	10	33	840	3	gritty
grivet	10	35	1782	3	grivet
groan	6	56	1842	3	gr_oan
grog	6	59	2334	3	gr__og
groin	6	55	2108	3	gr_oin
grok	9	58	1968	3	gr__ok
groom	8	53	1798	3	gr_oom
gross	6	54	2169	3	gros_s
grosz	15	48	1409	3	gros_z
grosze	16	45	773	3	grosze
groszy	19	39	570	3	groszy
grot	5	59	4205	3	gr__ot
grow	8	61	2730	3	gr__ow
grown	9	53	1735	3	gr_own
grunion	8	3	543	3	grunion
gryphon	16	4	387	3	gryphon
guenon	7	3	640	3	guenon
gueridon	10	4	303	3	gueridon
guidons	9	3	662	3	guidons
guiro	6	37	1209	3	guiro_
guiros	7	38	909	3	guiros
guise	6	47	1771	3	guis_e
guised	8	46	1216	3	guised
guises	7	42	1631	3	guises
guising	9	35	1141	3	guising
gyron	9	53	1462	3	g_yron
hisn	7	96	2093	3	_his_n
horizon	19	5	576	3	horizon
hyson	11	3	869	3	_hyson
icon	6	69	2204	3	__icon
ikon	8	58	1495	3	__ikon
imprison	12	4	479	3	imprison
inion	5	46	2018	3	ini_on
ion	3	60	5102	3	__i_on
iris	4	57	3255	3	iris__
irised	7	39	1315	3	irised
irises	6	42	2117	3	irises
irising	8	36	1442	3	irising
iron	4	67	2846	3	__iron
kelson	10	3	815	3	kelson
kris	8	64	2360	3	kris__
krises	10	50	1608	3	krises
kroon	9	45	1448	3	kr_oon
lesion	6	47	1506	3	lesion
lesson	6	44	1204	3	lesson
liaison	7	4	447	3	liaison
lion	4	63	3444	3	_li_on
lyricon	12	4	371	3	lyricon
malison	9	3	969	3	malison
mason	7	48	2018	3	_mason
meson	7	41	1831	3	_meson
miso	6	72	2990	3	_miso_
misos	7	65	2329	3	_misos
morion	8	62	1773	3	mori_on
nasion	6	39	1408	3	nasion
nelson	6	3	842	3	nelson
ninon	5	55	1738	3	_ninon
niton	5	54	1828	3	_niton
ogrish	10	3	926	3	ogris_h
ogrism	9	3	791	3	ogris_m
ogrisms	10	3	644	3	ogrisms
onion	5	43	2097	3	oni_on
origan	7	3	1069	3	origan
origin	7	3	1103	3	origin
orisha	9	3	677	3	orisha
orlon	5	4	1500	3	or_lon
paisan	8	44	1707	3	paisan
parson	8	38	1790	3	parson
perigon	10	3	985	3	perigon
person	8	35	1787	3	person
pinon	7	60	2453	3	_pinon
pion	6	72	3529	3	_pi_on
piso	6	67	2756	3	_piso_
pisos	7	60	2106	3	_pisos
piston	8	35	1592	3	_piston
piton	7	61	2158	3	_piton
poisons	9	3	1035	3	poisons
presong	10	3	984	3	presong
primo	9	50	1791	3	primo_
primos	10	45	1442	3	primos
prions	8	43	1778	3	pri_ons
prior	7	43	1617	3	pri_or
prise	7	46	3261	3	pris_e
prised	9	43	2220	3	prised
prises	8	41	3317	3	prises
prising	10	33	2145	3	prising
prism	9	48	2026	3	pris_m
prisms	10	49	1550	3	prisms
prisoned	11	3	881	3	prisoned
prisoner	10	4	857	3	prisoner
priss	7	46	2389	3	pris_s
prissy	11	34	785	3	prissy
proso	7	72	2241	3	proso_
prosos	8	57	1855	3	prosos
proton	8	43	1889	3	proton
ptisan	8	41	797	3	ptisan
racon	7	54	2214	3	_racon
radon	6	46	2050	3	_radon
raisin	6	27	1692	3	raisin
ramson	8	3	1046	3	ramson
rayon	8	38	1570	3	_rayon
reason	6	26	1633	3	reason
recon	7	56	2424	3	_recon
redon	6	54	2488	3	_redon
rerisen	7	36	1364	3	rerisen
resin	5	41	3105	3	_resin
resod	6	47	2005	3	_resod
resow	8	82	1724	3	_resow
resown	9	41	1292	3	_resown
rewon	8	69	2057	3	_rewon
ribbon	10	3	653	3	_ribbon
ricin	7	46	2021	3	_ricin
rigor	6	27	1405	3	_rigor
rin	3	66	6318	3	_ri__n
riot	4	59	4721	3	_ri_ot
ripen	7	56	1926	3	_ripen
rise	4	59	4523	3	_ris_e
riser	5	54	3105	3	_riser
rises	5	52	4404	3	_rises
rishi	8	3	1125	3	_rishi
rising	7	40	2588	3	_rising
risk	8	57	2410	3	_ris_k
risks	9	49	1706	3	_risks
risky	12	63	1152	3	_risky
risus	5	42	1639	3	_risus
riven	8	51	2162	3	_riven
rosin	5	53	2531	3	_rosin
scion	7	22	1499	3	sci_on
season	6	27	1490	3	season
seisin	6	37	1512	3	seisin
seisor	6	37	1233	3	seisor
son	3	77	6195	3	___son
sris	4	54	3415	3	sris__
telson	6	3	1029	3	telson
tigon	6	39	1444	3	_tigon
torsion	7	3	1080	3	torsion
treason	7	4	876	3	treason
tricorn	9	3	796	3	tricorn
tricot	8	3	1775	3	tricot
trigo	6	57	1605	3	trigo_
trigons	8	43	1209	3	trigons
trigos	7	42	1417	3	trigos
trio	4	52	3334	3	tri_o_
triol	5	55	2136	3	tri_ol
trios	5	55	2809	3	tri_os
triose	6	47	1538	3	triose
tripod	9	39	985	3	tripod
tripos	8	40	1492	3	tripos
trisome	9	3	1022	3	trisome
trisomy	12	3	594	3	trisomy
triste	6	38	1864	3	triste
tritone	7	36	1388	3	tritone
tritons	7	38	1488	3	tritons
trogon	7	36	1175	3	trogon
turion	6	3	1316	3	turi_on
union	5	45	1979	3	uni_on
unisons	7	4	842	3	unisons
unrisen	7	22	928	3	unrisen
uprisen	9	22	735	3	uprisen
venison	10	3	644	3	venison
version	10	3	1092	3	version
virion	9	3	1068	3	virion
vision	9	3	1131	3	_vision
visor	8	25	1283	3	_visor
warisons	11	3	690	3	warisons
weason	9	32	1082	3	weason
wrist	8	48	2756	3	wris_t
wrists	9	54	1564	3	wrists
wristy	12	50	970	3	wristy
zircon	17	5	495	3	zircon

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	409	7.670	14695.7
3	Display Results	409	409	0.143	2860.1
	(SQL Overall)	178691	409	7.956	22459.9