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

61 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
nondestructive207274(None) 
nonrestrictive1972592nonrestrictive
constructive1957443con__structive
destructive1755693___destructive
nonconstructive2293463nonconstructive
nondeductive1953763nonde__ductive
nondescriptive2261973nondescriptive
nondisruptive1962203nondis_ruptive
nondistinctive2071913nondistinctive
constrictive1956624con__strictive
indestructible19141964_indestructible
instructive1656484_in__structive
nondirective1854684nond__irective
nonretractile1562404nonre_tractile
nonretroactive1962034nonre_troactive
obstructive1854614_o__bstructive
unconstructive21104214uncon__structive
uninstructive1862944_uninstructive
concentrative2056215concentr_ative
conductive1848145cond____uctive
constructible19113765con__structible
constructing1746755con__structing
construction1648085con__struction
constructively2463845con__structively
contractive1849525con___tractive
deconstructive22124105deconstructive
destructible1752785___destructible
destructing1546115___destructing
destruction1446955___destruction
destructively2253925___destructively
detractive1647375___de_tractive
distractive1746775___distractive
indestructibly22151675_indestructibly
indistinctive1992285_indistinctive
nonabsorptive2061865nonabsor_ptive
nonassertive1553465nonasser__tive
nonconductive2164645non_conductive
nonconstruction1983275nonconstruction
nondeceptive2053735nonde__ceptive
nondeductible1962395nonde__ductible
nonderivative2063515nonde_rivative
nondiscursive1961515nondis_cursive
noneffective2363585non_e_ffective
nonelective1666855non_e__lective
nonevaluative1982485non_evaluative
nonexecutive2452875non_execu_tive
noninductive1854215non__inductive
noninteractive1973025noninteractive
nonintrusive1562385non_intru_sive
nonintuitive1563635non_int_uitive
nonnutritive1563145non_nutr_itive
nonproductive2193395non_productive
nonreactive1645955nonre___active
nonreproductive2371715nonreproductive
nonrestricted1662695nonrestrict_ed
nonselective1755415non__selective
nonstructured1663445non__structured
obstructives1953915_o__bstructives
reconstructive21124465reconstructive
restrictive1646365___restrictive
underactive1745965_unde__ractive

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 Filter178691950240.360496363.9
2DLD Change Limit95024615.96615927.6
3Display Results61610.0461326.1
 (SQL Overall)178691616.37228043.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.