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

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

303 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
maid	7	55	3766	(None)
aid	4	92	6908	1	_aid
amid	7	70	3635	1	amid
caid	7	78	3753	1	caid
laid	5	64	3914	1	laid
mad	6	89	5871	1	ma_d
maids	8	63	2714	1	maids
mail	6	55	4345	1	mail
maim	8	58	3149	1	maim
main	6	53	4552	1	main
mair	6	61	3378	1	mair
maud	7	53	2540	1	maud
mid	6	73	5447	1	m_id
paid	7	57	3748	1	paid
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	4500	2	_aide
aids	5	78	4636	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
amain	7	49	2291	2	amain
ami	5	66	4681	2	ami_
amia	6	68	3690	2	amia
amide	8	61	2848	2	amide
amido	8	57	2098	2	amido
amids	8	56	2751	2	amids
amie	6	63	3985	2	amie
amin	6	60	4225	2	amin
amir	6	51	2975	2	amir
amis	6	64	4532	2	amis
and	4	72	4417	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	4091	2	band
bard	7	56	4886	2	bard
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bid	6	77	5181	2	_bid
braid	8	58	2226	2	braid
cad	6	74	5636	2	ca_d
cadi	7	57	3218	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
dad	5	84	5616	2	da_d
dais	5	70	4070	2	dais
did	5	68	5052	2	_did
email	7	47	1510	2	email
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	4769	2	_fid
gad	5	75	5665	2	ga_d
gadi	6	63	2972	2	gadi
gadid	8	55	1738	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	4727	2	_gid
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	2498	2	halid
hand	8	68	3371	2	hand
hard	8	54	4350	2	hard
hid	7	62	4838	2	_hid
id	3	89	4184	2	__id
imid	7	61	2229	2	imid
irid	5	59	2717	2	irid
jail	11	55	2909	2	jail
kadi	9	62	2483	2	kadi
kaif	11	69	3393	2	kaif
kail	8	51	3149	2	kail
kain	8	53	3429	2	kain
kid	8	65	4062	2	_kid
lad	4	81	6570	2	la_d
laic	6	59	3156	2	laic
lain	4	61	4628	2	lain
lair	4	59	3415	2	lair
laird	6	54	1779	2	laird
land	5	63	3731	2	land
lard	5	67	4200	2	lard
laud	5	65	2772	2	laud
lid	4	74	5352	2	_lid
loid	5	55	3149	2	loid
ma	4	100	6066	2	ma__
maar	6	60	2506	2	maar
mabe	8	57	3336	2	mabe
mac	7	80	5393	2	ma_c
mace	8	73	4579	2	mace
maced	10	85	2869	2	maced
mach	11	61	3448	2	mach
mack	12	57	3365	2	mack
macs	8	67	4251	2	macs
made	7	54	4024	2	made
mads	7	68	4537	2	mads
mae	5	76	5911	2	ma_e
maes	6	69	4840	2	maes
mafia	10	44	1803	2	mafia
mafic	12	56	1546	2	mafic
mag	6	79	5648	2	ma_g
mage	7	57	3913	2	mage
magi	7	63	2953	2	magi
magic	10	58	1866	2	magic
mags	7	54	4453	2	mags
maiden	9	35	1228	2	maiden
maile	7	52	3222	2	maile
mailed	9	53	2675	2	mailed
maill	7	44	2079	2	maill
mails	7	60	3778	2	mails
maimed	11	48	1266	2	maimed
maims	9	63	2179	2	maims
mains	7	56	3511	2	mains
mairs	7	62	2830	2	mairs
maist	7	55	3568	2	maist
maize	16	46	1856	2	maize
make	10	55	3789	2	make
mako	10	56	2236	2	mako
male	6	60	5230	2	male
malic	9	45	2566	2	malic
mall	6	46	3937	2	mall
malm	8	51	2998	2	malm
malt	6	62	5481	2	malt
mama	8	62	3159	2	mama
mamie	9	58	2600	2	mamie
man	5	74	6587	2	ma_n
mana	6	53	4196	2	mana
mane	6	50	5203	2	mane
maned	8	66	3410	2	maned
mania	7	56	3415	2	mania
manic	9	46	2944	2	manic
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
mantid	9	38	2038	2	mantid
many	9	57	3186	2	many
map	7	72	5512	2	ma_p
maps	8	61	4105	2	maps
mar	5	79	6595	2	ma_r
mara	6	74	4457	2	mara
marc	8	70	3463	2	marc
mare	6	47	5933	2	mare
maria	7	50	3288	2	maria
mark	10	51	3806	2	mark
marl	6	63	4162	2	marl
mars	6	62	6187	2	mars
mart	6	68	6598	2	mart
mas	5	81	7582	2	ma_s
masa	6	50	3472	2	masa
mash	9	60	3940	2	mash
masjid	16	18	732	2	masjid
mask	10	52	2736	2	mask
mass	6	60	4494	2	mass
mast	6	59	5996	2	mast
mat	5	80	8394	2	ma_t
mate	6	51	5422	2	mate
mated	8	55	3778	2	mated
math	9	54	3745	2	math
matin	7	51	3285	2	matin
mats	6	54	6029	2	mats
matt	6	57	5266	2	matt
mauds	8	55	1927	2	mauds
maul	6	48	3072	2	maul
maun	6	57	2721	2	maun
maund	8	55	1545	2	maund
maut	6	54	4845	2	maut
mavie	10	47	2256	2	mavie
mavin	10	57	2295	2	mavin
mavis	10	56	2272	2	mavis
maw	8	70	5010	2	ma_w
mawed	11	58	2474	2	mawed
mawn	9	44	2414	2	mawn
maws	9	64	3714	2	maws
max	12	90	4545	2	ma_x
maxed	15	58	2119	2	maxed
maxi	13	70	2356	2	maxi
maxim	16	52	1600	2	maxim
maxis	14	57	2156	2	maxis
may	8	87	5763	2	ma_y
maya	9	58	2459	2	maya
mayed	11	55	2240	2	mayed
mayo	9	65	2430	2	mayo
mays	9	69	4003	2	mays
maze	15	54	3498	2	maze
mazed	17	55	2387	2	mazed
mazy	18	64	1970	2	mazy
mead	7	55	3160	2	mead
med	6	61	4674	2	m_ed
meed	7	49	3470	2	meed
meld	7	58	3047	2	meld
mend	7	53	3403	2	mend
mi	4	82	4905	2	m_i_
mib	7	69	4612	2	m_ib
mic	7	76	4764	2	m_ic
midi	7	56	2848	2	m_idi
mids	7	65	4179	2	m_ids
mig	6	56	4608	2	m_ig
mil	5	57	5211	2	m_il
mild	7	53	3085	2	mild
mim	7	60	4842	2	m_im
mind	7	54	3438	2	mind
mir	5	70	4677	2	m_ir
mis	5	81	6262	2	m_is
mix	12	61	3818	2	m_ix
mod	6	90	5440	2	m_od
modi	7	68	2631	2	modi
moil	6	55	3409	2	moil
mold	7	60	3433	2	mold
mood	7	63	3206	2	mood
mucid	10	41	1525	2	mucid
mud	6	73	3686	2	m_ud
murid	8	45	2058	2	murid
myoid	11	5	1299	2	myoid
mysid	11	6	1069	2	mysid
naiad	6	3	1340	2	naiad
naif	7	68	3902	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
plaid	8	51	1830	2	plaid
qadi	14	56	2110	2	qadi
qaids	15	61	1631	2	qaids
quid	14	49	2235	2	quid
rabid	8	45	2078	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	3957	2	rand
ranid	6	64	2933	2	ranid
rapid	8	64	2203	2	rapid
rid	4	67	5463	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	3847	2	sand
sapid	8	47	2093	2	sapid
sard	5	53	4424	2	sard
sayid	9	55	1672	2	sayid
skid	9	57	2093	2	skid
slid	5	58	2898	2	slid
staid	6	67	2208	2	staid
tabid	8	44	1826	2	tabid
tad	4	79	5982	2	ta_d
tail	4	54	4365	2	tail
tain	4	55	4807	2	tain
vail	7	54	3255	2	vail
vain	7	52	3300	2	vain
vair	7	56	2414	2	vair
valid	9	46	1839	2	valid
vapid	11	56	1428	2	vapid
vid	7	72	4181	2	_vid
void	8	62	2056	2	void
wad	7	70	5389	2	wa_d
wadi	8	62	2817	2	wadi
waif	10	58	3675	2	waif
wail	7	52	3882	2	wail
wain	7	58	4020	2	wain
wair	7	58	3005	2	wair
wait	7	55	5369	2	wait
wand	8	58	3388	2	wand
ward	8	65	4225	2	ward
whid	11	54	1887	2	whid
yaird	9	61	1191	2	yaird
yald	8	69	2061	2	yald
yard	8	56	3325	2	yard
yaud	8	70	2008	2	yaud
yid	7	66	4083	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.263	679433.5
2	DLD Change Limit	29872	303	0.843	35435.3
3	Display Results	303	303	0.063	4809.5
	(SQL Overall)	178691	303	1.169	152858.0