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

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

264 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
crinum	10	3	933	(None)
crinums	11	3	586	1	crinums
cerium	10	3	1376	2	ceri_um
conium	10	4	1531	2	conium
corium	10	3	1572	2	cori_um
cranium	11	9	1110	2	cranium
cringe	9	35	1548	2	cringe
crissum	11	4	484	2	crissum
curium	10	3	1250	2	curi_um
frenum	11	8	880	2	frenum
granum	9	3	1091	2	granum
linum	7	3	1382	2	_linum
acinus	8	3	1125	3	acinus
acronym	14	4	567	3	acronym
actinium	12	9	755	3	actinium
arcanum	11	7	644	3	arcanum
arum	6	61	2903	3	ar__um
atrium	8	4	1182	3	atri_um
barium	10	3	1351	3	bari_um
brim	8	56	2937	3	bri__m
brin	6	70	3819	3	brin__
brine	7	51	3227	3	brin_e
brined	9	51	1841	3	brined
briner	8	45	1904	3	briner
brines	8	50	2885	3	brines
bring	8	55	2850	3	brin_g
brings	9	46	1843	3	brings
brink	11	61	2200	3	brin_k
brinks	12	46	1631	3	brinks
brins	7	55	3397	3	brin_s
briny	10	47	1966	3	brin_y
caecum	12	3	818	3	caecum
cain	6	56	4391	3	cain__
cains	7	53	3430	3	cain_s
caique	17	31	880	3	caique
carina	8	43	2533	3	carin_a
carinae	9	43	1859	3	carinae
carinal	9	43	1824	3	carinal
carinas	9	36	2241	3	carinas
caring	9	51	3799	3	carin_g
carious	9	33	2028	3	carious
cecum	11	6	1184	3	c_ecum
centum	10	40	1236	3	centum
cering	9	45	2253	3	cerin_g
ceriums	11	3	947	3	ceri_ums
cesium	10	3	958	3	cesium
chiasm	13	44	910	3	chiasm
chiaus	11	36	1131	3	chiaus
chillum	14	3	544	3	chillum
chin	9	69	3474	3	chin__
china	10	50	2248	3	chin_a
chinas	11	51	1940	3	chinas
chinch	16	39	1123	3	chinch
chine	10	52	3172	3	chin_e
chined	12	56	2006	3	chined
chines	11	50	2917	3	chines
chink	14	53	2159	3	chin_k
chinks	15	58	1757	3	chinks
chinky	18	56	1054	3	chinky
chino	10	58	2331	3	chin_o
chinos	11	50	1869	3	chinos
chins	10	56	3146	3	chin_s
chints	11	51	1783	3	chints
chintz	20	42	1203	3	chintz
chirm	12	53	1706	3	chi_rm
chiru	10	53	1715	3	chiru_
chirus	11	46	1569	3	chirus
chrism	13	7	1067	3	chri_sm
chrisom	14	6	662	3	chrisom
chum	11	63	1800	3	c__hum
cilium	10	43	1137	3	cilium
cinch	12	45	1624	3	c_inch
cine	6	62	4294	3	c_in_e
cinema	10	4	765	3	c_inema
cines	7	52	3968	3	c_ines
cinque	17	3	685	3	c_inque
circus	10	43	1059	3	circus
cirque	17	3	585	3	cirque
cirrus	8	34	917	3	cirrus
clinal	8	3	1155	3	clinal
clinch	13	39	1035	3	clinch
cline	7	64	2853	3	clin_e
clines	8	49	2604	3	clines
cling	8	64	2467	3	clin_g
clings	9	57	1621	3	clings
clingy	12	65	906	3	clingy
clinic	10	43	1279	3	clinic
clink	11	53	2004	3	clin_k
clinks	12	58	1506	3	clinks
clique	17	28	919	3	clique
cliquy	20	32	471	3	cliquy
clonus	8	52	1241	3	clonus
cobnut	10	3	1132	3	cobnut
coin	6	66	4535	3	coin__
coined	9	45	2360	3	coined
coiner	8	43	2378	3	coiner
coins	7	58	3455	3	coin_s
coitus	8	5	1189	3	coitus
coniums	11	3	1186	3	coniums
conus	7	67	2653	3	c_onus
coring	9	44	3396	3	corin_g
cornu	7	59	2132	3	cornu_
cornua	8	54	1190	3	cornua
cornus	8	48	1656	3	cornus
corundum	13	4	329	3	corundum
cram	8	56	3549	3	cr__am
cranch	13	36	1353	3	cranch
crane	7	53	3160	3	cran_e
craned	9	61	2165	3	craned
cranes	8	43	3075	3	cranes
crania	8	24	1843	3	crania
craniums	12	9	791	3	craniums
crank	11	48	1961	3	cran_k
cranks	12	50	1531	3	cranks
cranky	15	39	1063	3	cranky
cranny	11	42	1027	3	cranny
cream	9	57	2135	3	cr_eam
crenel	8	42	1306	3	crenel
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
cringed	11	33	1240	3	cringed
cringer	10	35	1424	3	cringer
cringes	10	32	1550	3	cringes
cringle	10	30	1035	3	cringle
crinite	9	5	1363	3	crinite
crinkle	13	35	941	3	crinkle
crinkly	16	38	752	3	crinkly
crinoid	10	3	994	3	crinoid
cripe	9	55	2114	3	cri_pe
cripes	10	51	2087	3	cripes
cris	6	62	3343	3	cri__s
crises	8	45	2943	3	crises
crisic	10	36	1184	3	crisic
crisis	8	37	1634	3	crisis
crisp	9	50	1462	3	cri_sp
crisps	10	44	1151	3	crisps
crispy	13	47	856	3	crispy
crissa	8	3	762	3	crissa
crista	8	3	1180	3	crista
crit	6	57	4371	3	cri__t
critic	10	36	1681	3	critic
crits	7	55	2757	3	cri_ts
crittur	9	31	513	3	crittur
crocus	10	48	1317	3	crocus
crone	7	52	3133	3	cron_e
crones	8	47	2924	3	crones
crony	10	59	1867	3	cron_y
croup	9	56	1678	3	cr_oup
cru	5	71	2956	3	cr__u_
crud	7	52	1961	3	cr__ud
crumb	11	43	1359	3	cr__umb
crumbum	15	4	374	3	crumbum
crump	11	56	1642	3	cr__ump
crunch	13	34	950	3	crunch
crus	6	58	2848	3	cr__us
crux	13	54	1500	3	cr__ux
crying	12	36	1228	3	cryin_g
cuing	8	54	2019	3	cuin_g
cum	7	64	4016	3	c___um
cundum	11	3	651	3	cundum
cuprum	12	3	674	3	cuprum
curing	9	48	2478	3	curin_g
curious	9	38	1356	3	curious
curiums	11	3	850	3	curi_ums
dinkum	13	3	589	3	_dinkum
dirdum	10	3	603	3	dirdum
drink	10	68	1638	3	drin_k
drinks	11	68	1071	3	drinks
drum	7	65	2159	3	dr__um
echinus	12	3	620	3	echinus
erbium	10	3	808	3	erbium
eringo	7	3	955	3	eringo
fanum	10	3	1344	3	_fanum
filum	10	50	1543	3	_filum
fraenum	12	5	570	3	fraenum
frenums	12	3	620	3	frenums
fringe	10	40	1395	3	fringe
fringy	13	30	926	3	fringy
gonium	9	4	980	3	gonium
grim	7	69	2942	3	gri__m
grin	5	57	3372	3	grin__
grinch	12	3	848	3	grinch
grind	7	59	1756	3	grin_d
grinds	8	45	1184	3	grinds
gringa	8	3	855	3	gringa
gringo	8	3	864	3	gringo
grins	6	54	2722	3	grin_s
grum	7	56	2508	3	gr__um
hilum	10	55	1460	3	_hilum
ilium	7	46	1418	3	ili_um
ionium	8	6	1092	3	ionium
iridium	10	4	630	3	iridium
iring	6	60	2542	3	irin_g
kronur	10	41	531	3	kronur
linums	8	3	828	3	_linums
magnum	11	3	673	3	magnum
minim	9	73	2160	3	_minim
minium	10	60	1442	3	_minium
minus	7	52	2393	3	_minus
odium	8	34	1303	3	odi_um
onium	7	31	1553	3	oni_um
opium	9	28	1209	3	opi_um
organum	10	4	534	3	organum
origanum	11	4	339	3	origanum
perineum	12	4	652	3	perineum
pinup	9	6	1288	3	_pinup
plenum	10	3	950	3	plenum
prim	8	51	3220	3	pri__m
primus	10	37	1217	3	primus
prince	10	41	1476	3	prince
prink	11	47	1967	3	prin_k
prinks	12	43	1538	3	prinks
print	7	48	3746	3	prin_t
prints	8	43	2010	3	prints
prism	9	48	2026	3	pri_sm
prunus	8	39	936	3	prunus
regnum	9	5	716	3	regnum
rheum	10	3	884	3	_rheum
rim	5	60	5227	3	_ri__m
rin	3	66	6318	3	_rin__
rind	5	65	3560	3	_rin_d
rinds	6	48	2614	3	_rinds
rindy	9	57	1739	3	_rindy
ring	5	65	4115	3	_rin_g
rings	6	50	2917	3	_rings
rink	8	77	3699	3	_rin_k
rinks	9	48	2710	3	_rinks
rins	4	61	5319	3	_rin_s
rinse	5	48	2097	3	_rinse
risus	5	42	1639	3	_risus
rum	5	66	4464	3	_r__um
scrim	9	54	1974	3	scri__m
scrotum	11	4	513	3	scrotum
scrum	9	54	1820	3	scr__um
sinus	5	55	2385	3	_sinus
triduum	10	4	341	3	triduum
trim	6	53	2952	3	tri__m
trinal	6	5	1696	3	trinal
trine	5	47	3460	3	trin_e
trined	7	49	2071	3	trined
trines	6	41	3256	3	trines
trinkums	14	4	341	3	trinkums
tritium	9	6	901	3	tritium
triune	6	42	1018	3	triune
trivium	12	5	614	3	trivium
uranium	9	6	1002	3	uranium
urinal	6	6	1412	3	urinal
urine	5	50	2660	3	urin_e
urines	6	47	2412	3	urines
urinous	7	3	1008	3	urinous
wring	9	59	2071	3	wrin_g
wrings	10	40	1297	3	wrings

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	264	5.046	22337.7
3	Display Results	264	264	0.080	3300.0
	(SQL Overall)	178691	264	5.499	32495.2