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

Here are the results of your fuzzy-string dictionary search for “squamae” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

88 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
squamae	18	4	572	(None)
squama	17	3	653	1	squama_
squamate	19	4	578	1	squamate
squamates	20	4	559	2	squamates
squamose	19	4	427	2	squamose
square	15	45	1335	2	squa_re
summae	10	39	1101	2	s_ummae
usquabae	19	4	189	2	usquabae
aquacade	20	4	334	3	aquacade
aquae	14	22	1271	3	aqu__ae
desquamate	22	5	150	3	desquamate
equable	18	4	925	3	equable
equate	15	20	1246	3	equa_te
quaere	15	41	1067	3	_quaere
quake	18	41	1464	3	_qua_ke
quale	14	36	1785	3	_qua_le
quamash	21	4	428	3	_quamash
quare	14	39	2054	3	_qua_re
quarte	15	41	1532	3	_quarte
quasar	15	3	683	3	_quasar
quate	14	45	2141	3	_qua_te
quatre	15	35	1235	3	_quatre
quayage	20	4	457	3	_quayage
sagaman	10	11	755	3	sagaman
same	6	52	4564	3	s__am_e
seaman	8	40	1590	3	s_eaman
sequelae	17	5	367	3	sequelae
sesame	8	3	1101	3	sesam_e
shaman	11	33	1427	3	s_haman
shamas	11	37	1793	3	s_hamas
shame	10	57	2670	3	s_ham_e
soulmate	10	4	718	3	soulmate
spume	9	58	1731	3	spu_m_e
squab	16	38	1073	3	squ__ab
squabble	21	4	388	3	squabble
squabby	23	4	328	3	squabby
squabs	17	42	932	3	squa_bs
squad	15	51	1079	3	squ__ad
squadded	20	3	384	3	squadded
squads	16	44	1029	3	squa_ds
squalene	17	4	561	3	squalene
squalid	17	3	704	3	squalid
squall	15	3	799	3	squa_ll
squalled	18	3	594	3	squalled
squaller	17	3	608	3	squaller
squalls	16	4	730	3	squalls
squally	19	3	766	3	squally
squalor	16	4	442	3	squalor
squamosal	20	5	182	3	squamosal
squamous	19	4	466	3	squamous
squander	18	3	553	3	squander
squared	17	36	1055	3	squared
squarer	16	34	1065	3	squarer
squares	16	37	1445	3	squares
squark	19	43	811	3	squa_rk
squarks	20	41	718	3	squarks
squash	18	4	683	3	squa_sh
squashed	21	21	598	3	squashed
squasher	20	18	577	3	squasher
squashes	20	20	780	3	squashes
squashy	22	3	384	3	squashy
squat	14	37	2014	3	squ__at
squatly	19	4	642	3	squatly
squats	15	37	1296	3	squa_ts
squatted	18	3	534	3	squatted
squatter	17	3	591	3	squatter
squatty	19	6	482	3	squatty
squaw	17	36	898	3	squ__aw
squawk	22	38	537	3	squa_wk
squawked	25	4	301	3	squawked
squawker	24	4	309	3	squawker
squawks	23	29	488	3	squawks
squaws	18	43	878	3	squa_ws
squeak	19	3	525	3	squ_eak
squeal	15	3	801	3	squ_eal
squeeze	25	4	359	3	squeeze
squillae	17	4	518	3	squillae
squire	15	59	1245	3	squ_ire
strumae	9	36	809	3	strumae
suable	8	39	2055	3	s_uable
suave	8	35	1987	3	s_ua_ve
sumac	9	95	1488	3	s_u_mac
summa	9	47	1331	3	s_umma_
summas	10	43	1316	3	s_ummas
summate	11	36	1166	3	s_ummate
sundae	7	3	1287	3	s_undae
usquabaes	20	4	155	3	usquabaes
usquebae	19	5	159	3	usquebae

Search took 7 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	88	6.703	19995.1
3	Display Results	88	88	0.046	1913.0
	(SQL Overall)	178691	88	6.905	25878.5