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

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

349 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
romano	8	49	1294	(None)
roman	7	54	2482	1	roman_
romanos	9	43	1148	1	romanos
romans	8	46	2024	1	romans
domino	9	26	1149	2	domino
mano	6	65	3681	2	__mano
pompano	13	4	520	2	pompano
reman	7	57	3015	2	reman_
remand	9	56	1896	2	remand
remans	8	48	2300	2	remans
roan	4	72	3420	2	ro_an_
roans	5	49	2644	2	ro_ans
robalo	8	3	893	2	robalo
roband	9	23	1072	2	roband
rodman	9	4	971	2	rodman_
romaine	9	5	1212	2	romaine
romaji	15	3	489	2	romaji
romance	11	3	1108	2	romance
romaunt	9	4	780	2	romaunt
romeo	7	37	1970	2	rom_eo
rowan	8	54	1873	2	rowan_
rowans	9	57	1534	2	rowans
solano	6	53	1418	2	solano
soman	7	50	2490	2	soman_
somans	8	46	1930	2	somans
toman	7	57	2405	2	toman_
tomans	8	54	1913	2	tomans
tomato	8	3	1345	2	tomato
woman	10	58	1800	2	woman_
womans	11	46	1365	2	womans
adman	8	45	1791	3	adman_
amino	7	54	2550	3	_amino
ammino	10	6	988	3	ammino
ammono	10	4	737	3	ammono
aroma	7	12	2015	3	aroma__
aromas	8	10	1862	3	aroma_s
atman	7	55	2015	3	atman_
atmans	8	44	1396	3	atmans
axman	14	48	1319	3	axman_
beano	7	54	2155	3	_beano
bogan	8	75	1900	3	bogan_
bogans	9	57	1481	3	bogans
borane	8	46	2021	3	borane
botany	11	3	926	3	botany
bowman	13	12	985	3	bowman_
brogan	9	3	1104	3	brogan_
brogans	10	4	966	3	brogans
bromal	10	3	1365	3	broma_l
bromals	11	3	974	3	bromals
bromate	11	3	1355	3	bromate
bromin	10	26	1569	3	bromin_
bromine	11	29	1524	3	bromine
bromins	11	25	1378	3	bromins
bromo	9	52	1720	3	brom__o
coma	8	71	3485	3	coma__
comade	11	44	1532	3	comade
comae	9	71	2842	3	coma_e
comake	14	44	1342	3	comake
comal	9	51	2513	3	coma_l
comas	9	58	3300	3	coma_s
comate	10	41	2484	3	comate
combo	11	45	1943	3	com_bo
comedo	11	35	960	3	comedo
coming	11	42	2545	3	coming
command	14	39	921	3	command
commando	15	27	575	3	commando
common	12	3	1080	3	common
company	16	197	1114	3	company
compo	11	53	1857	3	com_po
coranto	9	3	1189	3	coranto
cotan	7	15	2178	3	cotan_
cotans	8	13	1792	3	cotans
cowman	13	9	1037	3	cowman_
cyano	10	55	1249	3	_cyano
daman	8	48	2117	3	daman_
damans	9	47	1598	3	damans
demand	10	43	1425	3	demand
dolman	9	53	1240	3	dolman_
dolmans	10	47	968	3	dolmans
domain	9	5	1132	3	domain
domaine	10	6	1050	3	domaine
domains	10	5	1087	3	domains
domal	8	56	1920	3	doma_l
domine	9	29	1825	3	domine
doming	10	42	1839	3	doming
dominos	10	32	1019	3	dominos
dopant	9	3	1613	3	dopant
dorado	8	3	881	3	dorado
dormant	10	28	1437	3	dormant
dromon	9	3	936	3	dromon_
dromond	11	3	547	3	dromond
dromons	10	3	819	3	dromons
fano	7	58	3169	3	__fano
foeman	11	3	1123	3	foeman_
foment	11	37	1830	3	foment
formant	12	34	1600	3	formant
frogman	13	3	587	3	frogman_
fromage	13	3	675	3	fromage
gitano	7	3	804	3	gitano
goban	8	44	1407	3	goban_
gobang	10	37	670	3	gobang
gobans	9	44	1204	3	gobans
gombo	10	58	1404	3	gom_bo
gormand	11	5	745	3	gormand
gowan	9	54	1574	3	gowan_
gowans	10	55	1229	3	gowans
gowany	13	45	749	3	gowany
groan	6	56	1842	3	gro_an_
groans	7	48	1506	3	gro_ans
guano	6	92	1398	3	_guano
hogan	9	78	1770	3	hogan_
hogans	10	59	1431	3	hogans
hogmane	13	3	634	3	hogmane
homage	12	12	1060	3	homage
homing	12	37	1838	3	homing
hominy	14	45	1148	3	hominy
homo	9	61	2647	3	hom__o
honan	8	53	1977	3	honan_
honans	9	48	1450	3	honans
human	10	27	1603	3	human_
humane	11	28	1217	3	humane
humans	11	23	1243	3	humans
imago	8	11	869	3	_imago
imino	7	43	1523	3	_imino
immane	10	3	888	3	immane
ironman	9	3	661	3	ironman_
jomon	14	6	1008	3	jomon_
journo	13	13	529	3	journo
kimono	12	10	541	3	kimono
koan	8	54	2504	3	ko_an_
koans	9	58	1862	3	ko_ans
leman	7	56	2260	3	leman_
lemans	8	53	1639	3	lemans
liman	7	59	2160	3	liman_
limans	8	48	1630	3	limans
llano	5	9	1060	3	_llano
loan	4	74	3645	3	lo_an_
loans	5	60	2646	3	lo_ans
logan	6	81	2328	3	logan_
logans	7	63	1906	3	logans
loment	8	40	2147	3	loment
loran	5	59	2509	3	loran_
lorans	6	51	1760	3	lorans
mako	10	56	2236	3	__mako
man	5	74	6587	3	__man_
mana	6	53	4196	3	__mana
mane	6	50	5203	3	__mane
mango	8	57	2433	3	__mango
manor	7	80	2393	3	__manor
manos	7	49	3362	3	__manos
mans	6	63	5455	3	__mans
many	9	57	3186	3	__many
mayo	9	65	2430	3	__mayo
meno	6	60	3136	3	__meno
moan	6	58	3202	3	mo_an_
moans	7	46	2437	3	mo_ans
moment	10	33	1968	3	moment
momento	11	34	890	3	momento
mono	6	60	3672	3	__mono
noma	6	75	2946	3	noma__
nomad	8	60	1618	3	noma_d
nomads	9	47	1160	3	nomads
nomas	7	47	2641	3	noma_s
nomen	7	56	2162	3	nomen_
nomina	8	31	1368	3	nomina
nonman	8	4	1236	3	nonman_
omasa	7	4	948	3	_omasa
omen	6	68	2818	3	_omen_
omens	7	56	1896	3	_omens
ono	3	68	3803	3	_o__no
orang	6	51	1994	3	_orang
oregano	8	4	625	3	oregano
organ	6	9	1539	3	organ_
organa	7	8	921	3	organa
organon	8	4	591	3	organon
organs	7	9	1291	3	organs
piano	7	61	1871	3	_piano
poblano	11	4	509	3	poblano
pomace	12	31	1191	3	pomace
pomade	11	36	1133	3	pomade
pomelo	10	23	866	3	pomelo
pomo	8	58	2845	3	pom__o
pompanos	14	4	524	3	pompanos
pompon	12	3	894	3	pompon
porno	7	51	2065	3	po_rno
potato	8	5	1343	3	potato
potman	10	28	1357	3	potman_
preman	10	41	1745	3	preman_
proband	12	27	1024	3	proband
probang	12	27	838	3	probang
profane	12	21	1186	3	profane
prolan	8	4	1469	3	prolan_
prolans	9	3	1427	3	prolans
promine	11	28	1944	3	promine
promo	9	56	2000	3	prom__o
propane	11	27	1615	3	propane
propman	13	3	906	3	propman_
rabato	8	34	1326	3	rabato
ragman	9	40	1372	3	ragman_
ramada	9	3	1018	3	ramada
ramal	7	46	2225	3	rama_l
ramate	8	39	2169	3	ramate
ramen	7	56	2519	3	ramen_
ramona	8	4	1241	3	ramona
rampant	11	3	1217	3	rampant
ramson	8	3	1046	3	ramson
ran	3	82	6662	3	r__an_
rand	5	58	3957	3	r__and
rang	5	69	3917	3	r__ang
rani	4	66	4011	3	r__ani
rank	8	51	3553	3	r__ank
rant	4	58	6468	3	r__ant
ratan	5	37	2266	3	ratan_
ratans	6	38	1937	3	ratans
ratany	9	34	1187	3	ratany
rato	4	54	3697	3	r__ato
rebato	8	37	1469	3	rebato
recane	8	30	2287	3	recane
recant	8	32	2868	3	recant
redan	6	61	2501	3	redan_
redans	7	54	2102	3	redans
rehang	10	3	982	3	rehang
reland	7	59	2043	3	reland
remade	9	43	1698	3	remade
remail	8	50	1712	3	remail
remain	8	59	1986	3	remain
remains	9	41	1791	3	remains
remake	12	40	1611	3	remake
remands	10	49	1488	3	remands
remap	9	54	1810	3	rema_p
remaps	10	50	1287	3	remaps
remark	12	35	1237	3	remark
remate	8	44	2868	3	remate
remend	9	52	1655	3	remend
remind	9	48	1979	3	remind
remint	8	53	2998	3	remint
remnant	9	3	1264	3	remnant
repand	9	53	1606	3	repand
reran	5	73	2910	3	reran_
rewan	8	56	2366	3	rewan_
rhino	8	46	1432	3	r_hino
riant	5	58	3315	3	r_iant
riband	9	23	962	3	riband
riming	9	33	2222	3	riming
rimland	10	3	566	3	rimland
roach	10	57	1700	3	ro_ach
road	5	63	3211	3	ro_a_d
roadeo	7	5	1032	3	roadeo
roads	6	65	2362	3	ro_ads
roam	6	71	3241	3	ro_a_m
roamed	9	52	1509	3	roamed
roamer	8	47	1516	3	roamer
roaming	10	32	1579	3	roaming
roams	7	49	1961	3	ro_ams
roar	4	63	2857	3	ro_a_r
roars	5	56	2224	3	ro_ars
roast	5	62	3014	3	ro_ast
robalos	9	3	768	3	robalos
robands	10	21	986	3	robands
robin	7	48	2028	3	robin_
robing	9	36	1800	3	robing
robins	8	36	1745	3	robins
rococo	10	3	681	3	rococo
rodent	7	5	1924	3	rodent
rodeo	6	59	2109	3	ro_deo
rodmen	9	3	971	3	rodmen_
rodsman	10	3	665	3	rodsman_
rom	5	98	5563	3	rom___
romaines	10	5	1252	3	romaines
romajis	16	3	591	3	romajis
romanced	13	3	725	3	romanced
romancer	12	4	729	3	romancer
romances	12	3	1079	3	romances
romanise	10	3	1213	3	romanise
romanize	19	3	1101	3	romanize
romantic	12	4	924	3	romantic
romaunts	10	4	369	3	romaunts
romeos	8	40	1317	3	romeos
romp	8	59	2657	3	rom__p
romped	11	45	1365	3	romped
romper	10	42	1368	3	romper
romping	12	31	1303	3	romping
romps	9	46	1754	3	rom_ps
roms	6	70	3896	3	rom__s
rondo	6	52	1837	3	ro_ndo
ronion	6	33	1564	3	ronion
ronyon	9	30	913	3	ronyon
rooming	10	41	1704	3	rooming
roping	9	40	2302	3	roping
rosary	9	28	1035	3	rosary
rosin	5	53	2531	3	rosin_
rosing	7	39	2559	3	rosing
rosinol	7	5	632	3	rosinol
rosins	6	45	2186	3	rosins
rosiny	9	44	1453	3	rosiny
rota	4	58	3434	3	rota__
rotary	9	24	1130	3	rotary
rotas	5	48	2772	3	rota_s
rotate	6	33	2034	3	rotate
rotator	7	3	1083	3	rotator
roto	4	59	3505	3	ro__to
rotund	7	3	729	3	rotund
rouen	5	49	2090	3	rouen_
rouens	6	48	1444	3	rouens
round	6	43	1843	3	ro_und
roven	8	55	2197	3	roven_
roving	10	36	1874	3	roving
rowen	8	49	2115	3	rowen_
rowens	9	45	1530	3	rowens
rowing	10	36	2330	3	rowing
royal	8	50	1470	3	roya_l
royals	9	37	1126	3	royals
ruana	5	3	1242	3	r_uana
rubato	8	31	968	3	rubato
rumaki	12	3	513	3	rumaki
rumen	7	44	1950	3	rumen_
rumens	8	36	1181	3	rumens
rumina	8	34	1248	3	rumina
ryokan	13	5	375	3	ryokan_
ryokans	14	4	329	3	ryokans
socman	10	3	981	3	socman_
solan	5	53	2815	3	solan_
soland	7	51	1504	3	soland
solanos	7	44	1285	3	solanos
solans	6	41	2249	3	solans
soma	6	56	3529	3	soma__
somas	7	60	3037	3	soma_s
somata	8	3	1238	3	somata
somoni	8	3	1074	3	somoni
sonant	6	6	2195	3	sonant
soprano	9	3	700	3	soprano
sowans	9	42	1589	3	sowans
timpano	11	23	586	3	timpano
tolan	5	51	2401	3	tolan_
tolane	6	43	1658	3	tolane
tolans	6	43	1927	3	tolans
troland	8	3	754	3	troland
tympano	14	24	528	3	tympano
unman	7	27	1542	3	unman_
unmans	8	22	1199	3	unmans
volant	9	3	1632	3	volant
volcano	12	4	461	3	volcano
vomito	11	23	803	3	vomito
womaned	13	3	721	3	womaned
womanly	15	3	585	3	womanly
women	10	46	1925	3	women_
womyn	13	42	636	3	womyn_
yeoman	11	3	882	3	yeoman_
zocalo	17	3	580	3	zocalo

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.376	475242.0
2	DLD Change Limit	112716	349	5.170	21801.9
3	Display Results	349	349	0.110	3172.7
	(SQL Overall)	178691	349	5.656	31593.2