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

272 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
vesture1031037(None) 
gesture839241gesture
venture10311171venture
vestured1237461vestured
vestures11311031vestures
denture8311892denture
divesture13144182divesture
feature1039852feature
gestured1036992gestured
gesturer935982gesturer
gestures9310012gestures
lecture9149512lecture
overture111511682overture
pasture9311462pasture
posture9313252posture
restore75822972restore
texture1497082texture
velure939772ve_lure
ventured1238272ventured
venturer1137242venturer
ventures11311482ventures
venturi1037202venturi
verdure11287772verdure
vestee94319152vest_ee
vestige1137432vestige
vestry1238622vest_ry
vestural1156472vestural
vulture1036762vulture
adventure1344393adventure
aperture1046383aperture
assure6610773_assure
astute6310763_astute
austere7312993austere
bestir8311163bestir_
bestirs9311133bestirs
bestrew1248003best_rew
bestud9439303bestu_d
bestuds10326753bestuds
bistre83815023bist_re
capture1138903capture
ceinture1036313ceinture
censure92310603censure
centare93113703centare
centre84316643cent_re
century1237193century
cestode1037963cestode
cestus84412913cestu_s
cestuses1038083cestuses
cesura838763ces_ura
cesurae937703ces_urae
cloture9238453cloture
costume1157853costume
couture9310613couture
coverture1445403coverture
creature1038723creature
culture939393culture
dasyure1153823dasyure
demure9311533de_mure
denature938063denature
dentures9312453dentures
desire7415303des_ire
destine83719953destine
disturb1046233disturb
divestures14144253divestures
endure74014143_endure
ensure63416003_ensure
entire61617703_entire
enure53520223_e_nure
esquire16376593_esquire
estate64719763_estate
ester54727713_ester_
esters64627733_esters
estrum81810513_estrum
estrus61912113_estrus
estuary1034683_estuary
etude63612303_e_tude
facture12108923facture
featured1237683featured
features11310333features
fescue1137493fescu_e
fester94723513fester_
festered122512103festered
festers104121393festers
festive1339773festive
fissure1036783fissure
fixture1734963fixture
future939563_future
geniture946453geniture
gestate83614073gestate
geste65920693gest__e
gestural946033gestural
gesturers1044283gesturers
hectare1238463hectare
hektare1435503hektare
insure63416603ins_ure
jester134319153jester_
jesters144118193jesters
kestrel1137113kest_rel
lectured11127223lectured
lecturer10136023lecturer
lectures101310153lectures
leisure736693leisure
lettuce943323lettuce
lustre64011683lust_re
mature8313463_mature
measure939033measure
mestee84523883mest_ee
metre74821303me_t_re
mistune9310653mistune
mixture1635413mixture
moisture1046653moisture
multure939183multure
nature6311263_nature
nervure1034973nervure
nester64124183nester_
nesters74422783nesters
nestle63013953nest_le
nestler73510443nestler
nestor63713413nestor_
nestors73614953nestors
netsuke1142673netsuke
nurture736643nurture
obscure1145333obscure
oestrum9177783oestrum
oestrus7169573oestrus
ossature843303ossature
overcure132210053overcure
oversure111611163oversure
overtire111413113overtire
overtured13169213overtured
overtures121611443overtures
overturn11157303overturn
pastured1138233pastured
pasturer1037523pasturer
pastures10311963pastures
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
pester84827593pester_
pestered112814953pestered
pesterer102412703pesterer
pesters93827093pesters
pestier94317403pestier
pestle83215843pest_le
picture1158613picture
postured1139493postured
posturer1038923posturer
postures10313763postures
pressure1039773pressure
prestore104217343prestore
pustule937683pustule
rapture937383rapture
rasure6311423ras_ure
reassure847343reassure
renature839323renature
rescore95616193rescore
rescue8313003rescu_e
rescuer939033rescuer
resecure1047183resecure
resource1046313resource
respire9411543respire
restage83316183restage
restart7320033restart
restate73824873restate
rester63832433rester_
resters74130403resters
restive10315933restive
restoke116113903restoke
restored96417193restored
restorer84813723restorer
restores85222983restores
restudy1144763restudy
restuff1346953restuff
restyle1038763restyle
resume8313783res_ume
resurge839073res_urge
retire64927013re_tire
retore67630763re_tore
retune69121953re_tune
return623222523re_turn
retuse66617223re_tuse
rupture966163rupture
secure8513533se_cure
seisure738193seisure
seizure1634683seizure
sesterce1047113sesterce
sestine73017923sestine
stare54440263__stare
stature74410673stature
stere55328543__stere
store56333813__store
stoure64814943__stoure
stupe75217753__stupe
sturt56028963__sturt
sure45447413__s_ure
suture6313203_suture
tenure6311613te_nure
tessiture943303tessiture
testae64216253test_ae
testate73916233testate
testee64323303test_ee
tester64227153tester_
testers74124543testers
testier74015643testier
testudo843363testudo
textured1695483textured
textures1597523textures
torture738593torture
tressure846483tressure
unsure62815413uns_ure
upstare9158683upstare
vaster94521023vaster_
vastier103613203vastier
vector113212063vector_
vectored1435623vectored
vectors123212593vectors
veinule1056243veinule
velour9328763velour_
velours10278083velours
veloute1037733veloute
velured1136683ve_lured
velures1039093ve_lures
vendue10419013vendu_e
venire93513693ve_nire
ventage11109623ventage
venter94218723venter_
venters103717723venters
venturers1245523venturers
venturis1138193venturis
venue84918213ve_nu_e
venule94411763ve_nule
verdured13255763verdured
verdures12247743verdures
verste94515633verst__e
vertu85017613vertu__
vertus94613603vertu_s
vesicae12177703vesicae
vesicle12217923vesicle
vesper1138083vesper_
vespers1239033vespers
vespine1237903vespine
vest75743603vest___
vesta86618303vest__a
vestal94615573vest_al
vestals104612333vestals
vestas95916683vest_as
vested104217353vest_ed
vestees103513163vestees
vestiary1444313vestiary
vestibule1443693vestibule
vestiges1238243vestiges
vesting114618683vesting
vestlike1535393vestlike
vestral104111013vestral
vestries11314043vestries
vests85325983vest__s
vesturing1337203vesturing
vetoer93410063ve_toer
vetter93417643vetter_
vetters104016313vetters
virtue9358673virtu_e
vultures1137213vultures
wafture1334853wafture
wester94222893wester_
westered122511863westered
western102911093western
westers105221963westers
yester93417983yester_
yestern10338633yestern
zester153617793zester_
zesters163517293zesters
zestier163010223zestier

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272727.56317721.4
3Display Results2722720.1062566.0
 (SQL Overall)1786912727.82522835.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.