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

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

377 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
all	3	61	4823	(None)
aal	3	90	5867	1	aal
ail	3	71	7105	1	ail
al	2	106	7404	1	a_l
ala	3	124	6360	1	ala
alb	5	73	4265	1	alb
ale	3	65	7234	1	ale
alls	4	67	4092	1	alls
ally	7	69	3564	1	ally
alp	5	66	4113	1	alp
als	3	66	6302	1	als
alt	3	64	6796	1	alt
awl	6	76	3530	1	awl
ball	6	60	4332	1	ball
call	6	68	3867	1	call
ell	3	67	3568	1	ell
fall	7	55	3531	1	fall
gall	5	63	3599	1	gall
hall	7	57	4116	1	hall
ill	3	74	3710	1	ill
lall	4	55	3131	1	lall
mall	6	46	3937	1	mall
pall	6	50	3934	1	pall
sall	4	45	4468	1	sall
tall	4	72	4021	1	tall
wall	7	62	3610	1	wall
aa	2	191	7995	2	a_a
aah	6	162	5296	2	aah
aals	4	99	4114	2	aals
aas	3	109	7539	2	aas
ab	4	106	7476	2	a_b
aba	5	128	5095	2	aba
able	6	63	4053	2	able
ably	9	97	2513	2	ably
abo	5	90	4596	2	abo
abs	5	93	5607	2	abs
aby	8	102	3806	2	aby
ace	5	96	5683	2	ace
act	5	95	5784	2	act
acyl	9	53	1429	2	acyl
ad	3	119	7504	2	a_d
add	5	101	3237	2	add
ado	4	91	4688	2	ado
ads	4	97	5574	2	ads
adz	13	123	3287	2	adz
ae	2	125	9029	2	a_e
aff	9	55	3761	2	aff
aft	6	68	4901	2	aft
ag	3	110	6746	2	a_g
aga	4	104	4723	2	aga
age	4	71	5433	2	age
agly	8	68	2180	2	agly
ago	4	88	4552	2	ago
ags	4	75	5166	2	ags
ah	5	138	6879	2	a_h
aha	6	112	4664	2	aha
ahi	6	80	4023	2	ahi
ahs	6	86	4482	2	ahs
ahull	8	40	1031	2	ahull
ai	2	112	8840	2	a_i
aid	4	92	6909	2	aid
ails	4	56	5472	2	ails
aim	5	78	5822	2	aim
ain	3	75	7910	2	ain
air	3	80	5840	2	air
ais	3	90	8358	2	ais
ait	3	80	9391	2	ait
alae	4	56	4375	2	alae
alan	4	68	4408	2	alan
alar	4	63	4007	2	alar
alas	4	63	5812	2	alas
alba	6	83	2833	2	alba
albs	6	86	2857	2	albs
aldol	6	12	1233	2	aldol
alec	6	64	3006	2	alec
alee	4	66	5232	2	alee
alef	7	63	4069	2	alef
ales	4	70	6710	2	ales
alfa	7	76	2427	2	alfa
alga	5	79	2760	2	alga
algal	6	65	1822	2	algal
alif	7	62	4214	2	alif
alit	4	61	5569	2	alit
alky	11	59	2034	2	alky
alkyl	12	51	804	2	alkyl
allay	8	56	2039	2	allay
allee	5	49	3212	2	allee
alley	8	57	2167	2	alley
allod	6	44	1838	2	allod
allot	5	49	3387	2	allot
allow	8	54	2066	2	allow
alloy	8	55	1997	2	alloy
allyl	8	53	1054	2	allyl
alma	6	63	3303	2	alma
alme	6	58	3216	2	alme
alms	6	58	3492	2	alms
aloe	4	55	4019	2	aloe
alow	7	53	2859	2	alow
alps	6	55	2924	2	alps
also	4	64	2344	2	also
alto	4	78	3126	2	alto
alts	4	66	3990	2	alts
alula	5	3	1709	2	alula
alum	6	52	2761	2	alum
am	4	118	7556	2	a_m
ama	5	108	5331	2	ama
ami	5	66	4681	2	ami
amp	7	75	4102	2	amp
amu	5	82	3732	2	amu
amyl	9	55	1510	2	amyl
an	2	118	7908	2	a_n
ana	3	95	5983	2	ana
anal	4	80	3752	2	anal
and	4	72	4418	2	and
ane	3	78	6695	2	ane
ani	3	77	5118	2	ani
anil	4	64	3743	2	anil
ant	3	72	7079	2	ant
any	6	84	4049	2	any
ape	5	72	5118	2	ape
apo	5	111	4212	2	apo
app	7	68	2760	2	app
apt	5	73	5254	2	apt
ar	2	113	7938	2	a_r
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
arf	6	74	5337	2	arf
aril	4	58	4302	2	aril
ark	7	70	4496	2	ark
arm	5	84	4963	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
aryl	7	59	2234	2	aryl
as	2	110	8307	2	a_s
ash	6	79	4460	2	ash
ask	7	71	3070	2	ask
asp	5	72	3534	2	asp
ass	3	78	4406	2	ass
at	2	123	9340	2	a_t
ate	3	70	5924	2	ate
atoll	5	79	1392	2	atoll
att	3	54	5465	2	att
auk	7	62	3414	2	auk
auld	5	41	2536	2	auld
ava	6	101	3932	2	ava
ave	6	77	4870	2	ave
avo	6	89	3623	2	avo
aw	5	125	6340	2	a_w
awa	6	119	3967	2	awa
awe	6	77	4662	2	awe
awls	7	59	2609	2	awls
awn	6	80	3591	2	awn
awol	7	56	2067	2	awol
ax	9	110	5778	2	a_x
axal	11	65	2049	2	axal
axe	10	82	3949	2	axe
axel	11	52	2207	2	axel
axil	11	64	2445	2	axil
axle	11	64	2460	2	axle
ay	5	117	7389	2	a_y
aye	6	71	5176	2	aye
ays	6	70	5029	2	ays
azo	12	82	3339	2	azo
baal	6	70	3311	2	baal
bail	6	50	4280	2	bail
bal	5	66	6272	2	bal
bald	7	64	3290	2	bald
bale	6	63	5384	2	bale
balk	10	51	3222	2	balk
balls	7	62	3641	2	balls
bally	10	55	3010	2	bally
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
bawl	9	53	2606	2	bawl
bel	5	71	4846	2	bel
bell	6	62	3718	2	bell
bill	6	72	3995	2	bill
boll	6	56	3475	2	boll
bull	6	56	3487	2	bull
calf	9	63	3956	2	calf
calk	10	55	2766	2	calk
calla	7	48	2707	2	calla
calls	7	56	3473	2	calls
calm	8	50	3236	2	calm
calo	6	49	3644	2	calo
calx	13	57	2279	2	calx
carl	6	51	4478	2	carl
caul	6	56	3000	2	caul
cel	5	60	4055	2	cel
cell	6	50	3172	2	cell
col	5	93	6035	2	col
cull	6	59	2964	2	cull
dahl	8	70	1922	2	dahl
dal	4	75	5495	2	dal
dale	5	56	4398	2	dale
dally	9	53	2474	2	dally
dals	5	71	4512	2	dals
del	4	67	5275	2	del
dell	5	69	3820	2	dell
dill	5	52	3998	2	dill
dol	4	71	5065	2	dol
doll	5	66	3249	2	doll
dull	5	64	3044	2	dull
earl	4	58	3814	2	earl
eel	3	79	4684	2	eel
el	2	67	4529	2	_el
eld	4	67	3380	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ells	4	64	3135	2	ells
elm	5	75	3174	2	elm
els	3	76	4572	2	els
fail	7	48	4024	2	fail
falls	8	57	2765	2	falls
falx	14	71	2078	2	falx
farl	7	63	3855	2	farl
fell	7	68	3307	2	fell
fil	6	54	4715	2	fil
fill	7	55	4020	2	fill
flu	6	65	3021	2	flu
fly	9	71	2495	2	fly
full	7	52	2915	2	full
gal	4	60	5551	2	gal
gala	5	56	3516	2	gala
gale	5	63	4732	2	gale
galls	6	47	2932	2	galls
gally	9	50	2617	2	gally
gals	5	79	4650	2	gals
gaol	5	69	2541	2	gaol
gel	4	56	4243	2	gel
gill	5	63	3619	2	gill
gul	4	58	3279	2	gul
gull	5	48	2845	2	gull
hail	7	48	3906	2	hail
halal	8	56	2359	2	halal
hale	7	60	5283	2	hale
half	10	62	3845	2	half
hallo	8	51	2755	2	hallo
halls	8	56	3378	2	halls
halm	9	58	3497	2	halm
halo	7	64	3732	2	halo
halt	7	60	5630	2	halt
harl	7	57	4000	2	harl
haul	7	55	3045	2	haul
hell	7	56	3789	2	hell
hill	7	64	3950	2	hill
hull	7	54	2878	2	hull
ilk	7	83	2531	2	ilk
ills	4	70	3042	2	ills
illy	7	69	2533	2	illy
jail	11	55	2909	2	jail
jarl	11	58	2813	2	jarl
jell	11	71	2587	2	jell
jill	11	64	3027	2	jill
kail	8	51	3150	2	kail
kale	8	65	3376	2	kale
kill	8	55	3319	2	kill
la	2	192	6163	2	_la
lab	5	88	6478	2	lab
lac	5	101	5582	2	lac
lad	4	81	6571	2	lad
lag	4	78	6212	2	lag
lalls	5	53	2413	2	lalls
lam	5	76	6671	2	lam
lap	5	85	6527	2	lap
lar	3	79	6753	2	lar
las	3	72	8147	2	las
lat	3	75	9340	2	lat
lav	6	68	4734	2	lav
law	6	86	5664	2	law
lax	10	76	5152	2	lax
lay	6	88	6535	2	lay
li	2	99	4876	2	_li
lo	2	80	5344	2	_lo
loll	4	61	2838	2	loll
lull	4	42	2576	2	lull
mail	6	55	4345	2	mail
maill	7	44	2079	2	maill
male	6	60	5230	2	male
malls	7	62	3343	2	malls
malm	8	51	2998	2	malm
malt	6	62	5481	2	malt
marl	6	63	4162	2	marl
maul	6	48	3072	2	maul
mel	5	60	4748	2	mel
mell	6	49	3561	2	mell
mil	5	57	5212	2	mil
mill	6	65	4149	2	mill
mol	5	66	5459	2	mol
moll	6	67	3570	2	moll
mull	6	51	2880	2	mull
nail	4	58	3865	2	nail
nala	4	69	3039	2	nala
nil	3	61	4420	2	nil
nill	4	56	3431	2	nill
null	4	51	2531	2	null
oil	3	74	5206	2	oil
old	4	70	3347	2	old
ole	3	71	5521	2	ole
olla	4	48	2117	2	olla
owl	6	62	2897	2	owl
pail	6	61	4183	2	pail
pal	5	67	6167	2	pal
pale	6	60	5501	2	pale
palls	7	43	3256	2	palls
pally	10	57	2712	2	pally
palm	8	53	3136	2	palm
palp	8	58	2857	2	palp
pals	6	69	5135	2	pals
paly	9	58	3553	2	paly
pawl	9	51	2326	2	pawl
pill	6	53	3947	2	pill
ply	8	63	2355	2	ply
pol	5	64	4938	2	pol
poll	6	63	3213	2	poll
pul	5	61	3806	2	pul
pull	6	47	3166	2	pull
rail	4	61	4776	2	rail
rale	4	50	5056	2	rale
rally	8	47	2590	2	rally
rill	4	51	4091	2	rill
roll	4	63	3165	2	roll
sail	4	54	4716	2	sail
sal	3	64	6288	2	sal
salal	5	54	2570	2	salal
sale	4	49	5970	2	sale
sally	8	51	2971	2	sally
salol	5	52	2214	2	salol
salp	6	45	3409	2	salp
sals	4	68	5167	2	sals
salt	4	57	5852	2	salt
saul	4	58	3652	2	saul
scall	7	44	2037	2	scall
sel	3	82	5332	2	sel
sell	4	58	4061	2	sell
shall	8	50	2405	2	shall
sill	4	55	4516	2	sill
sly	6	62	2856	2	sly
small	7	40	1626	2	small
sol	3	72	5662	2	sol
spall	7	49	1930	2	spall
stall	5	47	2235	2	stall
tael	4	60	3071	2	tael
tail	4	54	4365	2	tail
tala	4	59	3805	2	tala
talc	6	62	2681	2	talc
tale	4	61	5416	2	tale
tali	4	68	3716	2	tali
talk	8	62	3009	2	talk
talls	5	51	3343	2	talls
tally	8	45	2686	2	tally
tel	3	56	4790	2	tel
tell	4	49	3470	2	tell
til	3	63	5027	2	til
till	4	59	4121	2	till
toll	4	55	3526	2	toll
ulu	3	60	2870	2	ulu
vail	7	54	3255	2	vail
vale	7	49	3734	2	vale
vill	7	52	3508	2	vill
wail	7	52	3882	2	wail
wale	7	45	4644	2	wale
walk	11	56	2561	2	walk
walla	8	53	2103	2	walla
walls	8	55	2938	2	walls
wally	11	46	2509	2	wally
waly	10	58	3090	2	waly
waul	7	69	2731	2	waul
wawl	10	53	2194	2	wawl
well	7	58	3204	2	well
will	7	57	3752	2	will
yald	8	69	2061	2	yald
yawl	10	49	1897	2	yawl
yell	7	60	2832	2	yell
yill	7	56	2898	2	yill
zill	13	57	2762	2	zill

Search took 2 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	14084	0.436	409841.7
2	DLD Change Limit	14084	377	1.000	14084.0
3	Display Results	377	377	0.093	4053.8
	(SQL Overall)	178691	377	1.529	116867.9