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

67 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
nonfigurative206282(None) 
configurative2262811configurative
configuration1954133configuration
figurative1744113___figurative
prefigurative2262073prefigurative
confederative2253754confederative
configurations2063704configurations
confutative1955444conf__utative
continuative1755214continu_ative
denigrative1655484den_ig_rative
infiltrative1852814_infiltrative
noncumulative2062544noncumulative
nondisruptive1962204nondisruptive
nonimitative1784544non_imitative
nonnarrative1553834non_narrative
nonnegative1555174nonneg__ative
nonoperative1756284non_operative
colligative1754345collig__ative
commiserative2283275commiserative
concentrative2056215concentrative
conciliative1954165conci_liative
configurational2162205configurational
configure1544465configur____e
configuring1853155configur__ing
consecrative1957315con_secrative
figurate1237195___figurat__e
figuration1445915___figuration
figuratively2253005___figuratively
indurative1447285_in__durative
insinuative1454025_insinu_ative
integrative1547125_integ_rative
manipulative1952505man_ipulative
nominative1597685no_mi__native
nonabrasive1652575non__abrasive
nonabsorptive2061865nonabsorptive
nonassertive1553465nonasser_tive
noncognitive1863765noncog_nitive
noncombative2154445non_combative
noncommutative2362635noncommutative
noncooperative21113475noncooperative
noncreative1648235non__creative
nondeductive1953765nondedu_ctive
nonderivative2063515nonderivative
nondirective1854685nondi_rective
nondiscursive1961515nondiscur_sive
nonevaluative1982485nonevaluative
noninductive1854215non_inductive
noninfective2054585non_infective
noninteractive1973025noninteractive
nonintrusive1562385non_intrusive
nonintuitive1563635non_intuitive
noninvasive1772455non_i_nvasive
nonliterate1156195nonliterat__e
nonmigratory1862255nonmig_ratory
nonnative1248345non____native
nonnormative1754865non_normative
nonnutritive1563145non_nutritive
nonpunitive1654775non__punitive
nonregulation1473905nonregulation
nonrelative1456835non__relative
nonspeculative2161995nonspeculative
nuncupative1853105nun__cupative
obliterative1753055_obliterative
originative1553935_o_riginative
prefiguration1953455prefiguration
prefiguratively2771305prefiguratively
reconfiguration2162055reconfiguration

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 Limit124790678.76614235.7
3Display Results67670.0461456.5
 (SQL Overall)178691679.20219418.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.