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

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

305 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
laid	5	64	3914	(None)
aid	4	92	6907	1	_aid
caid	7	78	3753	1	caid
lad	4	81	6570	1	la_d
laic	6	59	3156	1	laic
lain	4	61	4628	1	lain
lair	4	59	3415	1	lair
laird	6	54	1779	1	laird
land	5	63	3730	1	land
lard	5	67	4200	1	lard
laud	5	65	2772	1	laud
lid	4	74	5351	1	l_id
loid	5	55	3148	1	loid
maid	7	55	3763	1	maid
paid	7	57	3748	1	paid
plaid	8	51	1830	1	plaid
qaid	14	60	2384	1	qaid
raid	5	52	4307	1	raid
said	5	57	4211	1	said
acid	7	75	3339	2	acid
ad	3	119	7503	2	_a_d
add	5	101	3236	2	_add
ai	2	112	8839	2	_ai_
aide	5	60	4499	2	_aide
aids	5	78	4635	2	_aids
ail	3	71	7104	2	_ail
aim	5	78	5821	2	_aim
ain	3	75	7909	2	_ain
air	3	80	5839	2	_air
ais	3	90	8357	2	_ais
ait	3	80	9390	2	_ait
aland	6	55	2641	2	aland
alcid	8	58	1796	2	alcid
algid	7	54	1557	2	algid
alif	7	62	4213	2	alif
alit	4	61	5569	2	alit
amid	7	70	3633	2	amid
and	4	72	4416	2	_and
arid	5	76	4271	2	arid
avid	8	83	2596	2	avid
bad	6	77	6315	2	ba_d
bail	6	50	4280	2	bail
bait	6	65	5600	2	bait
bald	7	64	3290	2	bald
band	7	67	4090	2	band
bard	7	56	4886	2	bard
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bid	6	77	5178	2	_bid
blain	7	54	2179	2	blain
bland	8	53	2045	2	bland
braid	8	58	2226	2	braid
cad	6	74	5636	2	ca_d
cadi	7	57	3217	2	cadi
caids	8	52	2642	2	caids
cain	6	56	4391	2	cain
caird	8	57	1723	2	caird
canid	8	55	2634	2	canid
card	7	102	4587	2	card
chid	10	66	2640	2	chid
clad	7	62	2582	2	cla_d
claim	9	56	1691	2	claim
dad	5	84	5616	2	da_d
dais	5	70	4070	2	dais
did	5	68	5051	2	_did
elain	5	53	2470	2	elain
eland	6	58	2039	2	eland
elapid	9	3	954	2	elapid
fad	7	74	5241	2	fa_d
fail	7	48	4024	2	fail
fain	7	58	4056	2	fain
fair	7	63	3252	2	fair
fard	8	56	3906	2	fard
fid	7	68	4768	2	_fid
flail	8	53	1618	2	flail
flair	8	61	1412	2	flair
fluid	9	40	1396	2	fluid
gad	5	75	5665	2	ga_d
gadi	6	63	2972	2	gadi
gadid	8	55	1737	2	gadid
gaed	6	60	3151	2	gaed
gain	5	60	4216	2	gain
gait	5	61	5019	2	gait
gaud	6	70	2543	2	gaud
gid	5	70	4726	2	_gid
glad	6	56	2401	2	gla_d
glair	6	53	1355	2	glair
gland	7	52	1771	2	gland
grid	6	58	2961	2	grid
guid	6	60	2282	2	guid
had	7	76	5876	2	ha_d
haed	8	63	3858	2	haed
haik	11	55	2698	2	haik
hail	7	48	3906	2	hail
hair	7	63	3014	2	hair
halid	9	44	2497	2	halid
hand	8	68	3370	2	hand
hard	8	54	4350	2	hard
hid	7	62	4836	2	_hid
id	3	89	4183	2	__id
iliad	6	46	1345	2	iliad
imid	7	61	2227	2	imid
inlaid	7	3	1013	2	inlaid
irid	5	59	2716	2	irid
jail	11	55	2909	2	jail
kadi	9	62	2482	2	kadi
kaif	11	69	3392	2	kaif
kail	8	51	3149	2	kail
kain	8	53	3429	2	kain
kid	8	65	4061	2	_kid
la	2	192	6163	2	la__
lab	5	88	6478	2	la_b
labia	7	52	1900	2	labia
labs	6	71	4512	2	labs
lac	5	101	5582	2	la_c
lace	6	68	4847	2	lace
laced	8	71	3264	2	laced
lack	10	58	3768	2	lack
lacs	6	69	4248	2	lacs
lacy	9	58	2963	2	lacy
lade	5	63	4598	2	lade
laded	7	42	3261	2	laded
lads	5	65	4913	2	lads
lady	8	65	2715	2	lady
lag	4	78	6212	2	la_g
lags	5	65	4622	2	lags
laich	10	59	2071	2	laich
laics	7	64	1925	2	laics
laigh	9	55	1592	2	laigh
lairds	7	47	1161	2	lairds
laired	7	52	1681	2	laired
lairs	5	54	2587	2	lairs
laith	8	57	2210	2	laith
laity	8	53	1890	2	laity
lake	8	57	4160	2	lake
laked	10	57	3112	2	laked
lakh	11	49	1995	2	lakh
laky	11	67	2582	2	laky
lall	4	55	3131	2	lall
lam	5	76	6671	2	la_m
lama	6	66	3529	2	lama
lamb	8	68	3214	2	lamb
lame	6	68	4929	2	lame
lamed	8	52	3529	2	lamed
lamia	7	53	2432	2	lamia
lamp	8	62	3382	2	lamp
lams	6	65	5226	2	lams
lands	6	54	2690	2	lands
lane	4	51	5332	2	lane
lang	5	66	3737	2	lang
lank	8	47	3444	2	lank
lap	5	85	6527	2	la_p
lapin	7	52	2292	2	lapin
lapis	7	62	2315	2	lapis
laps	6	68	4887	2	laps
lar	3	79	6753	2	la_r
lards	6	53	3186	2	lards
lardy	9	61	1927	2	lardy
lari	4	58	3915	2	lari
laris	5	47	3746	2	laris
lark	8	57	3386	2	lark
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lase	4	61	4851	2	lase
lased	6	51	3234	2	lased
lash	7	65	3965	2	lash
lass	4	74	4454	2	lass
last	4	62	6032	2	last
lat	3	75	9340	2	la_t
late	4	75	6048	2	late
lated	6	52	4067	2	lated
lath	7	66	4038	2	lath
lati	4	64	3827	2	lati
lats	4	59	6270	2	lats
latu	4	79	3418	2	latu
lauds	6	56	1848	2	lauds
lav	6	68	4734	2	la_v
lava	7	67	2542	2	lava
lave	7	56	4214	2	lave
laved	9	50	2859	2	laved
lavs	7	67	3415	2	lavs
law	6	86	5664	2	la_w
lawed	9	60	2832	2	lawed
lawn	7	59	2563	2	lawn
laws	7	64	4168	2	laws
lax	10	76	5152	2	la_x
lay	6	88	6535	2	la_y
layed	9	51	2738	2	layed
layin	8	47	2033	2	layin
lays	7	60	4325	2	lays
laze	13	62	3505	2	laze
lazed	15	49	2584	2	lazed
lazied	16	46	1065	2	lazied
lazy	16	64	2307	2	lazy
lead	5	60	3885	2	lead
led	4	62	5455	2	l_ed
lei	3	68	4638	2	lei_
leis	4	57	3960	2	leis
lend	5	62	3367	2	lend
leud	5	72	2342	2	leud
lewd	8	57	1659	2	lewd
li	2	99	4875	2	l_i_
liar	4	72	2968	2	liar
liard	6	54	1859	2	liard
lib	5	77	5026	2	l_ib
lido	5	60	2815	2	l_ido
lids	5	63	3645	2	l_ids
lie	3	82	6452	2	l_ie
lied	5	58	3809	2	lied
lin	3	79	6737	2	l_in
lip	5	147	5580	2	l_ip
lipid	8	59	1617	2	lipid
lis	3	71	6227	2	l_is
lit	3	93	7731	2	l_it
livid	9	67	1442	2	livid
load	5	67	3060	2	load
loids	6	62	2070	2	loids
loin	4	68	3872	2	loin
lord	5	50	3208	2	lord
loud	5	52	2804	2	loud
lucid	8	43	1457	2	lucid
lurid	6	46	1897	2	lurid
lyard	9	51	1321	2	lyard
mad	6	89	5870	2	ma_d
maids	8	63	2713	2	maids
mail	6	55	4343	2	mail
maim	8	58	3147	2	maim
main	6	53	4550	2	main
mair	6	61	3376	2	mair
maud	7	53	2539	2	maud
mid	6	73	5445	2	_mid
naiad	6	3	1340	2	naiad
naif	7	68	3901	2	naif
nail	4	58	3865	2	nail
nard	5	66	3445	2	nard
oxid	12	8	1548	2	oxid
pad	6	80	5732	2	pa_d
padi	7	63	3178	2	padi
paik	10	57	2680	2	paik
pail	6	61	4183	2	pail
pain	6	56	4724	2	pain
pair	6	60	3151	2	pair
pard	7	64	4132	2	pard
pavid	11	57	1700	2	pavid
placid	11	40	1254	2	placid
plaids	9	43	1244	2	plaids
plain	7	48	2330	2	plain
plait	7	56	3157	2	plait
qadi	14	56	2110	2	qadi
qaids	15	61	1631	2	qaids
quid	14	49	2235	2	quid
rabid	8	45	2077	2	rabid
rad	4	76	6200	2	ra_d
rai	3	76	5822	2	rai_
raia	4	66	3838	2	raia
raids	6	58	2751	2	raids
rail	4	61	4776	2	rail
rain	4	62	5173	2	rain
rais	4	52	5262	2	rais
rand	5	58	3956	2	rand
ranid	6	64	2933	2	ranid
rapid	8	64	2203	2	rapid
relaid	7	55	1844	2	relaid
rid	4	67	5462	2	_rid
sad	4	74	5920	2	sa_d
sadi	5	58	3464	2	sadi
saids	6	53	2885	2	saids
sail	4	54	4716	2	sail
sain	4	55	5129	2	sain
sand	5	53	3846	2	sand
sapid	8	47	2093	2	sapid
sard	5	53	4424	2	sard
sayid	9	55	1672	2	sayid
skid	9	57	2091	2	skid
slain	5	49	2357	2	slain
slid	5	58	2898	2	slid
sloid	6	46	1969	2	sloid
staid	6	67	2207	2	staid
tabid	8	44	1825	2	tabid
tad	4	79	5982	2	ta_d
tail	4	54	4365	2	tail
tain	4	55	4807	2	tain
unlaid	7	3	1175	2	unlaid
vail	7	54	3255	2	vail
vain	7	52	3300	2	vain
vair	7	56	2414	2	vair
valid	9	46	1838	2	valid
vapid	11	56	1428	2	vapid
vid	7	72	4180	2	_vid
void	8	62	2056	2	void
wad	7	70	5389	2	wa_d
wadi	8	62	2817	2	wadi
waif	10	58	3674	2	waif
wail	7	52	3882	2	wail
wain	7	58	4019	2	wain
wair	7	58	3005	2	wair
wait	7	55	5369	2	wait
wand	8	58	3387	2	wand
ward	8	65	4225	2	ward
whid	11	54	1887	2	whid
yaird	9	61	1191	2	yaird
yald	8	69	2060	2	yald
yard	8	56	3325	2	yard
yaud	8	70	2008	2	yaud
yid	7	66	4082	2	_yid

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	29872	0.063	2836365.1
2	DLD Change Limit	29872	305	1.030	29001.9
3	Display Results	305	305	0.080	3812.5
	(SQL Overall)	178691	305	1.173	152336.7