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

Here are the results of your fuzzy-string dictionary search for “suras” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

271 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
suras	5	53	3633	(None)
auras	5	59	3256	1	auras
buras	7	47	3630	1	buras
duras	6	57	2773	1	duras
muras	7	53	2958	1	muras
soras	5	50	4101	1	soras
subas	7	47	2407	1	subas
sura	4	57	4029	1	sura_
surah	8	68	2325	1	surah
surahs	9	45	1554	1	surahs
sural	5	59	3126	1	sural
surds	6	56	2466	1	surds
surfs	8	50	2254	1	surfs
surras	6	59	1953	1	surras
sutras	6	48	1859	1	sutras
arras	5	56	2613	2	arras
aura	4	58	3625	2	aura_
aurae	5	41	2811	2	aurae
aural	5	44	2896	2	aural
aurar	5	44	2025	2	aurar
aures	5	51	3709	2	aures
auris	5	53	3153	2	auris
boras	7	59	3830	2	boras
bras	6	57	4645	2	_bras
bunas	7	51	2657	2	bunas
bura	6	61	3953	2	bura_
buran	7	52	2530	2	buran
burans	8	50	1930	2	burans
burbs	9	54	2349	2	burbs
burds	8	46	2606	2	burds
burgs	8	49	2409	2	burgs
burkas	12	45	1380	2	burkas
burls	7	42	2885	2	burls
burns	7	49	2677	2	burns
burps	9	42	2017	2	burps
burqas	17	44	1090	2	burqas
burrs	7	49	2565	2	burrs
burs	6	58	4742	2	bur_s
bursa	7	49	2152	2	bursa
bursas	8	53	1827	2	bursas
cesuras	9	5	869	2	cesuras
curbs	9	48	2165	2	curbs
curds	8	57	2561	2	curds
cures	7	56	4543	2	cures
curfs	10	51	2214	2	curfs
curls	7	49	2710	2	curls
curns	7	49	2427	2	curns
currs	7	56	2439	2	currs
curs	6	56	4554	2	cur_s
douras	7	50	1672	2	douras
dumas	8	54	2043	2	dumas
dura	5	52	3211	2	dura_
dural	6	49	2389	2	dural
dures	6	56	3592	2	dures
durns	6	48	1986	2	durns
duros	6	54	2269	2	duros
durras	7	47	1337	2	durras
durrs	6	55	1999	2	durrs
eras	4	54	4150	2	_eras
euros	5	49	2024	2	euros
eyras	8	47	1592	2	eyras
furan	8	43	2001	2	furan
furans	9	45	1595	2	furans
furls	8	53	2205	2	furls
furs	7	67	3504	2	fur_s
guars	6	50	2105	2	guars
gurus	6	43	1819	2	gurus
horas	8	63	3310	2	horas
hulas	8	49	2088	2	hulas
hurds	9	52	1907	2	hurds
hurls	8	65	2271	2	hurls
hurts	8	69	2282	2	hurts
jubas	14	46	1422	2	jubas
judas	13	49	1188	2	judas
jura	11	60	2489	2	jura_
jural	12	51	2048	2	jural
jurat	12	48	2932	2	jurat
jurats	13	42	1320	2	jurats
koras	9	59	2711	2	koras
kurtas	10	34	988	2	kurtas
kurus	9	80	1563	2	kurus
lauras	6	34	1433	2	lauras
liras	5	60	2198	2	liras
lumas	7	56	2291	2	lumas
lunas	5	50	2501	2	lunas
lures	5	61	3853	2	lures
lurks	9	52	1874	2	lurks
maras	7	54	4329	2	maras
moras	7	64	3878	2	moras
mudras	9	42	1226	2	mudras
mura	6	56	3330	2	mura_
mural	7	52	2511	2	mural
murals	8	40	1676	2	murals
mures	7	59	3722	2	mures
murks	11	48	2173	2	murks
murras	8	49	1601	2	murras
murrs	7	55	2130	2	murrs
nurds	6	55	1852	2	nurds
nurls	5	55	1968	2	nurls
okras	9	44	1097	2	okras
ours	4	72	3756	2	our_s
paras	7	61	4304	2	paras
pujas	14	55	1332	2	pujas
pumas	9	51	2156	2	pumas
punas	7	48	2675	2	punas
pupas	9	52	1928	2	pupas
purdas	9	26	1226	2	purdas
puris	7	53	3202	2	puris
purls	7	47	2335	2	purls
purrs	7	53	2043	2	purrs
purs	6	56	4104	2	pur_s
ras	3	75	7539	2	__ras
rural	5	58	2117	2	rural
sabras	8	51	1636	2	sabras
sagas	6	60	2588	2	sagas
saran	5	37	3030	2	saran
sarans	6	42	2443	2	sarans
sards	6	47	3618	2	sards
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
saunas	6	39	1543	2	saunas
scars	7	54	3353	2	scars
scrag	8	59	1617	2	scrag
scrags	9	57	1380	2	scrags
scram	9	106	2162	2	scram
scrams	10	52	1662	2	scrams
scrap	9	71	2040	2	scrap
scraps	10	60	1724	2	scraps
scubas	10	37	1022	2	scubas
scurfs	11	32	1081	2	scurfs
sears	5	47	4491	2	sears
seas	4	57	5527	2	s_eas
sera	4	61	4139	2	sera_
serac	7	59	2520	2	serac
seracs	8	44	1857	2	seracs
serai	5	68	3016	2	serai
serais	6	43	2613	2	serais
seral	5	63	3638	2	seral
seres	5	54	4889	2	seres
serfs	8	49	2201	2	serfs
sers	4	57	4665	2	ser_s
sheas	8	63	3179	2	sheas
shris	8	42	2145	2	shris
shwas	11	64	1510	2	shwas
sikas	9	46	1702	2	sikas
simas	7	57	2755	2	simas
sires	5	59	4537	2	sires
sirras	6	38	1486	2	sirras
sirs	4	43	3833	2	sir_s
skas	8	53	2571	2	s_kas
skuas	9	56	1173	2	skuas
slurbs	8	43	974	2	slurbs
slurps	8	44	1000	2	slurps
slurs	5	41	2337	2	slur_s
soars	5	47	3251	2	soars
sobas	7	44	2425	2	sobas
socas	7	40	2618	2	socas
sodas	6	41	2354	2	sodas
sofas	8	53	2071	2	sofas
sojas	12	47	1639	2	sojas
somas	7	60	3037	2	somas
sora	4	57	4691	2	sora_
sorbs	7	50	2210	2	sorbs
sords	6	45	2780	2	sords
sores	5	54	5428	2	sores
sorns	5	50	2842	2	sorns
sorts	5	45	3666	2	sorts
sorus	5	45	2758	2	sorus
sours	5	52	3050	2	sour_s
soyas	8	45	2091	2	soyas
spars	7	54	3154	2	spars
spas	6	70	3672	2	s_pas
sprag	8	64	1869	2	sprag
sprags	9	57	1582	2	sprags
sprat	7	66	3597	2	sprat
sprats	8	58	1993	2	sprats
spray	10	67	2006	2	spray
sprays	11	59	1364	2	sprays
spurns	8	48	1138	2	spurns
spurs	7	46	2152	2	spur_s
spurts	8	48	1497	2	spurts
sris	4	54	3415	2	s_ris
stars	5	58	3657	2	stars
stoas	5	51	2602	2	stoas
strap	7	79	2526	2	strap
straps	8	77	2178	2	straps
strass	6	71	1722	2	strass
straw	8	133	2129	2	straw
straws	9	87	1867	2	straws
stray	8	85	2557	2	stray
strays	9	64	1793	2	strays
stupas	8	39	1088	2	stupas
sturts	6	39	1514	2	sturts
suba	6	49	2660	2	suba_
subah	10	60	1521	2	subah
subahs	11	45	1238	2	subahs
subs	6	60	3712	2	su_bs
sucks	11	45	2307	2	sucks
sucrase	9	3	1034	2	sucrase
sucres	8	42	1889	2	sucres
sudds	7	55	1359	2	sudds
suds	5	61	3529	2	su_ds
suers	5	51	2848	2	suers
sues	4	62	4765	2	su_es
suets	5	51	2610	2	suets
sugar	6	3	1291	2	sugar
sugars	7	3	1242	2	sugars
sughs	9	53	1332	2	sughs
suits	5	50	2805	2	suits
suks	8	59	2712	2	su_ks
sulfas	9	3	1156	2	sulfas
sulks	9	48	1846	2	sulks
sulus	5	48	2188	2	sulus
sumac	9	95	1488	2	sumac
sumacs	10	55	1210	2	sumacs
summas	10	43	1316	2	summas
sumos	7	57	2009	2	sumos
sumps	9	50	2343	2	sumps
sums	6	58	3758	2	su_ms
sunnas	6	39	1456	2	sunnas
sunns	5	50	1735	2	sunns
sunray	9	3	1012	2	sunray
sunrays	10	3	708	2	sunrays
suns	4	58	4190	2	su_ns
supes	7	56	2830	2	supes
supra	7	36	1425	2	supra_
sups	6	48	3443	2	su_ps
suqs	13	43	1965	2	su_qs
surbase	9	3	979	2	surbase
surd	5	64	3381	2	sur_d
sure	4	54	4741	2	sur_e
surer	5	48	3310	2	surer
surest	6	50	2676	2	surest
surf	7	60	3931	2	sur_f
surfy	11	53	1947	2	surfy
surge	6	50	2769	2	surge
surges	7	39	2459	2	surges
surgy	9	51	1852	2	surgy
surly	8	51	2443	2	surly
surpass	9	3	828	2	surpass
surra	5	55	2134	2	surra
surtax	13	3	784	2	surtax
suss	4	52	2930	2	su_ss
sutra	5	42	1793	2	sutra_
suttas	6	38	1379	2	suttas
toras	5	55	4037	2	toras
tsuris	6	27	1020	2	tsuris
tubas	7	51	1958	2	tubas
tufas	8	53	1438	2	tufas
tunas	5	42	2412	2	tunas
turds	6	50	2169	2	turds
turfs	8	46	2044	2	turfs
turks	9	53	2082	2	turks
turns	5	56	2323	2	turns
turps	7	49	1873	2	turps
upas	6	83	2238	2	_upas
urase	5	46	2469	2	_urase
urbs	6	59	2205	2	_urbs
urds	5	59	2242	2	_urds
ureas	5	58	2601	2	_ureas
urns	4	63	2389	2	_urns
urps	6	69	2047	2	_urps
ursa	4	41	1690	2	_ursa
urus	4	64	2613	2	_urus
usurps	8	10	507	2	usurps
utas	4	59	2495	2	_utas
varas	8	60	2819	2	varas
yucas	10	60	1391	2	yucas
yugas	9	50	1206	2	yugas
yurts	8	72	1653	2	yurts

Search took 3 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	53800	0.330	541487.9
2	DLD Change Limit	53800	271	1.686	31909.8
3	Display Results	271	271	0.063	4301.6
	(SQL Overall)	178691	271	2.079	85950.5