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

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

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.

72 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
misprisions	15	5	315	(None)
misprision	14	5	350	1	misprision_
dispassions	14	5	388	3	dispassions
dispersions	14	4	645	3	dispersions
displosions	14	20	383	3	displosions
imprisons	13	4	491	3	_impris_ons
misdivisions	18	5	178	3	misdivisions
mispoising	15	4	658	3	mispoisi_ng
mispositions	16	5	530	3	mispositions
mispricing	17	4	671	3	misprici_ng
misprizing	24	4	753	3	misprizi_ng
missions	10	3	1190	3	mis___sions
aspersions	12	4	610	4	_aspersions
derisions	10	3	884	4	__derisions
discretions	14	4	722	4	discretions
discussions	14	4	424	4	discussions
dismissions	14	5	400	4	dismissions
dispassion	13	4	432	4	dispassion_
dispersion	13	4	686	4	dispersion_
displosion	13	18	449	4	displosion_
dispositions	15	4	647	4	dispositions
dispraising	15	4	604	4	dispraisi_ng
disprizing	23	4	792	4	disprizi_ng
disseisins	11	4	595	4	disseisi_ns
dissensions	12	17	557	4	dissensions
dissuasions	12	4	352	4	dissuasions
distensions	12	14	627	4	distensions
diversions	14	4	653	4	diver_sions
divisions	13	9	628	4	di__visions
emissions	11	4	692	4	emis___sions
fissions	11	3	803	4	fis___sions
immersions	14	4	400	4	immer_sions
impassions	14	4	484	4	_impassions
implosions	14	4	402	4	_implosions
imprecisions	18	5	392	4	_imprecisions
impressions	15	4	682	4	_impressions
imprison	12	4	479	4	_impris_on_
impulsions	14	4	360	4	_impulsions
incisions	11	4	735	4	_i_ncisions
intrusions	10	4	633	4	_intrusions
micturitions	16	13	301	4	micturitions
mifepristone	19	6	57	4	mifepristone
mifepristones	20	6	57	4	mifepristones
migrations	13	16	868	4	mi_grations
misassigns	13	5	241	4	mis_assigns
miscaptions	17	4	418	4	miscaptions
miscreations	16	4	706	4	miscreations
misdivision	17	5	192	4	misdivision_
misdriving	17	4	516	4	misdrivi_ng
misimpressions	20	8	169	4	misimpressions
misparsing	15	4	661	4	misparsi_ng
misphrasing	19	4	415	4	misphrasi_ng
mispoises	13	4	835	4	mispois__es
misposition	15	5	568	4	misposition_
misprices	15	4	791	4	mispr__ices
misprint	12	9	1297	4	mispr__i_nt
misprinting	16	4	682	4	misprinting
misprints	13	10	722	4	mispr__ints
misprizers	23	4	401	4	mispri_zers
misprizes	22	4	722	4	mispr__izes
misraising	13	4	812	4	misraisi_ng
misreckons	18	5	249	4	mis_reckons
mission	9	3	1274	4	mis___sion_
mistrains	11	5	1135	4	mistr_ai_ns
misunions	11	5	453	4	mis__unions
miswriting	16	4	684	4	miswriti_ng
omissions	11	4	615	4	omis___sions
prisons	9	3	1322	4	___pris_ons
responsions	13	6	377	4	responsions
sponsions	11	4	522	4	__sponsions
suspensions	13	5	384	4	suspensions
suspicions	14	5	376	4	susp_icions

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	148819	0.423	422437.4
2	DLD Change Limit	148819	72	8.343	17837.6
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	8.812	20278.1