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

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

93 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
squeaky	23	4	308	(None)
squeak	19	3	525	1	squeak_
squeaks	20	3	452	1	squeaks
quaky	21	43	1074	2	_qu_aky
queasy	18	5	517	2	_queasy
queazy	27	4	357	2	_queazy
screaky	16	43	622	2	screaky
sneaky	13	42	784	2	s_neaky
squeaked	22	8	390	2	squeaked
squeaker	21	8	488	2	squeaker
squeakily	25	4	200	2	squeakily
squeal	15	3	802	2	squea_l
squeals	16	3	651	2	squeals
streaky	14	44	781	2	streaky
beaky	14	61	1802	3	__beaky
creaky	15	49	1155	3	_creaky
equerry	19	4	305	3	equerry
freaky	16	43	923	3	_freaky
leaky	12	52	1772	3	__leaky
peaky	14	57	1815	3	__peaky
quacky	24	37	696	3	_quacky
quake	18	41	1464	3	_qu_ake
quay	16	46	1835	3	_qu_a_y
quean	14	36	1284	3	_quea_n
queans	15	31	1075	3	_queans
query	17	42	1208	3	_que_ry
quey	16	46	1647	3	_que__y
quirky	22	43	553	3	_quirky
screak	12	53	1106	3	screak_
screaks	13	46	936	3	screaks
seamy	10	59	2127	3	s__eamy
sequency	22	4	449	3	sequency
shaky	15	46	1684	3	s__haky
skunky	12	43	616	3	sku_nky
sleazy	18	26	739	3	s_leazy
sleeky	13	39	896	3	s_leeky
smeary	11	41	1080	3	s_meary
snaky	12	51	1391	3	s__naky
sneak	9	60	1617	3	s_neak_
sneaks	10	43	1249	3	s_neaks
speak	11	46	1867	3	s_peak_
speaks	12	51	1458	3	s_peaks
spunky	15	42	716	3	spu_nky
squab	16	38	1073	3	squ_a_b
squabby	23	4	328	3	squabby
squabs	17	42	932	3	squ_abs
squad	15	51	1079	3	squ_a_d
squads	16	44	1029	3	squ_ads
squall	15	3	800	3	squ_all
squally	19	3	767	3	squally
squama	17	3	653	3	squ_ama
square	15	45	1336	3	squ_are
squark	19	43	811	3	squ_ark
squarks	20	41	718	3	squarks
squash	18	4	683	3	squ_ash
squashy	22	3	384	3	squashy
squat	14	37	2014	3	squ_a_t
squatly	19	4	643	3	squatly
squats	15	37	1296	3	squ_ats
squatty	19	6	482	3	squatty
squaw	17	36	898	3	squ_a_w
squawk	22	38	537	3	squ_awk
squawks	23	29	488	3	squawks
squaws	18	43	878	3	squ_aws
squeakers	22	8	411	3	squeakers
squeakier	22	4	290	3	squeakier
squeaking	23	3	421	3	squeaking
squealed	18	8	535	3	squealed
squealer	17	11	560	3	squealer
squeeze	25	4	359	3	squeeze
squeg	15	8	803	3	sque__g
squegs	16	7	564	3	sque_gs
squelch	21	5	295	3	squelch
squelchy	25	9	198	3	squelchy
squiffy	25	4	257	3	squiffy
squinny	19	27	422	3	squinny
squinty	19	28	706	3	squinty
squirmy	21	37	429	3	squirmy
squishy	22	4	402	3	squishy
steady	10	35	1020	3	s_teady
steak	9	52	1980	3	s_teak_
steaks	10	44	1585	3	s_teaks
steamy	11	51	1237	3	s_teamy
streak	10	46	1362	3	streak_
streaks	11	44	1127	3	streaks
streamy	12	50	948	3	streamy
sucky	14	44	1550	3	s_u_cky
sudary	10	3	870	3	s_udary
suety	8	53	1849	3	s_ue_ty
sugary	10	3	901	3	s_ugary
sulky	12	47	1536	3	s_u_lky
sweaty	12	37	1005	3	s_weaty
tweaky	16	3	402	3	_tweaky

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.403	443402.0
2	DLD Change Limit	134027	93	6.296	21287.6
3	Display Results	93	93	0.033	2818.2
	(SQL Overall)	178691	93	6.732	26543.5