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 “nonclass” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
nonclass104624(None) 
noncash1245162nonc_ash
nonclasses1244962nonclasses
noncolas1048612noncola_s
nonplays1344892nonplays
bondless1148813bondless
boneless10310213boneless
class75525483___class
conceals123111033conceals
conchas144013313concha_s
conclave1556403conclave
conclaves1646543conclaves
concuss1138063conc_uss
declass1038733_declass
enclasp1145843_enclasp
enclasps1245133_enclasps
inclasp1145303_inclasp
inclasps1244353_inclasps
ironclads1252593ironclads
misclass1246843misclass
nonas55126653non__a_s
nonblack1644303nonblack
nonblacks1743923nonblacks
nonces84418833nonc__es
noncling11310763noncling
noncola948303noncola__
noncolors1147033noncolors
noncoms1139203nonc_oms
noncrises11129313noncrises
noncrisis11116683noncrisis
nonfans1037533non_fans
nongays11176533non_gays
nonglare946373nonglare
nonglares1046413nonglares
nonglossy1342113nonglossy
nonpast939033non_past
nonpasts1046553non_pasts
nonplay1246683nonpla_y
nonplus936183nonpl_us
nonpluses1145713nonpluses
nonwars10109003non_wars
nonyls957853nonyl__s
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
nuncles939843nuncl_es
onlays9398713_on_lays
outclass1037203outclass
songless9218823songless
sonless72612613son_less
subclass1246623subclass
sunglass945093sunglass
toneless8610393toneless
unclasp1135963_unclasp
unclasps1244573_unclasps
unclassy1343653_unclassy
windlass12266083windlass
zoneless1737823zoneless
zonulas1637023zonula_s

Search took 8 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.420425454.8
2DLD Change Limit146162607.50019488.3
3Display Results60600.0331818.2
 (SQL Overall)178691607.95322468.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.