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

216 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
vestral10411101(None) 
estral64716511_estral
ventral103612171ventral
vestal94615571vest_al
vestural1156471vestural
astral66919282_astral
austral73411512austral
bestial9311642bestial
central93114472central
dextral1577002dextral
estray95713332_estray
estrual7367932_estrual
festal94213562fest_al
gastral8329552gastral
gestural946032gestural
kestrel1137112kestrel
lustral7339652lustral
mistral91013642mistral
neutral737922neutral
peytral1287502peytral
restoral8810982restoral
retral64419742re_tral
rostral7311332rostral
ventrals112910002ventrals
vesical12159812vesical
vesperal1344882vesperal
vesta86618302vest_a_
vestals104612332vest_als
vestas95916682vest_as
vestry1238622vestr_y
aestival1145483aestival
ancestral1145183ancestral
antral65719413_antral
astrals75515243_astrals
astray95615543_astray
australs8359533australs
bedstraw1443253bedstraw
benthal1247953benthal
bestead10389123bestead
bestowal1344513bestowal
bestrew1248003bestrew
bestrid1039973bestrid
bestrow1237253bestrow
betray111511443be_tray
caesural1055393caesural
cental84420963cent_al
centra84113883centra_
centrals102712033centrals
cesta75419483cest_a_
cestas85018543cest_as
cesura838763cesura_
cesurae937703cesurae
cesuras958693cesuras
citral81113893_citral
costal85419513cost_al
costrel9310373costrel
crestal9312133crest_al
dental74319173dent_al
dentural948083dentural
destroy1138153destroy
dextran1586163dextran
diastral946993diastral
distal73615773dist_al
dustrag945363dustrag
enteral73516443_enteral
enthral103410933_enthral
entrap8710563_entrap
espial839543_espial
estival1036323_estival
estrays10529403_estrays
estreat7314813_estreat
estrin6315923_estrin
estriol747553_estriol
estrum81810513_estrum
estrus61912113_estrus
eventual1144883eventual
extra1239003_extra_
extras13310223_extras
federal1148533federal
femoral1238723femoral
fenestral1244113fenestral
feral85424653fe__ral
festival1444713festival
fetal85623373fe_t_al
fetial95716193fe_tial
general81010933general
gestalt8411173gest_alt
gestical1138993gestical
instal6712193inst_al
jestful1745333jestful
kestrels1235813kestrels
lethal939803le_thal
lustra6358893lustra_
meatal84114733meat_al
menstrual1144353menstrual
mensural1046233mensural
mental84521603ment_al
mescal104113493mes_cal
mesial84818083mes_ial
mestranol1143893mestranol
metal75427383me_t_al
mistrals101212623mistrals
mistrial10311383mistrial
mitral81314323_mitral
neural6311993ne_ural
neutrals846283neutrals
nostril749303nostril
oestrin7312243oestrin
oestriol845383oestriol
oestrum9177783oestrum
oestrus7169583oestrus
olestra746173olestra_
olestras846583olestras
osetra667423osetra_
osetras737323osetras
osteal6312963_osteal
palestral1145323palestral
pastoral10310483pastoral
pastural1038413pastural
pectoral121210503pectoral
peroral9314793peroral
petal76526893pe_t_al
petrale9312623pe_trale
petrel83111533pe_trel
petrol82714063pe_trol
peytrals1355493peytrals
peytrel1264253peytrel
plastral1046913plastral
postal84317533post_al
postoral10311723postoral
postural1049203postural
rectal84418133rect_al
rental63922023rent_al
reseal64819643res_eal
respray1236503respray
restart7320033restart
restful1038623restful
restorals978073restorals
restrain8311703restrain
retial64724993re_tial
retrial7615553re_trial
ristra6310713ristra_
ristras7311563ristras
rostra6310933rostra_
sceptral1244513sceptral
sectoral10109543sectoral
semestral1185293semestral
septal84513383sept_al
seral56336383__seral
setal56430903se_t_al
several1039533several
sistra639333sistra_
spectral12246193spectral
steal56125473__steal
strap77925263__strap
straw813321293__straw
stray88525573__stray
sural55931263__sural
tectal83713253tect_al
tertial7313863tertial
testa54822043test_a_
testae64216253test_ae
tetra53417953te_tra_
tetrad73612053te_trad
tetras63017623te_tras
tetryl935693te_tryl
textual1444603textual
textural1544943textural
unstrap946783unstrap
vasal85516293vas__al
vassal979243vas_sal
veal76936813ve___al
vectorial14147403vectorial
vegetal1156303vegetal
veinal93812963ve_inal
venal85523213ve__nal
venereal1145083venereal
venial94218283ve_nial
ventail10310453ventail
ventrally1547253ventrally
vera76828843ve__ra_
verbal112513663ve_rbal
vernal93514213ve_rnal
versal93013753ve_rsal
vertebral1472803vertebral
vertical13410433vertical
vesica11157913vesica_
vesicae12177703vesicae
vesperals1443933vesperals
vessel937953ves_sel
vest75743603vest___
vestally1437413vestally
vested104217353vest_ed
vestee94319153vest_ee
vestees103513173vestees
vestiary1444313vestiary
vestige1137433vestige
vestigial1343773vestigial
vesting114618683vesting
vestries11314053vestries
vestryman1752013vestryman
vests85325983vest__s
vesture10310373vesture
vestured1237463vestured
vestures11311043vestures
veteran1039353veteran
victual1246253victual
viral86419593v__iral
virtual1045913virtual
visceral1344673visceral
vista85416603vist_a_
vistas94513273vist_as
visual938803vis_ual
vital84819673v_it_al
wastrel1037553wastrel
zestful1945243zestful

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.423422437.4
2DLD Change Limit1340272166.86019537.5
3Display Results2162160.0762842.1
 (SQL Overall)1786912167.35924282.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.