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

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

332 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
schlep	13	4	709	(None)
schlepp	16	6	295	1	schlepp
schleps	14	4	548	1	schleps
shlep	10	49	1483	1	s_hlep
cheep	12	54	1650	2	_cheep
salep	7	70	2295	2	s_alep
scale	7	46	2914	2	scale_
scaled	9	48	2244	2	scaled
scaler	8	43	2160	2	scaler
scales	8	45	2931	2	scales
scaleup	11	3	448	2	scaleup
scalp	9	52	1798	2	scal_p
schlepps	17	6	256	2	schlepps
schlub	13	5	500	2	schlub
schlump	16	4	326	2	schlump
scolex	15	3	824	2	scolex
sculp	9	53	1484	2	scul_p
sheep	10	53	2152	2	s_heep
shlepp	13	36	619	2	s_hlepp
shleps	11	47	1033	2	s_hleps
acaleph	14	5	344	3	acaleph
ache	9	68	2982	3	ach_e_
ached	11	92	2783	3	ach_ed
aches	10	61	3229	3	ach_es
achier	11	39	1426	3	achier
aculei	8	3	979	3	aculei
ashler	9	45	997	3	ashler
celeb	9	3	1487	3	_celeb
cep	7	57	3633	3	_c__ep
chaleh	14	37	1199	3	_chaleh
chalet	11	38	2599	3	_chalet
champ	14	50	1796	3	_champ
chap	11	49	2849	3	_ch_ap
chape	12	52	2114	3	_chape
cheap	12	69	1594	3	_cheap
cheek	14	51	1571	3	_cheek
cheeps	13	53	1291	3	_cheeps
cheer	10	54	2038	3	_cheer
chef	12	51	2562	3	_ch_ef
chela	10	39	1680	3	_chela
chew	12	66	2213	3	_ch_ew
chez	18	45	1902	3	_ch_ez
chief	13	44	1948	3	_chief
chiel	10	49	1897	3	_chiel
chile	10	56	2689	3	_chile_
chiles	11	54	2530	3	_chiles
chimp	14	52	1647	3	_chimp
chip	11	67	2642	3	_ch_ip
chirp	12	47	1716	3	_chirp
choler	11	37	1715	3	_choler
chomp	14	48	1566	3	_chomp
chop	11	60	2492	3	_ch_op
chump	14	53	1544	3	_chump
chyle	13	49	1348	3	_chyle_
chyles	14	48	1328	3	_chyles
clap	8	64	2904	3	_c_lap
clef	9	70	2818	3	_c_lef
clepe	9	46	1738	3	_c_lepe
clept	9	57	2577	3	_c_lept
clew	9	55	2057	3	_c_lew
clip	8	69	2400	3	_c_lip
clop	8	69	2989	3	_c_lop
cochlea	14	3	534	3	cochlea
cole	6	69	5611	3	_cole_
coled	8	55	4076	3	_coled
coles	7	60	5506	3	_coles
creep	9	52	1810	3	_creep
culet	7	60	4034	3	_culet
culex	14	46	1393	3	_culex
eche	9	75	2028	3	ech_e_
eched	11	69	1922	3	ech_ed
eches	10	63	2216	3	ech_es
echoed	12	52	1115	3	echoed
echoer	11	40	1110	3	echoer
echoes	11	47	1552	3	echoes
echoey	14	39	785	3	echoey
escalop	11	4	478	3	escalop
eschew	14	3	633	3	esch_ew
help	9	53	2892	3	__help
hep	8	66	4414	3	__h_ep
julep	14	3	1053	3	_julep
kelep	11	60	1456	3	_kelep
ocher	10	45	1610	3	och_er
ochre	10	34	1159	3	ochre_
ochrea	11	31	664	3	ochrea
ochred	12	32	800	3	ochred
ochres	11	35	1083	3	ochres
oscule	8	3	819	3	oscule_
oscules	9	3	812	3	oscules
sable	7	47	3216	3	sable_
sables	8	50	2669	3	sables
sachem	13	40	1222	3	sach_em
sachet	11	47	2577	3	sach_et
sailed	7	43	2776	3	sailed
sailer	6	35	2610	3	sailer
sale	4	49	5970	3	s_ale_
saleps	8	50	1490	3	s_aleps
sales	5	60	5559	3	s_ales
sallet	6	37	3454	3	sallet
salp	6	45	3409	3	s_al_p
samlet	8	41	2656	3	samlet
scalar	8	36	1243	3	scalar
scald	8	48	1812	3	scal_d
scalded	11	40	976	3	scalded
scalds	9	48	1369	3	scalds
scalene	9	3	1077	3	scalene
scaleni	9	3	688	3	scaleni
scalepan	12	4	451	3	scalepan
scalers	9	38	1726	3	scalers
scaleups	12	4	339	3	scaleups
scalier	9	43	1691	3	scalier
scall	7	44	2037	3	scal_l
scallop	11	23	764	3	scallop
scalls	8	42	1820	3	scalls
scalped	12	44	1199	3	scalped
scalpel	11	37	771	3	scalpel
scalper	11	39	1292	3	scalper
scalps	10	43	1523	3	scalps
scaly	10	47	1872	3	scal_y
scamp	11	57	1731	3	sc_amp
scape	9	69	2184	3	scape_
scaped	11	55	1955	3	scaped
scapes	10	51	2226	3	scapes
scare	7	53	3446	3	scare_
scared	9	52	2729	3	scared
scarer	8	45	2461	3	scarer
scares	8	50	3300	3	scares
scarey	11	50	1698	3	scarey
scarlet	9	15	1694	3	scarlet
scarp	9	57	2410	3	sc_arp
scaup	9	55	1599	3	sc_aup
scene	7	72	2057	3	scene_
scenes	8	45	2035	3	scenes
schappe	16	3	527	3	schappe
schav	13	3	831	3	sch_av
schavs	14	3	649	3	schavs
schema	13	8	837	3	schema
scheme	13	7	963	3	scheme
schemed	15	7	775	3	schemed
schemer	14	7	796	3	schemer
schemes	14	8	966	3	schemes
schiller	13	29	647	3	schiller
schism	13	3	817	3	schism
schist	11	3	1265	3	schist
schizo	20	11	599	3	schizo
schizy	23	11	504	3	schizy
schlepped	19	4	223	3	schlepped
schliere	13	4	384	3	schliere
schlock	18	23	587	3	schlock
schlubs	14	4	319	3	schlubs
schlumps	17	4	274	3	schlumps
schlumpy	20	4	187	3	schlumpy
schmear	14	8	404	3	schmear
schmeer	14	7	536	3	schmeer
schmo	12	45	1020	3	sch_mo
schmoe	13	32	833	3	schmoe
schmoes	14	30	854	3	schmoes
schmos	13	37	915	3	schmos
schnaps	14	4	370	3	schnaps
schnoz	20	3	565	3	schnoz
scholar	12	3	695	3	scholar
scholia	12	3	783	3	scholia
school	11	4	1072	3	school
schooled	14	4	705	3	schooled
schorl	11	7	981	3	schorl
schrik	15	20	670	3	schrik
schrod	12	4	788	3	schrod
schtik	15	18	542	3	schtik
schuit	11	3	956	3	schuit
schul	10	25	1041	3	sch_ul
schuln	11	25	623	3	schuln
schuls	11	29	985	3	schuls
schuss	11	18	673	3	schuss
schwa	13	42	684	3	sch_wa
schwas	14	39	698	3	schwas
scilla	8	3	1094	3	scilla
sclera	8	3	889	3	sc_lera
scold	8	54	1486	3	scol_d
scolded	11	35	886	3	scolded
scolder	10	32	1034	3	scolder
scolds	9	50	1123	3	scolds
scollop	11	27	543	3	scollop
scone	7	46	2183	3	scone_
scones	8	45	2130	3	scones
scoop	9	56	1716	3	sc_oop
scop	8	59	2552	3	sc__op
scope	9	48	2148	3	scope_
scoped	11	51	1665	3	scoped
scopes	10	47	1959	3	scopes
score	7	55	2674	3	score_
scored	9	46	2113	3	scored
scorer	8	48	1826	3	scorer
scores	8	47	2592	3	scores
scoter	8	38	1548	3	scoter
scowed	12	44	1383	3	scowed
scowled	13	39	819	3	scowled
scowler	12	24	819	3	scowler
scrap	9	71	2040	3	sc_rap
scrape	10	59	1757	3	scrape
scree	7	200	3171	3	sc_ree
screed	9	57	1893	3	screed
screen	8	52	1602	3	screen
screes	8	50	2397	3	screes
screw	10	93	1854	3	sc_rew
scried	9	58	1730	3	scried
scries	8	52	2682	3	scries
scrimp	12	51	1058	3	scrimp
scrip	9	66	1919	3	sc_rip
scroop	10	29	978	3	scroop
sculch	13	22	621	3	sculch
sculk	11	51	1246	3	scul_k
sculked	14	30	718	3	sculked
sculker	13	31	832	3	sculker
sculks	12	36	1026	3	sculks
scull	7	53	1576	3	scul_l
sculled	10	29	1169	3	sculled
sculler	9	98	1215	3	sculler
sculls	8	46	1388	3	sculls
sculped	12	39	825	3	sculped
sculps	10	46	1175	3	sculps
sculpt	10	44	1269	3	sculpt
scup	8	48	2238	3	sc__up
scute	7	55	2094	3	scute_
scutes	8	52	1919	3	scutes
sealed	7	43	2836	3	sealed
sealer	6	39	2896	3	sealer
seeled	7	39	2209	3	seeled
seep	6	65	4034	3	s__eep
selle	5	44	2831	3	selle_
seller	6	38	2460	3	seller
selles	6	44	2698	3	selles
shale	8	53	3283	3	shale_
shaled	10	50	2395	3	shaled
shales	9	47	3125	3	shales
shaley	12	37	1499	3	shaley
shape	10	51	2511	3	s_hape
sharp	10	49	2253	3	s_harp
she	6	68	3769	3	s_h_e_
shea	7	60	3157	3	s_h_ea
shed	8	65	3615	3	s_h_ed
sheen	8	50	2331	3	s_heen
sheer	8	47	2689	3	s_heer
sheet	8	48	3696	3	s_heet
shelf	11	52	2111	3	s_helf
shell	8	44	2412	3	s_hell
shes	7	57	3435	3	s_h_es
shew	10	80	3076	3	s_h_ew
shied	9	61	2549	3	s_hied
shiel	8	110	2377	3	s_hiel
shier	8	54	2894	3	s_hier
shies	8	61	3655	3	s_hies
ship	9	52	2824	3	s_h_ip
shlepps	14	39	483	3	s_hlepps
shlub	10	54	1174	3	s_hlub
shlump	13	4	571	3	s_hlump
shoe	7	59	3344	3	s_hoe_
shoed	9	57	2301	3	s_hoed
shoer	8	47	2216	3	s_hoer
shoes	8	54	2966	3	s_hoes
shop	9	56	2984	3	s_h_op
shred	9	81	2561	3	s_hred
shrew	11	97	2017	3	s_hrew
shyer	11	47	1478	3	s_hyer
sickle	12	44	1832	3	sickle_
sickled	14	47	1343	3	sickled
sickles	13	34	1754	3	sickles
sidle	6	51	2403	3	sidle_
sidled	8	42	1517	3	sidled
sidler	7	47	1696	3	sidler
sidles	7	47	2115	3	sidles
silex	12	34	1741	3	s_ilex
siller	6	40	2606	3	siller
skelp	11	42	1142	3	skel_p
skep	10	52	1935	3	s__kep
slap	6	64	3404	3	s__lap
sled	5	53	3437	3	s__led
sleep	7	49	2018	3	s_leep
slept	7	57	2810	3	s__lept
slew	7	62	2823	3	s__lew
slip	6	70	3173	3	s__lip
slop	6	65	3387	3	s__lop
smile	7	48	2392	3	smile_
smiled	9	37	1643	3	smiled
smiler	8	39	1668	3	smiler
smiles	8	45	2229	3	smiles
smiley	11	40	1230	3	smiley
socle	7	4	1957	3	socle_
socles	8	4	1845	3	socles
soiled	7	38	2247	3	soiled
sole	4	60	5367	3	s_ole_
soled	6	58	3517	3	s_oled
solei	5	56	2434	3	s_olei
soles	5	55	4792	3	s_oles
souled	7	54	1982	3	souled
spale	7	49	2921	3	spale_
spales	8	47	2810	3	spales
spile	7	52	3008	3	spile_
spiled	9	46	2199	3	spiled
spiles	8	42	2791	3	spiles
stale	5	56	3710	3	stale_
staled	7	47	2810	3	staled
staler	6	40	2582	3	staler
stales	6	55	3829	3	stales
steep	7	60	2070	3	s_teep
stele	5	50	2684	3	stele_
steles	6	37	2566	3	steles
step	6	71	2629	3	s__tep
stile	5	49	3157	3	stile_
stiles	6	43	2877	3	stiles
stole	5	49	2881	3	stole_
stoled	7	45	2159	3	stoled
stolen	6	43	1506	3	stolen
stoles	6	39	2767	3	stoles
strep	7	71	2085	3	s_trep
style	8	55	1936	3	style_
styled	10	56	1310	3	styled
styler	9	40	1330	3	styler
styles	9	44	1865	3	styles
stylet	9	40	1857	3	stylet
sublet	8	28	2724	3	sublet
suckle	12	40	1596	3	suckle_
suckled	14	42	1251	3	suckled
suckler	13	34	1309	3	suckler
suckles	13	45	1674	3	suckles
sullen	6	29	1429	3	sullen
sutler	6	37	1839	3	sutler
swale	8	52	2159	3	swale_
swales	9	39	2076	3	swales
sweep	10	47	1572	3	s_weep
wheep	13	62	1435	3	_wheep
whelp	13	60	1209	3	_whelp
yclept	13	3	601	3	yc_lept

Search took 10 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	332	8.423	13381.9
3	Display Results	332	332	0.093	3569.9
	(SQL Overall)	178691	332	9.266	19284.6