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

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

299 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
caid	7	78	3754	(None)
acid	7	75	3340	1	acid
aid	4	92	6909	1	_aid
cad	6	74	5637	1	ca_d
cadi	7	57	3219	1	cadi
caids	8	52	2643	1	caids
cain	6	56	4391	1	cain
caird	8	57	1723	1	caird
canid	8	55	2634	1	canid
card	7	102	4587	1	card
chid	10	66	2641	1	chid
laid	5	64	3915	1	laid
maid	7	55	3767	1	maid
paid	7	57	3749	1	paid
qaid	14	60	2385	1	qaid
raid	5	52	4308	1	raid
said	5	57	4212	1	said
acarid	9	50	1707	2	acarid
aced	7	95	4088	2	aced
acids	8	71	2101	2	acids
acidy	11	72	1490	2	acidy
acrid	8	69	2010	2	acrid
ad	3	119	7504	2	_a_d
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
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	ba_d
bail	6	50	4280	2	bail
bait	6	65	5600	2	bait
bald	7	64	3290	2	bald
band	7	67	4092	2	band
bard	7	56	4886	2	bard
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bid	6	77	5182	2	_bid
braid	8	58	2226	2	braid
cab	7	83	5540	2	ca_b
cabin	9	48	2094	2	cabin
cabs	8	67	3942	2	cabs
caca	8	55	2808	2	caca
caddy	12	54	1402	2	caddy
cade	7	64	4392	2	cade
cadis	8	44	2850	2	cadis
cads	7	61	4453	2	cads
cafe	9	52	3032	2	cafe
caff	12	56	3167	2	caff
cage	7	53	3906	2	cage
caged	9	54	2636	2	caged
cagy	10	63	2199	2	cagy
cains	7	53	3430	2	cains
cairds	9	64	1151	2	cairds
cairn	7	57	1751	2	cairn
cake	10	54	3996	2	cake
caked	12	61	2862	2	caked
caky	13	62	2244	2	caky
calf	9	63	3956	2	calf
calif	10	49	2910	2	calif
calix	14	53	1735	2	calix
calk	10	55	2766	2	calk
call	6	68	3867	2	call
calm	8	50	3236	2	calm
calo	6	49	3644	2	calo
calx	13	57	2279	2	calx
cam	7	80	5898	2	ca_m
came	8	76	4875	2	came
camo	8	57	3175	2	camo
camp	10	63	3645	2	camp
cams	8	70	4728	2	cams
can	5	77	6014	2	ca_n
candid	10	45	1785	2	candid
candy	11	51	1982	2	candy
cane	6	66	5312	2	cane
caned	8	58	3809	2	caned
canids	9	51	1813	2	canids
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
cap	7	67	5898	2	ca_p
cape	8	72	4278	2	cape
caped	10	49	3180	2	caped
caph	11	66	2329	2	caph
capiz	18	5	1456	2	capiz
capo	8	58	2921	2	capo
caps	8	71	4789	2	caps
capsid	11	3	1242	2	capsid
car	5	91	6556	2	ca_r
carb	8	51	4316	2	carb
cards	8	51	3793	2	cards
care	6	69	6837	2	care
cared	8	60	5009	2	cared
caried	9	45	2869	2	caried
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carn	6	62	4543	2	carn
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
casa	6	56	3086	2	casa
case	6	58	4808	2	case
cased	8	60	3241	2	cased
cash	9	66	3628	2	cash
cask	10	56	2643	2	cask
cast	6	71	5990	2	cast
cat	5	82	8234	2	ca_t
cate	6	62	5460	2	cate
cats	6	63	5634	2	cats
caul	6	56	3000	2	caul
cauld	8	53	1844	2	cauld
cave	9	59	4126	2	cave
caved	11	62	2756	2	caved
cavie	10	46	2159	2	cavie
cavil	10	38	1649	2	cavil
cavy	12	59	2000	2	cavy
caw	8	66	4793	2	ca_w
cawed	11	66	2706	2	cawed
caws	9	60	3611	2	caws
cay	8	71	5598	2	ca_y
cays	9	54	3767	2	cays
cebid	10	43	1408	2	cebid
cedi	7	49	1928	2	cedi
ceil	6	57	2506	2	ceil
chad	10	55	2550	2	chad
chai	9	59	2990	2	chai_
chain	10	57	2367	2	chain
chair	10	55	1963	2	chair
chais	10	75	3031	2	chais
chard	11	61	2474	2	chard
chi	8	62	2865	2	chi_
chia	9	60	2662	2	chia
chic	11	59	2520	2	chic
chide	11	53	2102	2	chide
child	11	45	1622	2	child
chin	9	69	3474	2	chin
chip	11	67	2642	2	chip
chis	9	59	3331	2	chis
chit	9	69	3746	2	chit
ciao	6	49	2419	2	ciao
cig	6	70	3619	2	c_ig
cis	5	77	4804	2	c_is
clad	7	62	2582	2	clad
claim	9	56	1691	2	claim
clip	8	69	2400	2	clip
clod	7	61	2461	2	clod
cnida	8	7	896	2	cnida
cod	6	96	6013	2	c_od
coed	7	71	4054	2	coed
coif	9	63	3791	2	coif
coil	6	64	3965	2	coil
coin	6	66	4535	2	coin
coir	6	63	2724	2	coir
cold	7	73	3877	2	cold
cord	7	67	4092	2	cord
cred	7	65	3088	2	cred
crib	8	63	2358	2	crib
cried	8	46	2429	2	cried
cris	6	62	3343	2	cris
crit	6	57	4371	2	crit
crud	7	52	1961	2	crud
cud	6	79	3746	2	c_ud
cued	7	63	2956	2	cued
cuif	9	65	2914	2	cuif
cupid	10	32	1278	2	cupid
curd	7	76	3498	2	curd
cyanid	12	39	1204	2	cyanid
dad	5	84	5617	2	da_d
dais	5	70	4070	2	dais
did	5	68	5053	2	_did
fad	7	74	5242	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	4770	2	_fid
gad	5	75	5666	2	ga_d
gadi	6	63	2973	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	4728	2	_gid
grid	6	58	2962	2	grid
guid	6	60	2283	2	guid
had	7	76	5877	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	4839	2	_hid
id	3	89	4185	2	__id
imid	7	61	2230	2	imid
irid	5	59	2718	2	irid
jail	11	55	2909	2	jail
kadi	9	62	2484	2	kadi
kaif	11	69	3394	2	kaif
kail	8	51	3150	2	kail
kain	8	53	3430	2	kain
kid	8	65	4063	2	_kid
lad	4	81	6571	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	5353	2	_lid
loid	5	55	3150	2	loid
mad	6	89	5872	2	ma_d
maids	8	63	2715	2	maids
mail	6	55	4345	2	mail
maim	8	58	3149	2	maim
main	6	53	4552	2	main
mair	6	61	3378	2	mair
maud	7	53	2540	2	maud
mid	6	73	5448	2	_mid
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	1549	2	oxid
pad	6	80	5733	2	pa_d
padi	7	63	3179	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	2111	2	qadi
qaids	15	61	1632	2	qaids
quid	14	49	2236	2	quid
rabid	8	45	2078	2	rabid
rad	4	76	6201	2	ra_d
rai	3	76	5822	2	rai_
raia	4	66	3838	2	raia
raids	6	58	2752	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	5464	2	_rid
sad	4	74	5921	2	sa_d
sadi	5	58	3465	2	sadi
saids	6	53	2886	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
scad	7	57	2577	2	sca_d
scald	8	48	1812	2	scald
skid	9	57	2094	2	skid
slid	5	58	2899	2	slid
staid	6	67	2208	2	staid
tabid	8	44	1826	2	tabid
tad	4	79	5983	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	4182	2	_vid
void	8	62	2057	2	void
wad	7	70	5390	2	wa_d
wadi	8	62	2818	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	1888	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	4084	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.296	603685.8
2	DLD Change Limit	29872	299	0.890	33564.0
3	Display Results	299	299	0.076	3934.2
	(SQL Overall)	178691	299	1.262	141593.5