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 “nonself” 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.

116 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
nonself107851(None) 
oneself1046072oneself
ainsell796393ainsell
bonspell1243163bonspell
consent93723113consent
consol82614113consol_
console92715983console
consols92914073consols
consul82312303consul_
consuls92412323consuls
consult92513633consult
counsel948543counsel_
counsels1037583counsels
densely1146713densely
donzel1636313donzel_
donzels1735393donzels
dorsel75315503dorsel_
dorsels84412583dorsels
dossel74813643dossel_
dossels85511613dossels
enserf9310763_enserf
gonef95221293gon_e_f
gunsel7339853gunsel_
gunsels8338133gunsels
hansel95214373hansel_
hansels104011663hansels
herself1337623herself
himself1544293himself
hisself1335913hisself
hosel86024823ho_sel_
hosels94218613ho_sels
housel95217053housel_
housels105312143housels
itself946263_itself
lonely92912473lon_ely
loosely1036723loosely
losel54419423lo_sel_
losels64714593lo_sels
morsel85815893morsel_
morsels94112663morsels
myself1445593_myself
noel45226553no__el_
noels56418703no__els
noise55723733noise__
noised75416243noise_d
noises65021853noise_s
noisily1038403noisily
nonbelief1445623nonbelief
nonce75719823nonce__
nonces84418833nonce_s
noncola948303noncola
none45743173non_e__
nonego737013non_ego
nones55639133non_e_s
nonet54540843non_e_t
nonets64118703non_ets
nonfuel1045733nonfuel_
nonheme1247133nonheme
nonhero1057913nonhero
nonleafy1443083nonleafy
nonmeat9312773nonmeat
nonmen8412833nonme_n
nonnews1035313nonnews
nonoily1049543nonoily
nonpeak1345473nonpeak
nonselves1246503nonselves
nonsense847393nonsense
nonsked1236243nonsked
nonskeds1343933nonskeds
nonskid1246383nonskid
nonslip946553nonslip
nonsolar847083nonsolar
nonsolid957413nonsolid
nonstop9106923nonstop
nonstyle1145003nonstyle
nonsuch1244683nonsuch
nonsuit7811343nonsuit
nonuple946153nonuple
nonuse63212253nonuse__
nonuser7299143nonuse_r
nonusers8268003nonusers
nonuses73313863nonuse_s
nonyl849773non_yl_
nonyls957853non_yls
nonzero1646123nonzero
noose55624063noose__
noosed75018023noose_d
nooser65517823noose_r
noosers74913933noosers
nooses65623653noose_s
nose46739363no_se__
nosed65524563no_se_d
noses55435643no_se_s
nosey85619883no_se_y
nosily93712683no_sily
nouses64627163nouse_s
novel85615993no_vel_
novels95512503no_vels
onset54730173_onse_t
onsets64013543_onsets
ourself1057453ourself
ousel55222403_ousel_
ousels64815283_ousels
rondel73212643rondel_
rondels82510053rondels
ronnel63310893ronnel_
ronnels7318623ronnels
self75138293___self
tensely1037363tensely
thyself1643033thyself
tinsel639443tinsel_
tinsels738373tinsels
tonsil6311873tonsil_
tonsils7310183tonsils
unsell63512543_unsell
yourself1442653yourself

Search took 7 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 Filter1786911340270.393454684.5
2DLD Change Limit1340271166.11021935.7
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.54927285.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.