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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
denature93807(None) 
denatured1146031denatured
denatures1038131denatures
denture8311891den_ture
renature839331renature
crenature1145762crenature
defeature1344342defeature
dentures9312452den_tures
departure1243802departure
feature1039852fe_ature
geniture946452geniture
nature6311262__nature
renatured1047292renatured
renatures939452renatures
venture10311172ven_ture
adventure1344393adven_ture
arcature1086493arcature
armature10106973armature
ceinture1036313ceinture
censure92310603cen_sure
centare93113703cen_tare
centaur935783centaur_
centaurea1143503centaurea
centaurs1035733centaurs
centaury1343953centaury
centre84316643cen_t_re
century1237193cen_tury
cincture1245583cincture
creature1038743creature
crenatures1245343crenatures
cubature1244693cubature
datura738033d__atura
debate94419193debat__e
debater104114693debater_
debaters113511923debaters
debenture1243473debenture
decare93919153deca__re
defeatures1444013defeatures
dekare112811563deka__re
delate73827753delat__e
delator83015023delator_
delators92314823delators
demure9311533de__mure
denar65223293dena__r_
denari710917353dena__ri
denars74621433dena__rs
denary105316863dena__ry
denaturant1154513denaturant
denaturing12115863denaturing
dengue838253den_gu_e
denote74118043denot__e
denotive1238673denotive
dentate8315153den_tate
dentine83320243den_tine
dentural948083den_tural
denude8169353den__ude
departures1343533departures
derate74531233derat__e
devalue1136013devalu_e
dewater112912423dewater_
dewatered1444743dewatered
dewaterer1343713dewaterer
dewaters122910723dewaters
donate73619503donat__e
donative12139873donative
donator8310263donator_
donators9310403donators
enate54428153_enat__e
endure74014143_en_dure
enrapture1143263_enrapture
ensure63416003_en_sure
entire61617703_en_tire
enure53520223_en__ure
erasure736943_erasure
featured1237683fe_atured
features11310333fe_atures
filature1145423filature
genitures1046123genitures
gesture839243ge_sture
immature1244443immature
indenture1045063inden_ture
juncture1743903juncture
lecture9149513le_cture
ligature945133ligature
mature8313473__mature
measure939033me_asure
miniature1145263miniature
natured838963__natured
natures7311963__natures
nervature1263823nervature
nonmature1145453nonmature
ossature843303ossature
prelature1146273prelature
premature1347793premature
puncture1245053puncture
recapture1384713recapture
senate63725173senat__e
senator7313073senator_
senators8312953senators
serrature945003serrature
signature1053763signature
stature74410683_stature
tenure6311613ten__ure
texture1497083te_xture
tincture1044673tincture
ventured1238273ven_tured
venturer1137243ven_turer
ventures11311493ven_tures
venturi1037203ven_turi
vesture10310373ve_sture

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.436409841.7
2DLD Change Limit1461621106.69021847.8
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.17224915.1
 
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.