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

77 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
denatured114603(None) 
denature938071denature_
denatures1038131denatures
renatured1047291renatured
denture8311892den_ture_
dentures9312452den_tures
dewatered1444742dewatered
featured1237682fe_atured
natured838962__natured
renature839332renature_
renatures939452renatures
ventured1238272ven_tured
adventured1543343adven_tured
armatured1264623armatured
censured11248913cen_sured
centaurea1143503centaurea
centered112513523cen_tered
centred103411683cen_t_red
cinctured1444273cinctured
crenature1145763crenature_
crenatures1245343crenatures
deaired9411533de_a_ired
deathbed1543393de_athbed
debarred12165633deba_rred
debated113916083debat__ed
defatted1335673defat_ted
defeature1344343defeature_
defeatures1444013defeatures
delated93722873delat__ed
denaturant1154513denaturant
denaturing12115863denaturing
denoted93512763denot__ed
dentated10411703den_tated
dented84120513den_t__ed
dentiled1039743den_tiled
dentural948083den_tural
denuded10167663den__uded
departure1243803departure_
departures1343533departures
derated93623503derat__ed
deratted1048403derat_ted
detoured1036513de_toured
devalued1335013devalu_ed
devoured1335723de_voured
dewaterer1343713dewaterer
donated93513863donat__ed
enamored1147033_enamored
enamoured1243933_enamoured
endured93611213_en_dured
enraptured1352383_enraptured
ensured83512943_en_sured
entered82718883_en_tered
enured73315333_en__ured
feature1039853fe_ature_
features11310333fe_atures
geniture946453geniture_
genitures1046123genitures
gestured1036993ge_stured
indentured1243123inden_tured
lectured11127233le_ctured
ligatured1143333ligatured
matured10310043__matured
measured1136463me_asured
mentored1138003men_tored
nature6311263__nature_
natures7311963__natures
punctured1444183punctured
recaptured1573593recaptured
tentered96412103ten_tered
tenured838363ten__ured
textured1695483te_xtured
tinctured1243513tinctured
unmatured1245703unmatured
venture10311173ven_ture_
venturer1137243ven_turer
ventures11311493ven_tures
vestured1237463ve_stured

Search took 9 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 Filter1786911486410.403443402.0
2DLD Change Limit148641777.64319448.0
3Display Results77770.0302566.7
 (SQL Overall)178691778.07622126.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.