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

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

85 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
squarish	20	4	732	(None)
squirish	20	4	511	1	squirish
aquarist	17	10	1008	2	aquarist
souaris	7	3	1233	2	souaris_
sourish	10	3	1069	2	sou_rish
squallish	21	4	340	2	squallish
squares	16	37	1446	2	squares_
squarest	17	33	822	2	squarest
squaring	18	15	863	2	squaring
squarishly	25	4	270	2	squarishly
squarks	20	41	718	2	squarks_
squash	18	4	683	2	squa__sh
squawfish	27	4	226	2	squawfish
squeamish	23	4	265	2	squeamish
squish	18	3	857	2	squ__ish
aquaria	16	3	804	3	aquari_a
aquarial	17	4	663	3	aquarial
aquarian	17	4	701	3	aquarian
aquarists	18	5	612	3	aquarists
aquarium	19	4	538	3	aquarium
bearish	12	30	1327	3	_bearish
boarish	12	39	1191	3	_boarish
currish	12	3	835	3	_currish
equalise	17	4	821	3	equalise
garish	10	45	1693	3	__garish
liquorish	21	5	254	3	liquorish
marish	11	43	1906	3	__marish
nourish	10	3	970	3	nou_rish
parish	11	50	2236	3	__parish
quackish	26	5	438	3	_quackish
quaich	20	4	769	3	_qua_ich
quaigh	19	3	546	3	_qua_igh
quais	14	46	1839	3	_qua_is_
qualmish	22	4	401	3	_qualmish
quamash	21	4	429	3	_quamash
quarks	19	38	1091	3	_quarks_
quarts	15	47	1594	3	_quarts_
quash	17	45	1216	3	_qua__sh
queerish	20	4	531	3	_queerish
querist	16	3	1113	3	_querist
quirkish	24	4	299	3	_quirkish
qursh	17	41	1084	3	_qu_r_sh
qurush	18	3	550	3	_qu_rush
safaris	10	11	1066	3	safaris_
saris	5	45	4495	3	s__aris_
shariah	13	22	1053	3	s_hariah
sitarist	8	3	1528	3	sitarist
slavish	13	3	823	3	s_lavish
sluggish	13	4	477	3	sluggish
sluttish	11	4	544	3	sluttish
solarise	8	5	1254	3	solarise
solarism	10	8	1038	3	solarism
souari	6	3	1138	3	souari__
sparkish	17	27	697	3	s_parkish
spearfish	17	4	360	3	spearfish
squabs	17	42	932	3	squa_bs_
squads	16	44	1029	3	squa_ds_
squalid	17	3	705	3	squali_d
squalls	16	4	731	3	squalls_
squamose	19	4	427	3	squamose
square	15	45	1336	3	squar__e
squared	17	36	1056	3	squar_ed
squarely	20	4	535	3	squarely
squarer	16	34	1066	3	squar_er
squarers	17	33	803	3	squarers
squark	19	43	811	3	squar__k
squarrose	18	4	240	3	squarrose
squashy	22	3	384	3	squa__shy
squats	15	37	1296	3	squa_ts_
squawbush	26	5	131	3	squawbush
squawks	23	29	488	3	squawks_
squaws	18	43	878	3	squa_ws_
squires	16	38	1284	3	squires_
squiring	18	17	756	3	squiring
squirms	18	37	634	3	squirms_
squirts	16	34	801	3	squirts_
squishy	22	4	402	3	squ__ishy
squoosh	19	6	284	3	squ_oosh
squush	18	3	399	3	squ__ush
starfish	14	3	808	3	s_tarfish
studfish	15	4	452	3	studfish
sunfish	13	3	888	3	s_unfish
sunrise	7	3	1081	3	s_unrise
tovarish	14	4	512	3	tovarish
wearish	13	23	1015	3	_wearish

Search took 9 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	146162	0.406	440125.6
2	DLD Change Limit	146162	85	7.953	18378.2
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	8.389	21300.6