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

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

421 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
scarab	10	3	1006	(None)
scarabs	11	3	729	1	scarabs
carat	7	50	4879	2	_carat
carb	8	51	4316	2	_car_b
carob	9	53	2522	2	_carob
crab	8	57	2767	2	_c_rab
sacra	7	45	1699	2	sacra_
sacral	8	34	1441	2	sacral
saran	5	37	3030	2	s_aran
scab	8	59	2671	2	sc__ab
scalar	8	36	1243	2	scalar
scar	6	64	3420	2	scar__
scarce	10	40	1363	2	scarce
scare	7	53	3446	2	scar_e
scared	9	52	2729	2	scared
scarer	8	45	2461	2	scarer
scares	8	50	3300	2	scares
scarey	11	50	1698	2	scarey
scarf	10	54	2714	2	scar_f
scarfs	11	47	1468	2	scarfs
scarp	9	57	2410	2	scar_p
scarph	13	42	960	2	scarph
scarps	10	47	1860	2	scarps
scarry	11	63	1118	2	scarry
scars	7	54	3353	2	scar_s
scart	7	61	3977	2	scar_t
scarts	8	53	2149	2	scarts
scary	10	52	2259	2	scar_y
scrag	8	59	1617	2	sc_rag
scram	9	106	2162	2	sc_ram
scrap	9	71	2040	2	sc_rap
scrub	9	49	1420	2	sc_rub
svaraj	16	3	496	2	svaraj
swaraj	16	3	602	2	swaraj
acari	7	50	2028	3	acar_i
acarid	9	50	1707	3	acarid
acarus	8	3	1219	3	acarus
acerb	9	3	1276	3	acer_b
arak	8	69	2957	3	__arak
arb	5	104	4842	3	__ar_b
ascared	10	39	952	3	ascared
ascarid	10	39	1072	3	ascarid
ascaris	9	36	1332	3	ascaris
barb	8	52	4006	3	_bar_b
bharal	11	3	889	3	bharal
bicarb	12	3	854	3	bicar_b
cab	7	83	5540	3	_c__ab
cabal	9	52	2215	3	_cabal
cabob	11	46	1681	3	_cabob
caca	8	55	2808	3	_caca_
cacao	9	54	2000	3	_cacao
cacas	9	56	2798	3	_cacas
camas	9	63	3352	3	_camas
canal	7	54	2804	3	_canal
car	5	91	6556	3	_car__
carabao	11	3	967	3	_carabao
carabid	12	3	1133	3	_carabid
carabin	11	3	1321	3	_carabin
carack	14	21	1317	3	_carack
carafe	11	54	1616	3	_carafe
caramba	13	3	689	3	_caramba
carate	8	47	3400	3	_carate
carats	8	59	2902	3	_carats
carbo	9	49	2384	3	_carbo
carbs	9	60	3146	3	_carbs
card	7	102	4587	3	_car_d
cards	8	51	3793	3	_cards
care	6	69	6837	3	_car_e
cared	8	60	5009	3	_cared
carer	7	49	4233	3	_carer
cares	7	73	6918	3	_cares
caret	7	53	6056	3	_caret
carex	14	48	2230	3	_carex
cargo	8	53	2207	3	_cargo
caribe	10	34	1675	3	_caribe
cark	10	55	3927	3	_car_k
carks	11	55	3421	3	_carks
carl	6	51	4478	3	_car_l
carle	7	45	3570	3	_carle
carls	7	70	3742	3	_carls
carman	10	39	2074	3	_carman
carn	6	62	4543	3	_car_n
carnal	8	39	1921	3	_carnal
carns	7	59	3756	3	_carns
carny	10	58	2292	3	_carny
carobs	10	48	1810	3	_carobs
carol	7	51	2861	3	_carol
carom	9	50	2556	3	_carom
carp	8	51	3981	3	_car_p
carpal	10	37	1625	3	_carpal
carpi	9	43	1939	3	_carpi
carps	9	69	3225	3	_carps
carr	6	54	3470	3	_car_r
carrs	7	57	3085	3	_carrs
carry	10	58	2378	3	_carry
cars	6	73	6476	3	_car_s
carse	7	49	3433	3	_carse
cart	6	65	7034	3	_car_t
carte	7	59	4042	3	_carte
carts	7	89	4629	3	_carts
carve	10	62	2775	3	_carve
casa	6	56	3086	3	_casa_
casaba	10	7	926	3	_casaba
casas	7	53	2784	3	_casas
cascara	11	3	831	3	cascara_
cascaras	12	3	770	3	cascaras
charas	11	42	2361	3	charas
coral	7	60	3345	3	_coral
craal	7	41	1775	3	_craal
crabs	9	54	2139	3	_c_rabs
crag	7	56	2530	3	_c_rag
cram	8	56	3549	3	_c_ram
crap	8	57	3184	3	_c_rap
craw	9	77	2526	3	_c_raw
crib	8	63	2358	3	_c_rib
curb	8	67	3222	3	_cur_b
darb	7	60	3353	3	_dar_b
drab	7	62	2645	3	__drab
ecarte	8	43	1350	3	ecarte
escar	7	40	1199	3	escar__
escarp	10	44	900	3	escar_p
escarps	11	39	737	3	escarps
escars	8	39	1313	3	escar_s
farad	9	57	2067	3	_farad
garb	7	53	3267	3	_gar_b
grab	7	54	2761	3	__grab
kabab	13	48	1444	3	_kabab
karat	9	68	3759	3	_karat
mara	6	74	4457	3	_mara_
maras	7	54	4329	3	_maras
mascara	11	3	802	3	mascara_
mascaras	12	3	769	3	mascaras
mihrab	13	3	552	3	mihrab
nawab	10	8	1092	3	_nawab
para	6	52	4217	3	_para_
parae	7	63	3570	3	_parae
paras	7	61	4304	3	_paras
picara	10	3	1190	3	picara_
picaras	11	3	1128	3	picaras
sab	5	65	6320	3	s___ab
sabal	7	54	2248	3	s_abal
sabra	7	53	1785	3	sabra_
sabras	8	51	1636	3	sabras
sacrals	9	33	1179	3	sacrals
sacred	9	49	1710	3	sacred
sacrum	10	39	1014	3	sacrum
saga	5	53	3117	3	s_aga_
sagas	6	60	2588	3	s_agas
sahib	10	3	1476	3	s_ahib
salad	6	53	2183	3	s_alad
salal	5	54	2570	3	s_alal
samara	8	3	1385	3	samara_
samaras	9	3	1291	3	samaras
samba	9	56	1877	3	s_amba
sarans	6	42	2443	3	s_arans
sarape	8	48	1757	3	s_arape
sard	5	53	4424	3	s_ar_d
sardar	7	30	1317	3	s_ardar
sards	6	47	3618	3	s_ards
saree	5	50	4466	3	s_aree
sarge	6	55	3113	3	s_arge
sargo	6	54	2441	3	s_argo
sari	4	54	4404	3	s_ar_i
sarin	5	52	3925	3	s_arin
saris	5	45	4495	3	s_aris
sark	8	49	3897	3	s_ar_k
sarks	9	66	3246	3	s_arks
sarky	12	55	2178	3	s_arky
sarod	6	53	2587	3	s_arod
saros	5	52	3806	3	s_aros
sarsar	6	30	1184	3	s_arsar
satara	6	3	1553	3	satara_
sataras	7	3	1506	3	sataras
satay	8	47	1846	3	s_atay
satrap	8	62	1255	3	satrap
scabby	15	3	550	3	scabby
scabs	9	48	1864	3	sca_bs
scad	7	57	2577	3	sc__ad
scads	8	54	1996	3	sca_ds
scag	7	66	2689	3	sc__ag
scags	8	55	2097	3	sca_gs
scalable	12	17	1023	3	scalable
scalably	15	16	670	3	scalably
scalade	10	35	926	3	scalade
scalado	10	27	647	3	scalado
scalage	10	31	1053	3	scalage
scalare	9	33	1183	3	scalare
scalars	9	37	1190	3	scalars
scald	8	48	1812	3	sca_ld
scalds	9	48	1369	3	scalds
scale	7	46	2914	3	sca_le
scaled	9	48	2244	3	scaled
scaler	8	43	2160	3	scaler
scales	8	45	2931	3	scales
scall	7	44	2037	3	sca_ll
scalls	8	42	1820	3	scalls
scalp	9	52	1798	3	sca_lp
scalps	10	43	1523	3	scalps
scaly	10	47	1872	3	sca_ly
scam	8	59	3235	3	sc__am
scamp	11	57	1731	3	sca_mp
scampi	12	46	910	3	scampi
scamps	12	50	1417	3	scamps
scams	9	44	2397	3	sca_ms
scan	6	55	3045	3	sc__an
scandal	10	3	867	3	scandal
scans	7	46	2510	3	sca_ns
scant	7	97	3507	3	sca_nt
scants	8	52	1972	3	scants
scanty	11	40	1466	3	scanty
scape	9	69	2184	3	sca_pe
scaped	11	55	1955	3	scaped
scapes	10	51	2226	3	scapes
scarabaei	13	4	207	3	scarab~~aei~~
scaraboid	14	4	375	3	scarab~~oid~~
scarcer	11	39	1137	3	scarcer
scarers	9	46	1851	3	scarers
scarfed	13	47	1118	3	scarfed
scarfer	12	45	1108	3	scarfer
scarier	9	40	1787	3	scarier
scarify	15	3	744	3	scarify
scarily	12	3	1170	3	scarily
scaring	10	34	2197	3	scaring
scarlet	9	15	1694	3	scarlet
scarped	12	43	1440	3	scarped
scarper	11	48	1482	3	scarper
scarphs	14	43	741	3	scarphs
scarred	10	45	1263	3	scarred
scarted	10	48	1612	3	scarted
scarves	12	45	1162	3	scarves
scat	6	58	4837	3	sc__at
scathe	11	44	1499	3	scathe
scats	7	59	3060	3	sca_ts
scatt	7	60	3009	3	sca_tt
scatts	8	59	1466	3	scatts
scatty	11	53	1065	3	scatty
scaup	9	55	1599	3	sca_up
scaups	10	54	1193	3	scaups
scaur	7	58	1490	3	sca_ur
scaurs	8	55	1205	3	scaurs
scena	7	48	1578	3	scena_
scenas	8	41	1470	3	scenas
schav	13	3	831	3	sc_hav
schlub	13	5	500	3	schlub
schrik	15	20	670	3	schrik
schrod	12	4	788	3	schrod
schwa	13	42	684	3	schwa_
schwas	14	39	698	3	schwas
sclera	8	3	889	3	sclera_
sclerae	9	3	793	3	sclerae
scleral	9	3	786	3	scleral
scleras	9	4	822	3	scleras
scorch	13	19	809	3	scorch
score	7	55	2674	3	scor_e
scored	9	46	2113	3	scored
scorer	8	48	1826	3	scorer
scores	8	47	2592	3	scores
scoria	8	5	1350	3	scoria
scoriae	9	3	1090	3	scoriae
scorn	7	58	1745	3	scor_n
scorns	8	57	1302	3	scorns
scrags	9	57	1380	3	scrags
scrams	10	52	1662	3	scrams
scrape	10	59	1757	3	scrape
scraps	10	60	1724	3	scraps
scrawl	11	20	809	3	scrawl
screak	12	53	1106	3	screak
scream	10	48	1425	3	scream
scree	7	200	3171	3	sc_ree
screw	10	93	1854	3	sc_rew
scribe	10	46	1353	3	sc_ribe
scrim	9	54	1974	3	sc_rim
scrip	9	66	1919	3	sc_rip
scrod	8	51	1507	3	sc_rod
scrubs	10	42	1031	3	sc_rubs
scrum	9	54	1820	3	sc_rum
scry	9	60	1776	3	sc_r_y
scuba	9	42	1159	3	scuba_
scubas	10	37	1022	3	scubas
scurf	10	47	1932	3	scur_f
scurfs	11	32	1081	3	scurfs
scurfy	14	33	876	3	scurfy
scurry	11	41	959	3	scurry
scurvy	14	38	610	3	scurvy
scuta	7	58	1575	3	scuta_
seabag	9	3	847	3	seabag
seaman	8	40	1590	3	seaman
sear	4	73	5384	3	sear__
search	11	33	1242	3	search
seared	7	52	3284	3	seared
searer	6	54	3202	3	searer
sears	5	47	4491	3	sear_s
seawan	9	41	1122	3	seawan
seaway	12	30	999	3	seaway
sera	4	61	4139	3	s_era_
serac	7	59	2520	3	s_erac
serai	5	68	3016	3	s_erai
seral	5	63	3638	3	s_eral
serdab	9	3	783	3	serdab
shaman	11	33	1428	3	shaman
shamas	11	37	1794	3	shamas
sharable	13	19	1069	3	sharable
shard	9	61	2596	3	shar_d
shards	10	43	1917	3	shards
share	8	64	3708	3	shar_e
shared	10	58	2906	3	shared
sharer	9	50	2548	3	sharer
shares	9	52	3641	3	shares
sharia	9	31	1673	3	sharia
shariah	13	22	1053	3	shariah
sharias	10	25	1600	3	sharias
sharif	12	29	1712	3	sharif
shark	12	62	2502	3	shar_k
sharks	13	50	1972	3	sharks
sharn	8	48	2370	3	shar_n
sharns	9	55	1698	3	sharns
sharny	12	47	1183	3	sharny
sharp	10	49	2253	3	shar_p
sharps	11	55	1608	3	sharps
sharpy	14	52	1103	3	sharpy
shazam	20	4	662	3	shazam
shoran	9	40	1604	3	shoran
shrub	10	48	1489	3	s_hrub
sirra	5	44	1632	3	sirra_
sirrah	9	37	975	3	sirrah
sirras	6	38	1486	3	sirras
slab	6	71	3376	3	s__lab
slurb	7	41	1632	3	slur_b
smaragd	11	3	439	3	smaragd
smarm	9	55	1760	3	smar_m
smarms	10	57	1253	3	smarms
smarmy	13	62	935	3	smarmy
smart	7	58	3409	3	smar_t
smarts	8	62	1800	3	smarts
smarty	11	50	1379	3	smarty
snare	5	44	2998	3	snar_e
snared	7	48	2455	3	snared
snarer	6	46	2084	3	snarer
snares	6	53	2903	3	snares
snarf	8	65	2542	3	snar_f
snarfs	9	51	1342	3	snarfs
snark	9	54	1994	3	snar_k
snarks	10	48	1573	3	snarks
snarky	13	42	1084	3	snarky
snarl	5	49	2108	3	snar_l
snarls	6	40	1687	3	snarls
snarly	9	38	1500	3	snarly
soar	4	68	3867	3	soar__
soared	7	43	2429	3	soared
soarer	6	45	2224	3	soarer
soars	5	47	3251	3	soar_s
sora	4	57	4691	3	s_ora_
soras	5	50	4101	3	s_oras
sorb	6	83	3304	3	s_or_b
sovran	9	3	715	3	sovran
spar	6	54	3330	3	spar__
sparable	12	16	1198	3	sparable
spare	7	51	3556	3	spar_e
spared	9	54	2749	3	spared
sparer	8	45	2496	3	sparer
spares	8	48	3455	3	spares
sparge	9	42	1605	3	sparge
sparid	9	40	1693	3	sparid
spark	11	49	2089	3	spar_k
sparks	12	46	1636	3	sparks
sparky	15	45	1152	3	sparky
sparry	11	51	1130	3	sparry
spars	7	54	3154	3	spar_s
sparse	8	45	1634	3	sparse
spartan	9	4	833	3	spartan
spiral	8	37	1534	3	spiral
sporal	8	29	1545	3	sporal
sprag	8	64	1869	3	s_prag
sprat	7	66	3597	3	s_prat
spray	10	67	2006	3	s_pray
squab	16	38	1073	3	s_quab
stab	6	73	2993	3	s__tab
stalag	7	3	1002	3	stalag
star	4	80	3776	3	star__
starch	11	30	1320	3	starch
stare	5	44	4026	3	star_e
stared	7	54	2987	3	stared
starer	6	40	2736	3	starer
stares	6	60	3875	3	stares
stark	9	54	2562	3	star_k
starry	9	49	1167	3	starry
stars	5	58	3657	3	star_s
start	5	56	4231	3	star_t
starts	6	54	2312	3	starts
starve	9	46	1374	3	starve
statal	6	16	1322	3	statal
storax	13	8	978	3	storax
strap	7	79	2526	3	s_trap
straw	8	133	2129	3	s_traw
stray	8	85	2557	3	s_tray
styrax	16	7	524	3	styrax
sunray	9	3	1012	3	sunray
supra	7	36	1425	3	supra_
sura	4	57	4029	3	s_ura_
surah	8	68	2325	3	s_urah
sural	5	59	3126	3	s_ural
suras	5	53	3633	3	s_uras
surra	5	55	2134	3	surra_
surras	6	59	1953	3	surras
sutra	5	42	1793	3	sutra_
sutras	6	48	1859	3	sutras
swab	9	68	2531	3	s__wab
sward	9	42	2146	3	swar_d
swards	10	54	1513	3	swards
sware	8	58	2821	3	swar_e
swarf	11	53	2465	3	swar_f
swarfs	12	56	1206	3	swarfs
swarm	10	62	1884	3	swar_m
swarms	11	61	1217	3	swarms
swart	8	62	3464	3	swar_t
swarth	12	60	1208	3	swarth
swarty	12	58	1238	3	swarty
tiara	5	3	1591	3	tiara_
tiaras	6	3	1455	3	tiaras
vara	7	55	3088	3	_vara_
varas	8	60	2819	3	_varas

Search took 7 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.750	238254.7
2	DLD Change Limit	112716	421	5.216	21609.7
3	Display Results	421	421	0.143	2944.1
	(SQL Overall)	178691	421	6.109	29250.5