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

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

245 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
parled	9	46	2629	(None)
marled	9	55	2316	1	marled
paled	8	55	3872	1	pa_led
palled	9	46	2516	1	palled
pared	8	69	4676	1	par_ed
parged	10	49	2204	1	parged
parked	13	44	2514	1	parked
parle	7	58	3616	1	parle_
parles	8	63	3440	1	parles
parley	11	67	1836	1	parley
paroled	10	42	1763	1	paroled
parred	9	50	2407	1	parred
parsed	9	63	2389	1	parsed
parted	9	42	2868	1	parted
pearled	10	4	1155	1	pearled
purled	9	45	2075	1	purled
abled	8	69	2683	2	_abled
ailed	6	62	4028	2	_ailed
arced	8	82	2416	2	_arced
argled	8	53	1455	2	_argled
ariled	7	56	2032	2	_ariled
arles	5	67	3574	2	_arles
armed	8	63	2443	2	_armed
axled	13	53	1581	2	_axled
bailed	9	47	2665	2	bailed
baled	8	54	3644	2	ba_led
balled	9	49	2689	2	balled
barbed	11	51	2131	2	barbed
barded	10	54	2642	2	barded
bared	8	51	4448	2	bar_ed
barfed	12	54	1638	2	barfed
barged	10	58	2264	2	barged
barked	13	50	2731	2	barked
barley	11	51	1676	2	barley
barned	9	56	2358	2	barned
barred	9	57	2579	2	barred
bawled	12	44	1569	2	bawled
birled	9	44	1699	2	birled
burled	9	48	2538	2	burled
byrled	12	43	717	2	byrled
cabled	11	48	1987	2	cabled
called	9	41	2673	2	called
carded	10	54	2490	2	carded
cared	8	60	5009	2	car_ed
caried	9	45	2869	2	caried
carked	13	40	2482	2	carked
carle	7	45	3570	2	carle_
carles	8	54	3508	2	carles
caroled	10	37	1769	2	caroled
carped	11	59	2376	2	carped
carted	9	86	3144	2	carted
carved	12	43	2085	2	carved
curled	9	50	2165	2	curled
dared	7	59	3501	2	dar_ed
darked	12	39	1963	2	darked
darkled	13	37	872	2	darkled
darned	8	50	1848	2	darned
darted	8	46	2092	2	darted
dartled	9	40	985	2	dartled
dirled	8	45	1490	2	dirled
eagled	8	29	1404	2	eagled
eared	6	51	3950	2	ear_ed
earned	7	48	1833	2	earned
fabled	12	42	1638	2	fabled
failed	10	54	2160	2	failed
farced	12	52	1653	2	farced
farded	11	45	1895	2	farded
fared	9	58	4234	2	far_ed
farle	8	69	2924	2	farle_
farles	9	60	2578	2	farles
farmed	12	51	1765	2	farmed
farted	10	51	2178	2	farted
furled	10	47	1705	2	furled
gabled	10	55	1845	2	gabled
galled	8	46	2286	2	galled
gaoled	8	48	1450	2	gaoled
garbed	10	48	1566	2	garbed
garbled	11	45	1280	2	garbled
gargled	10	42	1067	2	gargled
garred	8	52	1741	2	garred
gnarled	9	28	772	2	gnarled
hailed	10	41	2274	2	hailed
haled	9	53	3582	2	ha_led
hared	9	57	4218	2	har_ed
harked	14	54	2255	2	harked
harmed	12	52	1883	2	harmed
harped	12	44	1840	2	harped
hauled	10	44	1521	2	hauled
hurled	10	46	1745	2	hurled
jailed	14	49	1742	2	jailed
jarred	14	46	1325	2	jarred
ladled	8	50	1348	2	ladled
lalled	7	42	1875	2	lalled
larded	8	43	1909	2	larded
larked	11	45	1947	2	larked
macled	11	67	1811	2	macled
mailed	9	53	2675	2	mailed
malled	9	46	2611	2	malled
marbled	12	32	1211	2	marbled
marked	13	39	2162	2	marked
marred	9	54	2104	2	marred
marted	9	44	2521	2	marted
mauled	9	48	1782	2	mauled
nailed	7	40	2149	2	nailed
naled	6	55	2505	2	na_led
narked	11	41	1674	2	narked
nurled	7	40	1623	2	nurled
oared	6	50	3065	2	oar_ed
paced	10	69	3168	2	pa_ced
packed	15	48	2260	2	packed
padded	11	41	1350	2	padded
paddled	12	36	1202	2	paddled
padle	8	45	2234	2	padle_
padles	9	52	2112	2	padles
paged	9	59	2678	2	pa_ged
paiked	13	51	1343	2	paiked
pained	9	56	2285	2	pained
paired	9	50	1752	2	paired
pale	6	60	5501	2	pa_le_
palea	7	50	2866	2	pa_lea
paler	7	54	3693	2	pa_ler
pales	7	57	5380	2	pa_les
palet	7	46	5080	2	pa_let
pallet	8	42	3265	2	pallet
pallid	9	39	1528	2	pallid
palmed	11	43	1464	2	palmed
palped	11	45	1364	2	palped
paned	8	54	3718	2	pa_ned
paneled	10	6	1257	2	paneled
panged	10	47	2233	2	panged
panned	9	41	2343	2	panned
panted	9	50	2482	2	panted
parade	9	47	2064	2	parade
paraded	11	40	1426	2	paraded
parae	7	63	3570	2	parae_
parcel	10	39	1547	2	parcel
parceled	13	3	834	2	parceled
parched	15	40	1369	2	parched
pard	7	64	4132	2	par__d
pardee	9	39	2202	2	pardee
pare	6	67	6084	2	par_e_
pareo	7	46	3260	2	par_eo
parer	7	58	3990	2	par_er
pares	7	71	6448	2	par_es
pareu	7	49	2874	2	par_eu
parge	8	58	3185	2	parge_
parges	9	45	2954	2	parges
parget	9	45	2939	2	parget
paries	8	47	4251	2	paries
parker	12	41	2137	2	parker
parlay	11	37	1399	2	parlay
parlayed	14	3	582	2	parlayed
parleyed	14	3	624	2	parleyed
parleys	12	52	1237	2	parleys
parlor	8	3	1267	2	parlor
parole	8	44	2525	2	parole_
parolee	9	41	1964	2	parolee
paroles	9	50	2588	2	paroles
parrel	8	45	1598	2	parrel
parried	10	36	1572	2	parried
parse	7	52	3699	2	parse_
parsec	10	59	1448	2	parsec
parser	8	48	2237	2	parser
parses	8	55	3470	2	parses
parsley	12	4	780	2	parsley
parslied	11	3	782	2	parslied
partied	10	35	1655	2	partied
partlet	9	27	2036	2	partlet
parve	10	98	2485	2	parve_
pashed	12	59	2314	2	pashed
passed	9	43	2094	2	passed
pasted	9	44	2690	2	pasted
pated	8	52	3784	2	pa_ted
patted	9	47	2468	2	patted
paused	9	51	1496	2	paused
paved	11	55	2526	2	pa_ved
paveed	12	43	889	2	paveed
pawed	11	57	2561	2	pa_wed
pawned	12	45	1328	2	pawned
payed	11	59	2593	2	pa_yed
pealed	9	53	2281	2	pealed
pearler	9	3	1037	2	pearler
peeled	9	41	1971	2	peeled
periled	10	3	1632	2	periled
perked	13	46	1769	2	perked
permed	11	52	1735	2	permed
piled	8	52	3299	2	p_iled
pilled	9	42	2275	2	pilled
pled	7	52	3143	2	p__led
poled	8	49	3484	2	p_oled
polled	9	40	2200	2	polled
pooled	9	46	1981	2	pooled
pored	8	52	3451	2	por_ed
porked	13	47	1762	2	porked
ported	9	42	2324	2	ported
prated	9	49	2492	2	prated
prayed	12	48	1543	2	prayed
preed	8	51	2812	2	p_reed
pried	8	44	2686	2	p_ried
puled	8	49	2652	2	p_uled
pulled	9	43	2219	2	pulled
pureed	9	50	1781	2	pureed
purfled	13	24	873	2	purfled
purged	10	49	1826	2	purged
purpled	12	29	978	2	purpled
purred	9	42	1807	2	purred
pursed	9	52	2088	2	pursed
railed	7	47	2754	2	railed
rared	6	57	3832	2	rar_ed
sailed	7	43	2776	2	sailed
snarled	8	36	1236	2	snarled
spalled	10	31	1313	2	spalled
spared	9	54	2749	2	spar_ed
sparged	11	35	1276	2	sparged
sparked	14	35	1314	2	sparked
sparkled	15	31	773	2	sparkled
sparred	10	45	1286	2	sparred
tabled	9	40	2004	2	tabled
tailed	7	44	2466	2	tailed
tared	6	93	4005	2	tar_ed
tarred	7	47	2028	2	tarred
tarted	7	49	2337	2	tarted
tirled	7	47	1436	2	tirled
vailed	10	46	1929	2	vailed
varied	10	48	1786	2	varied
varlet	9	4	2350	2	varlet
varved	13	41	1060	2	varved
wailed	10	48	2359	2	wailed
waled	9	43	3099	2	wa_led
walled	10	40	2129	2	walled
warbled	13	32	1216	2	warbled
warded	11	50	2104	2	warded
wared	9	63	3987	2	war_ed
warked	14	44	2121	2	warked
warmed	12	45	1689	2	warmed
warned	10	40	1891	2	warned
warped	12	48	1641	2	warped
warred	10	40	1984	2	warred
warsled	11	29	1044	2	warsled
warted	10	42	2323	2	warted
wauled	10	47	1396	2	wauled
wawled	13	38	1170	2	wawled
yarded	11	47	1402	2	yarded
yarned	10	55	1402	2	yarned
yawled	13	45	998	2	yawled

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	82551	0.343	520965.0
2	DLD Change Limit	82551	245	2.453	33653.1
3	Display Results	245	245	0.076	3223.7
	(SQL Overall)	178691	245	2.872	62218.3