Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
narcisms126726(None) 
narcism1188731narcism_
narcists1078111narcists
anarchisms1744802anarchisms
fascisms1545662fascisms
laicisms1247122laicisms
nanisms938832na_nisms
narcissi1043302narcissi
narcissus1142162narcissus
narcist9512442narcis_t
narcoses103910542narcoses
narcosis10388042narcosis
narcotisms1444602narcotisms
parecisms1547162parecisms
racisms112310812ra_cisms
sarcasms1244982sarcasms
ageisms1056603_ageisms
agisms9399393_a_gisms
alarmisms1345003alarmisms
anarchism1645653anarchism_
anarchists1545183anarchists
animisms12328393animisms
archaisms1646063_archaisms
arcuses94814693_arcuses
arises65233803_ar_ises
arrises71617583_arrises
artists74215583_artists
autisms94311553_autisms
baalisms1238033baalisms
baptisms1446033baptisms
bariums1139143bar_iums
binarisms1346413binar_isms
calciums1446163calciums
cambisms1645793cambisms
carcases12313083carcases
carcass11310513carcas_s
cercises12410933cercises
charisms15710263char_isms
chrisms1499143chr_isms
czarisms2155753czar_isms
dadaisms1245123dadaisms
dwarfisms1841723dwarfisms
exorcisms2044863exorcisms
faddisms15264983faddisms
fairyisms1743073fairyisms
faradisms15256673faradisms
farcies125317883farci_es
fascism1436443fascism_
fascists1336613fascists
fauvisms1643743fauvisms
favisms1535443fa_visms
harpists1338093harpists
heroisms1338693heroisms
laicises1039573laicises
laicism1138243laicism_
lyricisms161979003lyricisms
lyrisms1235653lyr_isms
monarchisms2053283monarchisms
nabobisms1543693nabobisms
nancies93516843nanci_es
nanism8311203na_nism_
narceines1146583narceines
narceins1036413narceins
narcissism1452313narcissism
narcissisms1551803narcissisms
narcissist1252793narcissist
narcistic1346443narcistic
narcoma1145823narc_oma
narcomas1246043narcomas
narcos86714203narc__os
narcose95910383narcos_e
narcotism1344873narcotism_
narcs76122023narc___s
nargiles976793nargiles
naris55735293nar_i__s
nasalisms1147173nasalisms
nativisms14105993nativisms
natriums1046293natriums
naturisms1146703naturisms
nomisms11268743n_omisms
nudisms10305853n_udisms
ogreisms1144113ogreisms
ogrisms1036443ogr_isms
onanisms1048063ona_nisms
oralisms10610973oralisms
papisms13238543pa_pisms
parchisis16318573parchisis
parecism1458533parecism_
parises94827183par_ises
parvises133911913parvises
porisms113713453por_isms
prisms104915503_pr_isms
purisms114110833pur_isms
racism103214193ra_cism_
racists92613323ra_cists
sacrists1039563sacrists
sadisms10359113sa_disms
sarcasm1136693sarcasm_
sarcinas1039273sarcinas
tachisms1567143tachisms
truisms9106823_truisms
tsarisms1056653tsar_isms
tzarisms1965213tzar_isms
uranisms1099973uranisms
verisms123011253ver_isms

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1561145455.1
2DLD Change Limit1461621058.42017358.9
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.62220725.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.