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

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

111 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
solid	6	50	2508	(None)
slid	5	58	2898	1	s_lid
sloid	6	46	1971	1	sloid
sold	5	48	3741	1	sol_d
soldi	6	57	1720	1	soldi
soled	6	58	3517	1	soled
soli	4	66	3701	1	soli_
solidi	7	38	1315	1	solidi
solids	7	41	1640	1	solids
stolid	7	42	1318	1	stolid
bold	7	54	3281	2	bol_d
bolide	9	5	1556	2	bolide
bovid	11	10	1162	2	bovid
cold	7	73	3877	2	col_d
coled	8	55	4076	2	coled
colic	9	57	2617	2	colic
colin	7	62	3169	2	colin
doled	7	54	3091	2	doled
felid	9	47	1717	2	felid
fold	8	65	2894	2	fol_d
folia	8	36	1893	2	folia
folic	10	53	1932	2	folic
folio	8	38	2088	2	folio
gelid	7	49	1698	2	gelid
gold	6	54	3016	2	gol_d
halid	9	44	2498	2	halid
hold	8	62	3506	2	hol_d
holed	9	56	3413	2	holed
iodid	7	43	1553	2	iodid
lid	4	74	5352	2	__lid
loid	5	55	3149	2	lo_id
mold	7	60	3433	2	mol_d
old	4	70	3346	2	_ol_d
olio	4	68	2967	2	_olio
ootid	6	14	1670	2	ootid
oxid	12	8	1548	2	_oxid
poled	8	49	3484	2	poled
polio	7	57	2255	2	polio
polis	7	47	3116	2	polis
psocid	11	3	725	2	psocid
said	5	57	4211	2	s_aid
salad	6	53	2183	2	salad
salic	7	34	2471	2	salic
salpid	9	5	1088	2	salpid
sapid	8	47	2093	2	sapid
sayid	9	55	1672	2	sayid
scold	8	54	1486	2	scol_d
sialid	7	3	1494	2	sialid
sild	5	50	3058	2	sil_d
skid	9	57	2093	2	s_kid
sled	5	53	3437	2	s_led
slide	6	47	2541	2	s_lide
slim	6	66	3196	2	s_lim
slip	6	70	3173	2	s_lip
slit	4	62	5010	2	s_lit
sloids	7	37	1269	2	sloids
slojd	13	37	884	2	slojd
sloyd	9	40	968	2	sloyd
sod	4	60	5370	2	so__d
sodic	8	49	1749	2	sodic
soil	4	61	3883	2	so_il
soiled	7	38	2247	2	soiled
soils	5	53	2798	2	soils
sol	3	72	5662	2	sol__
sola	4	55	4186	2	sol_a
solan	5	53	2815	2	solan
soland	7	51	1504	2	soland
solar	5	59	2734	2	solar
soldo	6	71	1656	2	soldo
sole	4	60	5367	2	sol_e
solei	5	56	2434	2	solei
soles	5	55	4792	2	soles
solider	8	29	1245	2	solider
solidly	11	3	735	2	solidly
solidus	8	33	811	2	solidus
soling	7	42	2682	2	soling
solion	6	6	1638	2	solion
solo	4	55	3894	2	sol_o
soloed	7	45	1574	2	soloed
solon	5	50	2613	2	solon
solos	5	48	3079	2	solos
sols	4	54	4816	2	sol_s
solum	7	47	1761	2	solum
solus	5	47	2698	2	solus
solve	8	56	1894	2	solve
solved	10	53	1293	2	solved
sonic	7	52	2529	2	sonic
sord	5	62	3720	2	so_rd
sordid	8	34	1116	2	sordid
sored	6	61	4178	2	sored
sori	4	60	3984	2	sori_
souled	7	54	1982	2	souled
sound	6	44	2002	2	sound
sowed	9	49	3386	2	sowed
sozin	14	5	1454	2	sozin
split	7	57	2901	2	split
squid	15	42	1190	2	squid
staid	6	67	2208	2	staid
stoled	7	45	2159	2	stoled
sulfid	10	3	906	2	sulfid
syli	7	43	1898	2	syli_
sylis	8	43	1602	2	sylis
told	5	61	3220	2	tol_d
toled	6	59	3492	2	toled
toluid	7	3	821	2	toluid
unsolid	8	13	837	2	unsolid
valid	9	46	1839	2	valid
void	8	62	2056	2	vo_id
voled	9	53	2372	2	voled
wold	8	54	2907	2	wol_d
zooid	15	3	1210	2	zooid

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	53800	0.310	576422.6
2	DLD Change Limit	53800	111	1.440	37361.1
3	Display Results	111	111	0.030	3700.0
	(SQL Overall)	178691	111	1.780	100388.2