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

166 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
texture149708(None) 
textured1695481textured
textures1597521textures
denture8311892denture
feature1039852feature
fixture1734962fixture
gesture839242gesture
lecture9149522lecture
mixture1635412mixture
retexture1643072retexture
tenure6311612te_nure
textile1437222textile
textual1444602textual
textuary1842672textuary
textural1544942textural
texturize2544282texturize
torture738592torture
venture10311172venture
vesture10310372vesture
aperture1046383aperture
capture1138913capture
ceinture1036313ceinture
censure92310603censure
centare93113703centare
centre84316643cent_re
century1237193century
cloture9238453cloture
contexture1943933contexture
couture9310623couture
creature1038743creature
culture939393culture
demure9311533de_mure
denature938073denature
dentures9312453dentures
dexter143810893dexter_
dextro1436123dext_ro
endure74014143_endure
ensure63416003_ensure
entire61617703_entire
enure53520223_e_nure
etude63612303_e_tude
excuse1537423_excuse
exhume1833803_exhume
expire1538023_expire
extern1348473_extern
externe1438573_externe
extort13513973_extort
extra1239003_ext_ra
extrude1545013_extrude
exude134010293_ex_ude
exurb1457703_ex_urb
facture12108933facture
featured1237683featured
features11310333features
fixtures1835283fixtures
fixure16256543fix_ure
flexure1743413flex_ure
future939563_future
geniture946453geniture
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
hectare1238463hectare
hektare1435503hektare
lectured11127233lectured
lecturer10136033lecturer
lectures101310163lectures
leisure736693leisure
lettuce943323lettuce
mature8313473_mature
measure939033measure
metre74821303me_t_re
mixtures1735753mixtures
multure939183multure
nature6311263_nature
nervure1034973nervure
nurture736643nurture
overture111511683overture
pasture9311463pasture
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
picture1158613picture
posture9313253posture
rapture937393rapture
remixture1843673remixture
renature839333renature
restore75822983restore
retextured1842403retextured
retextures1743003retextures
retire64927013re_tire
retore67630773re_tore
retune69121953re_tune
return623222523re_turn
retuse66617223re_tuse
rupture966163rupture
secure8513533se_cure
seisure738193seisure
seizure1634683seizure
sextile1438573sextile
sextuple1762773sextuple
stature74410683stature
suture6313203_suture
tartare73012683tartare
tartufe1064673tartufe
teatime9310083teatime
teaware1048143teaware
tectite9310583tectite
tectum10328603tectu_m
tectums11306423tectums
teeter65420313teeter_
teetered9258303teetered
teeters74018303teeters
teethe94511313teet_he
teether10349693teether
tektite1136883tektite
tempura11295253tempura
tenour62610733tenour_
tenours72610073tenours
tentage81010643tentage
tenter64623933tenter_
tentered96412103tentered
tenters73921103tenters
tentie62521183tent_ie
tentier73815923tentier
tenured838363te_nured
tenures7412013te_nures
tessiture943303tessiture
testae64216253test_ae
testate73916233testate
testee64323303test_ee
tester64227153tester_
testers74124543testers
testier74015643testier
testudo843363testudo
tether93716103te_ther
tetra53417953te_t_ra
tetri52716453te_t_ri
tetter64322453tetter_
tetters74320473tetters
text116033933text___
textiles1536833textiles
texts125515043text__s
textuaries1743623textuaries
texturing1735223texturing
texturized2743453texturized
texturizes2643963texturizes
theatre10358493theat_re
tincture1044673tincture
titre54619393t_it_re
tonsure758783tonsure
tortured935843tortured
torturer835493torturer
tortures838913tortures
treasure846753treasure
tressure846483tressure
velure939773ve_lure
ventured1238273ventured
venturer1137243venturer
ventures11311493ventures
venturi1037203venturi
verdure11287773verdure
vestured1237463vestured
vestures11311043vestures
vulture1036763vulture
wafture1334853wafture

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271667.81317154.4
3Display Results1661660.0762184.2
 (SQL Overall)1786911668.29521542.0
 
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.