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

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

343 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
said	5	57	4211	(None)
aid	4	92	6908	1	_aid
caid	7	78	3753	1	caid
laid	5	64	3914	1	laid
maid	7	55	3766	1	maid
paid	7	57	3748	1	paid
qaid	14	60	2384	1	qaid
raid	5	52	4307	1	raid
sad	4	74	5920	1	sa_d
sadi	5	58	3464	1	sadi
saids	6	53	2885	1	saids
sail	4	54	4716	1	sail
sain	4	55	5129	1	sain
sand	5	53	3847	1	sand
sapid	8	47	2093	1	sapid
sard	5	53	4424	1	sard
sayid	9	55	1672	1	sayid
skid	9	57	2093	1	skid
slid	5	58	2898	1	slid
staid	6	67	2208	1	staid
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
amid	7	70	3635	2	amid
and	4	72	4417	2	_and
arid	5	76	4271	2	arid
aside	6	51	2208	2	aside
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
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
mad	6	89	5871	2	ma_d
maids	8	63	2714	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	5447	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	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
resaid	7	45	1708	2	resaid
rid	4	67	5463	2	_rid
sab	5	65	6320	2	sa_b
sabe	6	61	4057	2	sabe
sabed	8	65	2681	2	sabed
sabin	7	49	2495	2	sabin
sabir	7	59	1700	2	sabir
sabs	6	66	4374	2	sabs
sac	5	74	5286	2	sa_c
sack	10	53	3731	2	sack
sacs	6	57	3907	2	sacs
sade	5	55	4447	2	sade
sadis	6	49	3085	2	sadis
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sag	4	61	6340	2	sa_g
saga	5	53	3117	2	saga
sage	5	50	4459	2	sage
sago	5	63	3267	2	sago
sags	5	59	4840	2	sags
sagy	8	53	2708	2	sagy
sahib	10	3	1476	2	sahib
saice	7	54	2405	2	saice
saiga	6	47	1793	2	saiga
sailed	7	43	2776	2	sailed
sails	5	57	3810	2	sails
sained	7	54	2424	2	sained
sains	5	56	3997	2	sains
saint	5	51	4707	2	saint
saith	8	58	2655	2	saith
saiyid	10	16	741	2	saiyid
sake	8	52	4496	2	sake
saki	8	56	2848	2	saki
sakis	9	53	2367	2	sakis
sal	3	64	6288	2	sa_l
salad	6	53	2183	2	salad
sale	4	49	5970	2	sale
salic	7	34	2471	2	salic
sall	4	45	4468	2	sall
salp	6	45	3409	2	salp
salpid	9	5	1088	2	salpid
sals	4	68	5167	2	sals
salt	4	57	5852	2	salt
same	6	52	4564	2	same
samp	8	57	3359	2	samp
sands	6	52	2858	2	sands
sandy	9	42	2113	2	sandy
sane	4	59	5434	2	sane
saned	6	56	3627	2	saned
sang	5	54	4123	2	sang
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
sap	5	64	6323	2	sa_p
saps	6	53	4637	2	saps
sards	6	47	3618	2	sards
sari	4	54	4404	2	sari
sarin	5	52	3925	2	sarin
saris	5	45	4495	2	saris
sark	8	49	3897	2	sark
sarod	6	53	2587	2	sarod
sash	7	72	3530	2	sash
sasin	5	46	2657	2	sasin
sass	4	50	3562	2	sass
sat	3	62	8848	2	sa_t
sate	4	55	5610	2	sate
sated	6	62	3853	2	sated
sati	4	55	3933	2	sati
satin	5	59	3522	2	satin
satis	5	56	3368	2	satis
sau	3	63	5657	2	sa_u
saul	4	58	3652	2	saul
save	7	57	4136	2	save
saved	9	51	2711	2	saved
savin	8	46	2508	2	savin
saw	6	82	5535	2	sa_w
sawed	9	56	2840	2	sawed
sawn	7	54	2816	2	sawn
saws	7	58	3948	2	saws
sax	10	74	4764	2	sa_x
say	6	72	6476	2	sa_y
sayed	9	61	2714	2	sayed
sayids	10	43	1097	2	sayids
says	7	59	4210	2	says
sayyid	13	18	535	2	sayyid
scad	7	57	2577	2	scad
scald	8	48	1812	2	scald
scud	7	62	2128	2	scud
seed	5	55	4948	2	seed
sei	3	60	4893	2	sei_
seif	7	56	3873	2	seif
seis	4	55	4239	2	seis
send	5	52	3729	2	send
shad	8	62	3091	2	shad
shaird	10	28	870	2	shaird
shard	9	61	2596	2	shard
shed	8	65	3615	2	shed
shied	9	61	2549	2	shied
shim	9	58	2786	2	shim
shin	7	56	3431	2	shin
ship	9	52	2824	2	ship
shit	7	67	4594	2	shit
shiv	10	57	2117	2	shiv
shod	8	62	2506	2	shod
si	2	91	4957	2	s_i_
sial	4	59	3883	2	sial
sialid	7	3	1494	2	sialid
sib	5	68	5031	2	s_ib
sic	5	58	4787	2	s_ic
side	5	54	4449	2	s_ide
sidh	8	62	2299	2	s_idh
sild	5	50	3058	2	sild
sim	5	65	5314	2	s_im
sin	3	62	6589	2	s_in
sip	5	76	5601	2	s_ip
sir	3	57	4667	2	s_ir
sis	3	73	6054	2	s_is
sit	3	58	7775	2	s_it
six	10	53	3974	2	s_ix
skald	10	42	1017	2	skald
ski	7	49	2569	2	ski_
skids	10	46	1533	2	skids
skied	10	44	1775	2	skied
skim	10	53	2251	2	skim
skin	8	59	2753	2	skin
skip	10	54	2175	2	skip
skis	8	48	2529	2	skis
skit	8	54	3753	2	skit
slain	5	49	2357	2	slain
sled	5	53	3437	2	sled
slide	6	47	2541	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
smit	6	51	3841	2	smit
snail	5	70	2020	2	snail
sned	5	60	2605	2	sned
snib	6	65	2298	2	snib
snide	6	43	1872	2	snide
snip	6	64	2465	2	snip
snit	4	63	4247	2	snit
sod	4	60	5370	2	s_od
soil	4	61	3883	2	soil
sold	5	48	3741	2	sold
solid	6	50	2508	2	solid
sord	5	62	3720	2	sord
spaed	8	55	2227	2	spaed
spail	7	49	2155	2	spail
spait	7	56	3160	2	spait
sparid	9	40	1693	2	sparid
sped	7	60	3149	2	sped
spic	8	52	2743	2	spic
spied	8	54	2771	2	spied
spik	10	54	1971	2	spik
spin	6	62	3130	2	spin
spit	6	55	4508	2	spit
spiv	9	59	1779	2	spiv
spud	7	58	1849	2	spud
squid	15	42	1190	2	squid
sri	3	56	3400	2	sri_
sris	4	54	3415	2	sris
staig	6	55	1964	2	staig
stain	5	57	2794	2	stain
stair	5	47	1994	2	stair
stand	6	59	2328	2	stand
stied	6	57	2303	2	stied
stir	4	57	2325	2	stir
stud	5	62	2009	2	stud
sudd	6	47	1977	2	sudd
sued	5	65	3793	2	sued
suit	4	56	4987	2	suit
surd	5	64	3381	2	surd
swail	8	62	1716	2	swail
swain	8	49	1905	2	swain
sward	9	42	2146	2	sward
swig	8	58	1802	2	swig
swim	9	62	2140	2	swim
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
tsadi	6	37	991	2	tsadi
unsaid	7	4	1183	2	unsaid
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.280	638182.1
2	DLD Change Limit	29872	343	0.860	34734.9
3	Display Results	343	343	0.076	4513.2
	(SQL Overall)	178691	343	1.216	146949.8