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

162 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
textures159752(None) 
texture1497081texture_
textured1695481textured
dentures9312452dentures
features11310332features
fixtures1835282fixtures
gestures9310012gestures
lectures101310162lectures
mixtures1735752mixtures
retextures1743002retextures
tenures7412012te_nures
textiles1536832textiles
textuaries1743622textuaries
textural1544942textural
texturizes2643962texturizes
tortures838912tortures
ventures11311492ventures
vestures11311042vestures
apertures1146483apertures
captures1239443captures
ceintures1136733ceintures
censures102211623censures
centares102913893centares
centres93817123cent_res
centuries11311333centuries
cestuses1038083cestuses
clotures10299023clotures
contextures2054123contextures
coutures10311993coutures
creatures1138423creatures
cultures10310153cultures
denatures1038133denatures
denture8311893denture_
endures83314603_endures
ensures73315903_ensures
entires71517783_entires
enures63919713_e_nures
etudes73811603_e_tudes
excuses1638903_excuses
exhumes1934323_exhumes
expires1638683_expires
externes1539833_externes
externs1438233_externs
extorts1447753_extorts
extras13310223_ext_ras
extrudes1645243_extrudes
exudes143710363_ex_udes
exurbs1534423_ex_urbs
factures13129043factures
feature1039853feature_
featured1237683featured
fetuses10310243fe_tuses
fixture1734963fixture_
fixures17596063fix_ures
flexures1843423flex_ures
futures10310263_futures
genitures1046123genitures
gesture839243gesture_
gestured1036993gestured
gesturer935983gesturer
gesturers1044283gesturers
hectares1338863hectares
hektares1535823hektares
lecture9149523lecture_
lectured11127233lectured
lecturer10136033lecturer
lecturers11124233lecturers
leisures836683leisures
lemures938793le_mures
lettuces1043503lettuces
matures9314313_matures
measures1038913measures
meatuses1038203meatuses
metres85121563me_t_res
mixture1635413mixture_
multures1039333multures
natures7311963_natures
nervures1135123nervures
nexuses1436743nex_uses
nurtures837443nurtures
overtures121611453overtures
pastures10311963pastures
perdures11289683perdures
perjures17268083perjures
perturbs1244363perturbs
pictures1249343pictures
postures10313783postures
raptures1037583raptures
remixtures1943233remixtures
renatures939453renatures
restores85222993restores
retexture1643073retexture_
retextured1842403retextured
retires74726213re_tires
retunes76918403re_tunes
returns79712593re_turns
ruptures1056683ruptures
secures9613163se_cures
seisures838273seisures
seizures1744633seizures
sextiles1537643sextiles
sextuples1842743sextuples
statures83711113statures
sutures7314223_sutures
tartufes1164153tartufes
teatimes1039443teatimes
teawares1148083teawares
tectites1039993tectites
tectums11306423tectu_ms
teetered9258303teetered
teeters74018303teeter_s
teethers11328713teethers
teethes103611653teet_hes
tektites1236613tektites
tempuras12295063tempuras
tenours72610073tenour_s
tentages91011043tentages
tentered96412103tentered
tenters73921113tenter_s
tenues63816443te_nu_es
tenure6311613te_nure_
tenured838363te_nured
testates83615453testates
testees74215913test_ees
testers74124543tester_s
testes65125823test__es
testudos943053testudos
tethers103815313te_thers
tetras63017623te_t_ras
tetris62816293te_t_ris
tetters74320473tetter_s
texases1437573tex_ases
textile1437223textile_
textless15245793textless
texts125515043text___s
textual1444603textu_al
textuary1842673textuary
textureless1851523textureless
texturing1735223texturing
texturize2544283texturize
texturized2743453texturized
theatres11298643theat_res
tinctures1144923tinctures
titres64718933t_it_res
tonsures869133tonsures
torture738593torture_
tortured935843tortured
torturer835493torturer
torturers944343torturers
treasures946633treasures
tressures946293tressures
velures1039093ve_lures
venture10311173venture_
ventured1238273ventured
venturer1137243venturer
venturers1245523venturers
venturis1138193venturis
verdures12247753verdures
vesture10310373vesture_
vestured1237463vestured
vultures1137213vultures
waftures1434853waftures

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621628.25017716.6
3Display Results1621620.0802025.0
 (SQL Overall)1786911628.73620454.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.