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

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

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.

76 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
scalier	9	43	1691	(None)
scaler	8	43	2160	1	scal_er
scalper	11	39	1292	1	scalper
scarier	9	40	1787	1	scarier
shalier	10	31	1642	1	shalier
cagier	9	37	1593	2	_cagier
cahier	11	36	1577	2	_cahier
cakier	12	31	1524	2	_cakier
caliber	11	3	973	2	_caliber
caliper	11	4	1096	2	_caliper
calker	12	49	1708	2	_calker
caller	8	51	2548	2	_caller
calmer	10	52	1693	2	_calmer
coalier	9	34	1618	2	coalier
espalier	10	3	636	2	espalier
mealier	9	30	1590	2	mealier
palier	8	50	2356	2	_palier
sagier	7	37	1716	2	s_agier
sailer	6	35	2610	2	s_ailer
sallier	7	33	2042	2	sallier
salter	6	43	2508	2	s_alter
saltier	7	43	1863	2	s_altier
salver	9	46	1775	2	s_alver
scabbier	14	3	513	2	scabbier
scabies	11	6	1333	2	scabies
scalar	8	36	1243	2	scal_ar
scalare	9	33	1183	2	scalare
scalded	11	40	976	2	scalded
scale	7	46	2914	2	scal_e_
scaled	9	48	2244	2	scal_ed
scalers	9	38	1726	2	scal_ers
scales	8	45	2931	2	scal_es
scaliest	10	17	1439	2	scaliest
scaling	10	35	1937	2	scaling
scalped	12	44	1199	2	scalped
scalpel	11	37	771	2	scalpel
scalpers	12	37	1086	2	scalpers
scammer	13	36	1197	2	scammer
scamper	13	46	1316	2	scamper
scanner	9	44	1181	2	scanner
scanter	9	42	1518	2	scanter
scantier	10	30	998	2	scantier
scarcer	11	39	1137	2	scarcer
scarer	8	45	2461	2	sca_rer
scarfer	12	45	1108	2	scarfer
scarper	11	48	1482	2	scarper
scarrier	10	29	845	2	scarrier
scatter	9	38	1517	2	scatter
scattier	10	26	758	2	scattier
scauper	11	37	945	2	scauper
schliere	13	4	384	2	schliere
scolder	10	32	1034	2	scolder
scrawlier	14	4	390	2	scrawlier
sculker	13	31	832	2	sculker
sculler	9	98	1215	2	sculler
sealer	6	39	2896	2	seal_er
seamier	9	31	1463	2	seamier
shadier	11	31	1115	2	shadier
shakier	14	34	1115	2	shakier
shoalier	11	3	707	2	shoalier
sicklier	14	5	721	2	sicklier
sillier	7	40	1759	2	sillier
slatier	7	40	1681	2	slatier
slier	5	48	2724	2	s__lier
smaller	9	34	1033	2	smaller
snakier	11	28	1000	2	snakier
snarlier	8	27	818	2	snarlier
soapier	9	34	1171	2	soapier
spacier	11	40	1163	2	spacier
spaller	9	27	1347	2	spaller
stagier	8	35	1344	2	stagier
staler	6	40	2582	2	stal_er
stalker	11	39	1225	2	stalker
stalkier	12	5	707	2	stalkier
surlier	7	29	1544	2	surlier
vealier	10	27	1217	2	vealier

Search took 5 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	107671	0.373	479064.3
2	DLD Change Limit	107671	76	4.546	23684.8
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	4.952	36084.6