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

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

445 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
lid	4	74	5353	(None)
aid	4	92	6909	1	aid
bid	6	77	5182	1	bid
did	5	68	5053	1	did
fid	7	68	4770	1	fid
gid	5	70	4728	1	gid
hid	7	62	4839	1	hid
id	3	89	4185	1	_id
kid	8	65	4063	1	kid
lad	4	81	6571	1	lad
laid	5	64	3915	1	laid
led	4	62	5456	1	led
li	2	99	4876	1	li_
lib	5	77	5028	1	lib
lido	5	60	2817	1	lido
lids	5	63	3647	1	lids
lie	3	82	6453	1	lie
lied	5	58	3810	1	lied
lin	3	79	6738	1	lin
lip	5	147	5581	1	lip
lis	3	71	6228	1	lis
lit	3	93	7732	1	lit
loid	5	55	3150	1	loid
mid	6	73	5448	1	mid
rid	4	67	5464	1	rid
slid	5	58	2899	1	slid
vid	7	72	4182	1	vid
yid	7	66	4084	1	yid
acid	7	75	3340	2	acid
ad	3	119	7504	2	_ad
add	5	101	3237	2	add
ai	2	112	8840	2	ai_
aide	5	60	4501	2	aide
aids	5	78	4637	2	aids
ail	3	71	7105	2	ail
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
alcid	8	58	1797	2	alcid
algid	7	54	1558	2	algid
alif	7	62	4214	2	alif
alit	4	61	5569	2	alit
amid	7	70	3636	2	amid
and	4	72	4418	2	and
arid	5	76	4272	2	arid
avid	8	83	2597	2	avid
bad	6	77	6316	2	bad
bed	6	79	5063	2	bed
bi	4	80	4648	2	bi_
bib	7	70	4595	2	bib
bide	7	60	4151	2	bide
bidi	7	82	2660	2	bidi
bids	7	58	3846	2	bids
big	6	73	4573	2	big
bin	5	66	5865	2	bin
bind	7	62	3452	2	bind
bio	5	78	4609	2	bio
bird	7	61	2833	2	bird
bis	5	68	6067	2	bis
bit	5	70	7091	2	bit
biz	14	79	3937	2	biz
bled	7	57	2931	2	bled
blin	6	72	2817	2	blin
blind	8	63	1932	2	blind
blip	8	83	2277	2	blip
bod	6	70	5555	2	bod
bud	6	70	4128	2	bud
cad	6	74	5637	2	cad
caid	7	78	3754	2	caid
chid	10	66	2641	2	chid
cig	6	70	3619	2	cig
cis	5	77	4804	2	cis
clad	7	62	2582	2	clad
clip	8	69	2400	2	clip
clod	7	61	2461	2	clod
cod	6	96	6013	2	cod
cud	6	79	3746	2	cud
dad	5	84	5617	2	dad
dib	6	57	4695	2	dib
dido	6	65	2821	2	dido
didy	9	91	2152	2	didy
die	4	67	5966	2	die
died	6	61	3786	2	died
dif	7	68	4691	2	dif
dig	5	75	4448	2	dig
dim	6	81	4650	2	dim
din	4	64	5947	2	din
dip	6	78	4899	2	dip
dis	4	64	5990	2	dis
dit	4	70	7134	2	dit
dud	5	67	3760	2	dud
ed	3	86	4519	2	_ed
eide	5	58	3225	2	eide
eld	4	67	3380	2	eld
elide	6	49	2265	2	elide
end	4	68	3436	2	end
fad	7	74	5242	2	fad
fed	7	65	4836	2	fed
felid	9	47	1717	2	felid
fib	8	63	4428	2	fib
fido	8	77	2641	2	fido
fids	8	70	3475	2	fids
fie	6	71	5245	2	fie
fig	7	62	4284	2	fig
fil	6	54	4715	2	fil
fin	6	64	5804	2	fin
find	8	75	3261	2	find
fir	6	67	4490	2	fir
fit	6	63	6546	2	fit
fix	13	62	3611	2	fix
fiz	15	62	3877	2	fiz
fled	8	54	2977	2	fled
flic	9	62	2373	2	flic
flied	9	65	1943	2	flied
flip	9	63	2426	2	flip
flir	7	64	2220	2	flir
flit	7	65	3927	2	flit
fluid	9	40	1396	2	fluid
fud	7	63	3516	2	fud
gad	5	75	5666	2	gad
ged	5	70	4454	2	ged
gelid	7	49	1698	2	gelid
gib	6	64	4354	2	gib
gids	6	59	3375	2	gids
gie	4	71	4955	2	gie
gied	6	46	3199	2	gied
gig	5	60	4076	2	gig
gild	6	55	2652	2	gild
gin	4	60	5576	2	gin
gip	6	76	4537	2	gip
gird	6	54	2500	2	gird
git	4	62	6606	2	git
glad	6	56	2401	2	glad
gled	6	56	3114	2	gled
glia	5	64	2315	2	glia
glib	7	94	2144	2	glib
glide	7	45	2160	2	glide
glim	7	60	2635	2	glim
god	5	74	4980	2	god
grid	6	58	2962	2	grid
guid	6	60	2283	2	guid
had	7	76	5877	2	had
halid	9	44	2498	2	halid
hi	5	79	4759	2	hi_
hic	8	65	4057	2	hic
hide	8	51	3465	2	hide
hie	6	76	5271	2	hie
hied	8	54	3405	2	hied
him	8	62	4767	2	him
hin	6	75	5957	2	hin
hind	8	55	2976	2	hind
hip	8	67	5044	2	hip
his	6	63	5951	2	his
hit	6	65	6920	2	hit
hod	7	68	5247	2	hod
ids	4	75	3548	2	_ids
if	5	72	3996	2	_if
ilia	4	60	2682	2	ilia
iliad	6	46	1346	2	iliad
ilk	7	83	2531	2	ilk
ill	3	74	3710	2	ill
imid	7	61	2230	2	imid
in	2	81	5087	2	_in
irid	5	59	2718	2	irid
is	2	70	4822	2	_is
it	2	84	5569	2	_it
jib	12	58	3598	2	jib
jig	11	56	3352	2	jig
jin	10	64	4394	2	jin
ki	6	75	3797	2	ki_
kids	9	60	2965	2	kids
kif	10	59	4120	2	kif
kin	7	63	5398	2	kin
kind	9	61	2857	2	kind
kip	9	70	4215	2	kip
kir	7	65	3569	2	kir
kis	7	80	5149	2	kis
kit	7	85	5989	2	kit
klik	7	44	1266	2	klik
la	2	192	6163	2	l_a
lab	5	88	6478	2	lab
lac	5	101	5582	2	lac
lade	5	63	4599	2	lade
lads	5	65	4914	2	lads
lady	8	65	2716	2	lady
lag	4	78	6212	2	lag
laic	6	59	3156	2	laic
lain	4	61	4628	2	lain
lair	4	59	3415	2	lair
laird	6	54	1779	2	laird
lam	5	76	6671	2	lam
land	5	63	3731	2	land
lap	5	85	6527	2	lap
lar	3	79	6753	2	lar
lard	5	67	4200	2	lard
las	3	72	8147	2	las
lat	3	75	9340	2	lat
laud	5	65	2772	2	laud
lav	6	68	4734	2	lav
law	6	86	5664	2	law
lax	10	76	5152	2	lax
lay	6	88	6535	2	lay
lea	3	76	6018	2	lea
lead	5	60	3885	2	lead
lee	3	60	6814	2	lee
leg	4	64	4611	2	leg
lei	3	68	4638	2	lei
leis	4	57	3960	2	leis
lek	7	56	4030	2	lek
lend	5	62	3367	2	lend
les	3	56	6307	2	les
let	3	64	8147	2	let
leu	3	60	4740	2	leu
leud	5	72	2342	2	leud
lev	6	61	3942	2	lev
lewd	8	57	1659	2	lewd
lex	10	79	4382	2	lex
ley	6	62	4681	2	ley
lez	12	55	4131	2	lez
liar	4	72	2969	2	liar
liard	6	54	1859	2	liard
libs	6	67	3277	2	libs
lice	6	60	4507	2	lice
lich	9	62	3085	2	lich
lick	10	69	3508	2	lick
lidar	6	3	1273	2	lidar
lidos	6	52	1989	2	lidos
lief	7	60	3700	2	lief
lien	4	53	3981	2	lien
lier	4	59	4247	2	lier
lies	4	64	5420	2	lies
lieu	4	65	3437	2	lieu
life	7	54	3374	2	life
lift	7	69	4273	2	lift
like	8	60	4085	2	like
liked	10	45	2381	2	liked
lilo	4	67	3157	2	lilo
lilt	4	63	4995	2	lilt
lily	7	67	3019	2	lily
lima	6	57	3414	2	lima
limb	8	54	2939	2	limb
lime	6	62	4494	2	lime
limed	8	54	2680	2	limed
limn	6	65	2770	2	limn
limo	6	55	2974	2	limo
limp	8	84	3250	2	limp
limy	9	57	2772	2	limy
lindy	9	69	1832	2	lindy
line	4	69	6558	2	line
lined	6	49	3464	2	lined
ling	5	74	4797	2	ling
link	8	69	4345	2	link
linn	4	60	3460	2	linn
lino	4	63	4338	2	lino
lins	4	70	5906	2	lins
lint	4	162	6624	2	lint
liny	7	81	4133	2	liny
lion	4	63	3445	2	lion
lipa	6	84	2593	2	lipa
lipe	6	68	3974	2	lipe
lipid	8	59	1617	2	lipid
lips	6	71	4145	2	lips
lira	4	69	2869	2	lira
lire	4	78	4530	2	lire
liri	4	51	2826	2	liri
lisp	6	89	2689	2	lisp
list	4	70	5535	2	list
lite	4	70	5455	2	lite
lits	4	62	5250	2	lits
litu	4	76	3157	2	litu
live	7	65	4100	2	live
lived	9	55	2372	2	lived
livid	9	67	1442	2	livid
lo	2	80	5344	2	l_o
load	5	67	3060	2	load
lob	5	71	5446	2	lob
lode	5	62	4012	2	lode
log	4	62	5268	2	log
loids	6	62	2071	2	loids
loin	4	68	3872	2	loin
loo	3	83	5982	2	loo
lop	5	82	5531	2	lop
lord	5	50	3208	2	lord
lot	3	81	7926	2	lot
loud	5	52	2804	2	loud
low	6	60	5187	2	low
lox	10	82	4096	2	lox
lucid	8	43	1457	2	lucid
lude	5	53	3165	2	lude
lug	4	61	3806	2	lug
lum	5	55	4293	2	lum
lurid	6	46	1897	2	lurid
luv	6	71	2577	2	luv
lux	10	65	2877	2	lux
lye	6	65	3341	2	lye
mad	6	89	5872	2	mad
maid	7	55	3767	2	maid
med	6	61	4675	2	med
mi	4	82	4906	2	mi_
mib	7	69	4613	2	mib
mic	7	76	4765	2	mic
midi	7	56	2849	2	midi
mids	7	65	4180	2	mids
mig	6	56	4609	2	mig
mil	5	57	5212	2	mil
mild	7	53	3086	2	mild
mim	7	60	4843	2	mim
mind	7	54	3439	2	mind
mir	5	70	4678	2	mir
mis	5	81	6263	2	mis
mix	12	61	3819	2	mix
mod	6	90	5441	2	mod
mud	6	73	3687	2	mud
nib	5	67	4520	2	nib
nide	5	55	3580	2	nide
nidi	5	65	2441	2	nidi
nil	3	61	4420	2	nil
nim	5	71	4296	2	nim
nip	5	69	4599	2	nip
nit	3	70	6595	2	nit
nix	10	69	3284	2	nix
nod	4	75	4957	2	nod
od	3	92	5525	2	_od
odd	5	77	2546	2	odd
oi	2	90	6149	2	oi_
oil	3	74	5206	2	oil
old	4	70	3347	2	old
olio	4	68	2967	2	olio
oud	4	74	3908	2	oud
oxid	12	8	1549	2	oxid
pad	6	80	5733	2	pad
paid	7	57	3749	2	paid
ped	6	67	5153	2	ped
pi	4	81	4537	2	pi_
pia	5	68	4804	2	pia
pic	7	60	4683	2	pic
pie	5	54	5741	2	pie
pied	7	50	3537	2	pied
pig	6	57	4498	2	pig
pin	5	70	6673	2	pin
pip	7	80	5105	2	pip
pis	5	63	6204	2	pis
pit	5	64	7193	2	pit
piu	5	66	3955	2	piu
pix	12	64	3794	2	pix
plaid	8	51	1830	2	plaid
pled	7	52	3143	2	pled
plie	6	51	2739	2	plie
plied	8	51	1859	2	plied
plod	7	67	2327	2	plod
pod	6	63	5149	2	pod
pud	6	58	3666	2	pud
qaid	14	60	2385	2	qaid
qi	11	65	2691	2	qi_
qis	12	69	3439	2	qis
quid	14	49	2236	2	quid
rad	4	76	6201	2	rad
raid	5	52	4308	2	raid
red	4	67	5581	2	red
ria	3	67	4551	2	ria
rib	5	68	4804	2	rib
ride	5	59	4514	2	ride
rids	5	65	3956	2	rids
rif	6	59	5157	2	rif
rig	4	67	4813	2	rig
rim	5	60	5228	2	rim
rin	3	66	6319	2	rin
rind	5	65	3561	2	rind
rip	5	68	5131	2	rip
rod	4	79	5390	2	rod
sad	4	74	5921	2	sad
said	5	57	4212	2	said
si	2	91	4958	2	si_
sib	5	68	5032	2	sib
sic	5	58	4788	2	sic
side	5	54	4450	2	side
sidh	8	62	2300	2	sidh
sild	5	50	3059	2	sild
sim	5	65	5315	2	sim
sin	3	62	6590	2	sin
sip	5	76	5602	2	sip
sir	3	57	4668	2	sir
sis	3	73	6055	2	sis
sit	3	58	7776	2	sit
six	10	53	3975	2	six
skid	9	57	2094	2	skid
sled	5	53	3437	2	sled
slide	6	47	2542	2	slide
slim	6	66	3196	2	slim
slip	6	70	3173	2	slip
slit	4	62	5010	2	slit
sloid	6	46	1971	2	sloid
sod	4	60	5371	2	sod
solid	6	50	2508	2	solid
tad	4	79	5983	2	tad
ted	4	64	4657	2	ted
ti	2	84	4830	2	ti_
tic	5	63	4347	2	tic
tide	5	52	3739	2	tide
tidy	8	68	2243	2	tidy
tie	3	65	5754	2	tie
tied	5	55	3522	2	tied
til	3	63	5027	2	til
tin	3	63	6218	2	tin
tip	5	65	5123	2	tip
tis	3	70	5665	2	tis
tit	3	67	7106	2	tit
tod	4	94	5708	2	tod
urd	4	64	2706	2	urd
valid	9	46	1839	2	valid
via	6	56	3625	2	via
vide	8	54	3277	2	vide
vids	8	56	2755	2	vids
vie	6	54	4764	2	vie
vied	8	63	2864	2	vied
vig	7	56	3753	2	vig
vim	8	74	3703	2	vim
vis	6	67	4762	2	vis
void	8	62	2057	2	void
wad	7	70	5390	2	wad
wed	7	58	4363	2	wed
whid	11	54	1888	2	whid
wide	8	52	3542	2	wide
wig	7	67	4039	2	wig
wild	8	51	2652	2	wild
win	6	64	5630	2	win
wind	8	55	3386	2	wind
wis	6	65	5234	2	wis
wit	6	65	6378	2	wit
wiz	15	64	3416	2	wiz
wud	7	62	2716	2	wud
xi	9	81	2817	2	xi_
xis	10	69	3534	2	xis
yids	8	52	2497	2	yids
yin	6	76	4874	2	yin
yip	8	72	4119	2	yip
yird	8	70	1899	2	yird
yod	7	75	4551	2	yod
zed	13	54	3118	2	zed
zig	13	69	3191	2	zig
zin	12	56	4378	2	zin
zip	14	66	3623	2	zip
zit	12	60	5000	2	zit

Search took 1 second 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.313	570897.8
2	DLD Change Limit	14084	445	0.420	33533.3
3	Display Results	445	445	0.096	4635.4
	(SQL Overall)	178691	445	0.829	215550.1