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

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

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
ruffian	13	4	413	(None)
ruffians	14	4	379	1	ruffians
muffin	14	29	887	2	muffi_n
puffin	14	114	900	2	puffi_n
raffia	12	28	770	2	raffia_
raffias	13	23	771	2	raffias
ruffianly	18	5	162	2	ruffianly
ruffing	14	32	1084	2	ruffing
affiant	13	4	843	3	_affiant
biffin	14	36	910	3	biffi_n
boffin	14	35	905	3	boffi_n
buffi	13	61	1220	3	buffi__
buffier	15	6	840	3	buffier
buffing	16	34	1139	3	buffing
buffoon	15	4	371	3	buffoon
coffin	14	33	981	3	coffi_n
crucian	11	4	628	3	cru_cian
cuffing	16	32	1025	3	cuffing
durian	7	3	1200	3	du_rian
fustian	10	3	690	3	fustian
griffin	14	3	451	3	griffi_n
gruffier	15	4	470	3	gruffier
gruffily	18	6	308	3	gruffily
gruffing	16	3	527	3	gruffing
gruffish	18	4	394	3	gruffish
guffaw	16	4	279	3	guff_aw
huffier	16	3	749	3	huffier
huffily	19	3	469	3	huffily
huffing	17	27	883	3	huffing
huffish	19	3	571	3	huffish
luffa	11	40	902	3	luff_a_
luffas	12	33	748	3	luff_as
luffing	14	33	1010	3	luffing
maffia	14	32	720	3	maffia_
maffias	15	32	728	3	maffias
muffing	16	32	1040	3	muffing
muffins	15	30	834	3	muffins
puffier	15	4	797	3	puffier
puffily	18	3	484	3	puffily
puffing	16	29	1094	3	puffing
puffins	15	27	891	3	puffins
radian	7	41	1727	3	r_adian
raffish	16	5	884	3	raffish
redfin	10	3	1022	3	redfi_n
reffing	14	37	1217	3	reffing
refrain	10	3	1004	3	refrain
riffing	14	40	1127	3	riffing
ruction	9	36	1161	3	ruction
ruff	10	51	2765	3	ruff___
ruffe	11	47	1381	3	ruff__e
ruffed	13	43	1274	3	ruff_ed
ruffes	12	41	1242	3	ruff_es
ruffianism	18	5	181	3	ruffian~~ism~~
ruffle	12	41	1167	3	ruff_le
ruffled	14	36	915	3	ruffled
ruffler	13	36	972	3	ruffler
ruffles	13	35	1227	3	ruffles
rufflier	14	3	401	3	rufflier
rufflike	18	4	325	3	rufflike
ruffling	15	4	609	3	ruffling
ruffly	15	33	667	3	ruff_ly
ruffs	11	45	1674	3	ruff__s
rufiyaa	13	4	119	3	rufiyaa
ruin	4	74	3051	3	ru__i_n
rumina	8	34	1248	3	ru_mina
rupiah	11	4	621	3	ru_piah
rurban	8	4	904	3	ru_rban
rutin	5	54	2134	3	ru_ti_n
suffice	15	19	757	3	suffice
suffix	19	3	523	3	suffi_x
suffixal	21	4	285	3	suffixal
surfman	12	3	620	3	surfman
taffia	12	28	690	3	taffia_
taffias	13	37	741	3	taffias
tiffin	12	32	793	3	tiffi_n
turfman	12	4	398	3	turfman

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.390	458182.1
2	DLD Change Limit	134027	76	5.766	23244.4
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	6.186	28886.4