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

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

49 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
noncreativity216271(None) 
creativity1845173___creativity
noncreative1648233noncreativ__e
noncreativities2082763noncreativities
connectivity2254554con_nectivity
nonadditivity2191524nonadditivity
nonobjectivity3171804nonobjectivity
collectivity2254235co_llectivity
commutativity2561975commutativity
concavity1944625conc__a__vity
concentricity1963725conc_entricity
concretist1448195concre_ti_st_
concretists1555465concre_ti_sts
concretizing2654305concre_tizing
conductivity2353795con_ductivity
contractility2074075contractility
creatively1846675___creatively
directivity2054105__directivity
honorability2055815honor_ability
infectivity2254715_in_fectivity
nativity1446645__n___ativity
negativity1754245__n_egativity
nonbreathing1852105nonbreat_hing
noncelebrity1962155nonc_elebrity
noncertified1873365nonc_ertified
noncredit1265575noncre___dit_
nonentity1246715non__ent__ity
nonidentity1553765nonident__ity
nonmotility1654055non__motility
nonreactive1645955non_reactiv__e
nonrealistic1454965non_realistic
nonrelative1456835non_relativ__e
nonrelatives1564205non_relativ_es
nonrelativistic20131465non_relativistic
nontreatment1454135nontreatment_
nontreatments1563295nontreatments
nonutility1355045non___utility
nonvalidity1852375non__validity
normatively1954635no__rmatively
objectivity2853955_o_bjectivity
overactivity23103975_overactivity
pancreatitis1661885pancreatiti_s
perceptivity2453425perc_eptivity
reactivity1845405____reactivity
receptivity2153885_rec_eptivity
relativity1645245____relativity
susceptivity2272385susc_eptivity
uncreative1547535_uncreativ__e
underactivity2272465_underactivity

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790498.92313985.2
3Display Results49490.0301633.3
 (SQL Overall)178691499.34319125.7
 
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.