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

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

350 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
random	9	25	1355	(None)
fandom	12	21	1089	1	fandom
randoms	10	21	1243	1	randoms
ransom	8	24	1094	1	ransom
bandog	10	3	872	2	bandog
candor	9	45	1642	2	candor
condom	11	42	1536	2	condom
fandoms	13	22	947	2	fandoms
fantom	11	21	1080	2	fantom
grandam	11	3	939	2	grandam
hansom	11	21	915	2	hansom
radome	9	5	1187	2	ra_dome
radon	6	46	2050	2	ra_don
rancor	8	8	1037	2	rancor
rand	5	58	3956	2	rand__
randan	7	3	1525	2	randan
randomly	14	4	379	2	randomly
rands	6	59	3045	2	rand_s
randy	9	50	2208	2	rand_y
ransoms	9	24	1016	2	ransoms
rhabdom	15	4	338	2	rhabdom
rondo	6	52	1837	2	rondo_
rondos	7	46	1672	2	rondos
tandem	9	3	1140	2	tandem
transom	9	4	882	2	transom
abandon	10	4	546	3	abandon
ado	4	91	4687	3	_a_do_
ados	5	76	3351	3	_a_dos
aldol	6	12	1233	3	_aldol
anadem	9	3	918	3	_anadem
ancon	7	57	1823	3	_ancon
and	4	72	4416	3	_and__
andro	6	3	1416	3	_andro
andros	7	3	1330	3	_andros
ands	5	78	3361	3	_and_s
anion	5	50	2881	3	_anion
annoy	8	6	971	3	_annoy
anoa	4	56	3447	3	_an_oa
anode	6	50	2103	3	_anode
anomy	10	51	1339	3	_an_omy
anon	4	61	3485	3	_an_on
anyon	8	56	1522	3	_anyon
ardor	6	46	1786	3	_ardor
atom	6	78	2452	3	_a_tom
axiom	14	39	1359	3	_axiom
banco	9	40	1939	3	banco_
bancos	10	47	1389	3	bancos
band	7	67	4090	3	band__
banda	8	52	2310	3	band_a
bandas	9	51	2054	3	bandas
bandbox	19	4	376	3	bandbox
banded	10	52	2317	3	banded
bander	9	39	2822	3	bander
bandit	9	38	2113	3	bandit
bandogs	11	3	836	3	bandogs
bandora	10	3	881	3	bandora
bandore	10	6	1163	3	bandore
bands	8	52	3342	3	band_s
bandy	11	48	2418	3	band_y
banjo	14	38	1244	3	banjo_
banjos	15	37	889	3	banjos
bantam	10	3	1406	3	bantam
brand	8	51	2449	3	brand__
branded	11	44	1410	3	branded
brander	10	39	1582	3	brander
brands	9	51	1894	3	brand_s
brandy	12	47	1206	3	brand_y
candid	10	45	1785	3	candid
candle	9	43	2148	3	candle
candors	10	42	1676	3	candors
candour	10	42	1023	3	candour
candy	11	51	1982	3	cand_y
cannon	8	45	1444	3	cannon
cannot	8	36	1677	3	cannot
canoe	7	56	2725	3	can_oe
canon	7	47	2530	3	can_on
canso	7	50	1940	3	canso_
cansos	8	49	1538	3	cansos
cantdog	11	3	457	3	cantdog
canto	7	49	3101	3	canto_
canton	8	57	2299	3	canton
cantor	8	56	2152	3	cantor
cantos	8	48	2697	3	cantos
canyon	11	45	1203	3	canyon
cardon	9	41	2085	3	cardon
carom	9	50	2556	3	ca_rom
carrom	10	5	1340	3	carrom
condo	8	53	2259	3	condo_
condoms	12	42	1408	3	condoms
condor	9	46	1696	3	condor
condos	9	43	2233	3	condos
cranium	11	9	1110	3	cranium
crannog	10	4	424	3	crannog
cundum	11	3	651	3	cundum
czardom	21	4	418	3	czardom
dado	6	71	2633	3	da_do_
dados	7	55	2243	3	da_dos
dander	8	112	2299	3	dander
dandle	8	42	1809	3	dandle
dandy	10	44	1670	3	dand_y
danio	6	3	1978	3	danio_
danios	7	3	1460	3	danios
dogdom	11	8	636	3	dogdom
dom	6	97	5244	3	___dom
earldom	10	4	458	3	earldom
endow	9	45	1098	3	_endow
fado	8	72	2646	3	fa_do_
fados	9	56	2073	3	fa_dos
fanion	9	45	1432	3	fanion
fano	7	58	3168	3	fan_o_
fanon	8	46	1901	3	fan_on
fanos	8	59	2650	3	fan_os
fantod	10	20	1003	3	fantod
fantoms	12	18	915	3	fantoms
fanum	10	3	1344	3	fan_um
fathom	14	3	747	3	fathom
freedom	13	4	585	3	freedom
gander	8	43	2276	3	gander
ganof	9	54	2036	3	gan_of
genom	8	37	1684	3	gen_om
grand	7	51	2269	3	grand__
grandad	10	3	845	3	grandad
grandame	12	4	711	3	grandame
grandams	12	3	712	3	grandams
granddam	13	4	469	3	granddam
grandee	9	31	1551	3	grandee
grander	9	33	1587	3	grander
grandly	12	3	874	3	grandly
grandma	11	3	691	3	grandma
grandpa	11	3	541	3	grandpa
grands	8	42	1824	3	grand_s
grandson	10	5	541	3	grandson
grantor	8	40	1093	3	grantor
granum	9	3	1091	3	gran_um
gundog	9	3	579	3	gundog
hagdon	11	8	828	3	hagdon
halidom	13	8	644	3	halidom
hand	8	68	3370	3	hand__
handax	17	4	958	3	handax
handed	11	49	1998	3	handed
hander	10	45	2643	3	hander
handle	10	42	1929	3	handle
handloom	14	4	461	3	handloom
handoff	17	5	648	3	handoff
handout	11	3	1410	3	handout
hands	9	53	2738	3	hand_s
handsome	14	4	760	3	handsome
handy	12	55	2087	3	hand_y
hangdog	13	4	313	3	hangdog
hansoms	12	23	852	3	hansoms
indol	6	37	1487	3	_indol
indow	9	50	1166	3	_indow
jarldom	17	4	312	3	jarldom
kendo	10	51	1322	3	kendo_
kendos	11	45	1066	3	kendos
kingdom	15	4	354	3	kingdom
land	5	63	3730	3	land__
landau	7	3	1061	3	landau
landed	8	46	1924	3	landed
lander	7	40	2848	3	lander
landform	14	4	522	3	landform
lands	6	54	2690	3	land_s
lapdog	10	3	444	3	lapdog
lardon	7	44	1506	3	lardon
madam	10	3	1622	3	ma_dam
madtom	11	3	802	3	madtom
mandola	10	3	902	3	mandola
mango	8	57	2431	3	mango_
mangos	9	43	1933	3	mangos
manioc	10	39	1482	3	manioc
mano	6	65	3679	3	man_o_
manor	7	80	2392	3	man_or
manos	7	49	3361	3	man_os
mondo	8	57	2123	3	mondo_
mondos	9	52	1733	3	mondos
nandin	7	3	1303	3	nandin
nanism	8	3	1120	3	nanism
nom	5	104	5064	3	__n_om
noncom	10	3	968	3	noncom
nonrandom	12	5	294	3	~~non~~random
pagandom	14	4	353	3	pagandom
panda	8	50	2261	3	pand_a
pandas	9	55	2196	3	pandas
pander	9	37	2552	3	pander
pandit	9	38	2075	3	pandit
pandoor	10	35	858	3	pandoor
pandora	10	3	954	3	pandora
pandore	10	4	1185	3	pandore
pandour	10	40	821	3	pandour
pandy	11	50	2117	3	pand_y
panto	7	61	2941	3	panto_
pantos	8	52	2274	3	pantos
pantoum	11	3	870	3	pantoum
papadom	14	6	676	3	papadom
pardon	9	46	1873	3	pardon
phantom	14	3	668	3	phantom
racism	10	32	1419	3	racism
racon	7	54	2214	3	ra_con
racoon	8	38	1447	3	racoon
rad	4	76	6200	3	ra_d__
radar	6	13	1672	3	ra_dar
radded	9	47	1649	3	radded
raddle	8	48	1617	3	raddle
radii	6	40	1641	3	ra_dii
radio	6	49	2249	3	ra_dio
radios	7	40	1867	3	radios
radium	9	35	1329	3	radium
radix	13	44	1459	3	ra_dix
radomes	10	3	1104	3	ra_domes
radons	7	41	1852	3	ra_dons
rads	5	60	4660	3	ra_d_s
ragtop	9	3	668	3	ragtop
raid	5	52	4307	3	raid__
raided	8	50	1770	3	raided
raider	7	43	1874	3	raider
raids	6	58	2751	3	raid_s
rainbow	12	4	335	3	rainbow
raindrop	11	4	278	3	raindrop
ram	5	68	6727	3	ra___m
ramrod	9	3	683	3	ramrod
ramson	8	3	1046	3	ramson
ran	3	82	6661	3	ran___
rance	7	50	2851	3	ran_ce
rances	8	46	2544	3	rances
ranch	10	50	1979	3	ran_ch
rancho	11	43	1085	3	rancho
ranchos	12	39	1139	3	ranchos
rancid	9	5	1386	3	rancid
rancors	9	8	1137	3	rancors
rancour	9	8	713	3	rancour
randans	8	3	1321	3	randans
randier	8	36	1847	3	randier
randies	8	42	2566	3	randies
randomize	21	4	416	3	random~~ize~~
ranee	5	54	3810	3	ran_ee
ranees	6	46	2396	3	ranees
rang	5	69	3915	3	ran__g
range	6	47	2841	3	ran_ge
ranged	8	48	2431	3	ranged
ranger	7	39	2552	3	ranger
ranges	7	38	2692	3	ranges
rangy	9	53	2038	3	ran_gy
rani	4	66	4010	3	ran__i
ranid	6	64	2933	3	ran_id
ranids	7	51	1870	3	ranids
ranis	5	52	3583	3	ran_is
rank	8	51	3552	3	ran__k
ranked	11	46	2074	3	ranked
ranker	10	50	2190	3	ranker
rankle	10	34	1488	3	rankle
rankly	13	39	1045	3	rankly
ranks	9	52	2573	3	ran_ks
ransomed	11	4	693	3	ransomed
ransomer	10	4	788	3	ransomer
rant	4	58	6467	3	ran__t
ranted	7	43	2470	3	ranted
ranter	6	38	2682	3	ranter
rants	5	59	3534	3	ran_ts
ranula	6	3	1181	3	ranula
raptor	8	39	1282	3	raptor
ratio	5	52	2758	3	ratio_
ration	6	42	2601	3	ration
ratios	6	49	2267	3	ratios
rato	4	54	3697	3	ra_to_
ratoon	6	44	1737	3	ratoon
ratos	5	55	2876	3	ra_tos
ratton	6	41	1612	3	ratton
rayon	8	38	1570	3	ra_yon
razor	14	30	1260	3	ra_zor
redo	5	60	2936	3	r_edo_
redon	6	54	2488	3	r_edon
redos	6	51	2676	3	r_edos
redox	13	47	1423	3	r_edox
reendow	11	28	506	3	reendow
rend	5	61	3657	3	rend__
rended	8	45	2410	3	rended
render	7	40	2414	3	render
rends	6	51	2995	3	rend_s
renvoi	9	4	586	3	renvoi
rhabdome	16	4	329	3	rhabdome
rhabdoms	16	4	333	3	rhabdoms
rind	5	65	3560	3	rind__
rinded	8	44	1898	3	rinded
rinds	6	48	2614	3	rind_s
rindy	9	57	1739	3	rind_y
rom	5	98	5563	3	r___om
rondel	7	32	1264	3	rondel
ronion	6	33	1564	3	ronion
ronyon	9	30	913	3	ronyon
room	6	62	3508	3	r__oom
rundle	7	32	1423	3	rundle
rundown	11	6	544	3	rundown
rynd	8	64	1410	3	rynd__
rynds	9	56	997	3	rynd_s
saintdom	11	4	245	3	saintdom
sand	5	53	3846	3	sand__
sandal	7	33	1728	3	sandal
sandbox	17	4	480	3	sandbox
sanded	8	49	2061	3	sanded
sander	7	48	2853	3	sander
sandhi	10	3	819	3	sandhi
sandhog	12	7	545	3	sandhog
sandlot	8	3	1169	3	sandlot
sands	6	52	2858	3	sand_s
sandworm	14	4	632	3	sandworm
sandy	9	42	2113	3	sand_y
sannop	8	3	737	3	sannop
santo	5	62	2728	3	santo_
santol	6	45	1524	3	santol
santos	6	44	2183	3	santos
seldom	9	3	940	3	seldom
shahdom	16	4	396	3	shahdom
sodom	8	8	1490	3	_sodom
stardom	10	3	776	3	stardom
sundog	8	3	761	3	sundog
syncom	13	3	609	3	syncom
tandems	10	3	763	3	tandems
tandoor	8	27	856	3	tandoor
tango	6	69	2117	3	tango_
tangos	7	42	1630	3	tangos
tannoy	9	5	835	3	tannoy
tanto	5	57	2494	3	tanto_
tardo	6	53	2110	3	tardo_
tendon	7	3	1203	3	tendon
thraldom	14	4	281	3	thraldom
tondo	6	97	1868	3	tondo_
tondos	7	51	1591	3	tondos
trangam	10	3	933	3	trangam
transoms	10	4	893	3	transoms
tsardom	10	4	448	3	tsardom
tzardom	19	4	373	3	tzardom
undo	5	56	2015	3	_undo_
uranism	9	11	1251	3	uranism
uranium	9	6	1002	3	uranium
vagrom	12	3	594	3	vagrom
vanda	9	45	1592	3	vand_a
vandal	10	37	1383	3	vandal
vandas	10	39	1599	3	vandas
varoom	11	4	1141	3	varoom
vendor	10	35	980	3	vendor
venom	10	39	1486	3	ven_om
wand	8	58	3387	3	wand__
wander	10	44	2371	3	wander
wandle	10	53	1666	3	wandle
wands	9	64	2548	3	wand_s
wanion	9	32	1306	3	wanion
wanton	9	44	1381	3	wanton
window	13	4	736	3	window
wisdom	12	3	598	3	wisdom
zander	16	34	1711	3	zander

Search took 9 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.140	1276364.3
2	DLD Change Limit	112716	350	8.410	13402.6
3	Display Results	350	350	0.170	2058.8
	(SQL Overall)	178691	350	8.720	20492.1