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

364 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
vestals10461233(None) 
vestal94615571vestal_
vestas95916681vesta_s
centals94317052centals
cestas85018542cesta_s
dentals83915392dentals
festal94213562festal_
gestalt8411162gestalt
gestalts955492gestalts
instals7611712instals
mescals112911552mescals
metals84520882me_tals
petals84719812pe_tals
postals93716372postals
rentals74017472rentals
reseals73917662reseals
vassals1057952vassals
veals84926192ve__als
ventails1139822ventails
ventrals112910002ventrals
verbals121910742verbals
vessels1035932vessels
vesta86618302vesta__
vestally1437412vestally
vestees103513172vestees
vestral104111012vestral_
vests85325982vest__s
vistas94513272vista_s
visuals1036852visuals
vitals94514302v_itals
abettals1054723abettals
acetals93411353acetals
aerials74017553aerials
astrals75515243_astrals
australs8359533australs
aventails1244993aventails
besteads11307113besteads
bestial9311643bestial_
bestirs9311133bestirs
bestowals1443223bestowals
bestows1248863bestows
bests75932613best__s
bestuds10326753bestuds
betas75528763be_ta_s
betels84515063be_tels
bettas84913923betta_s
borstals1037463borstals
buttals938503buttals
cantals93919573cantals
casuals91410523casuals
cental84420963cental_
centas85020703centa_s
centrals102712033centrals
cereals9313173cereals
cesta75419483cesta__
cestos84718093cest_os
cestus84412913cest_us
costal85419513costal_
costars94218013costars
crestal9312133crestal_
crystals1347173crystals
cuestas957933cuesta_s
curtals93111623curtals
deals65435343de__als
decals93717713de_cals
deltas74414823delta_s
denials84114133denials
dental74319173dental_
dentils84115583dentils
desalt7518313des_alt
desalts839573des_alts
desmans1039003desmans
destain8412083destain
destains9311813destains
details84214043de_tails
dismals102010243dismals
distal73615773distal_
distils83015803distils
dossals8379293dossals
entails7912823_entails
equals1538693_equals
escars83913133_escars
eskars10357593_eskars
espials937093_espials
essays965653_essays
estate64719763_estate
estates74520183_estates
esters64627733_esters
estops84011223_estops
estral64716513_estral_
estrays10529403_estrays
estrus61912113_estrus
etas46432273_e_ta_s
extols1337683_extols
eyestalk15123173eyestalk
eyestalks16132343eyestalks
fecials123510333fecials
ferals94216643fe_rals
festally1437543festally
festers104121393festers
festivals1543373festivals
fests85828043fest__s
fetal85623373fe_tal_
fetas85624403fe_ta_s
fetials103711743fetials
fiestas1038433fiesta_s
fiscals1238003fiscals
genitals937243genitals
gestapo1044493gestapo
gestapos1153913gestapos
gestate83614073gestate
gestates93213733gestates
gestes75721393gest_es
gests66028813gest__s
getas65421483ge_ta_s
hartals10313023hartals
heals85733453he__als
heptads1335873heptads
herbals122710603herbals
hests85829933hest__s
hostas94515823hosta_s
hostels103712313hostels
instal6712193instal_
install779363install
installs858923installs
instars7411133instars
instils7811453instils
jesters144118193jesters
jests125922453jest__s
jetsams16124103jetsams
kestrels1235813kestrels
ketols104210763ke_tols
keypals1634353keypals
legals73412733le_gals
lentils73912973lentils
lethals1038113lethals
listels74212433listels
meals75933373me__als
meatal84114733meatal_
medals94218053me_dals
medials103914733medials
menials94015683menials
mental84521603mental_
mesas76823203mes_a_s
mescal104113483mescal_
mesial84818083mesial_
messans92710463messans
mestees94617753mestees
metal75427383me_tal_
metols84115773me_tols
mezcals20246533mezcals
miskals13369763miskals
missals93914423missals
mistrals101212623mistrals
mortals93914003mortals
nasals63312463nas_als
nectars938463nectars
nestable101613673nestable
nesters74422793nesters
nestle63013953nest_le
nestles73015463nestles
nestors73614973nestors
nests55728003nest__s
neutrals846283neutrals
oestrus7169583oestrus
overstays1535943overstays
overtalk1537073overtalk
overtalks1645663overtalks
pascals11610013pascals
pastas85422873pasta_s
pastels95215183pastels
pastils94416173pastils
peals75235493pe__als
pedals94316033pe_dals
pedestals1255203pedestals
pentads1039523pentads
pentyls1236523pentyls
peptalk1554823peptalk
peptalks1653843peptalks
pesetas938753peseta_s
pesters93827093pesters
pestle83215843pest_le
pestles93217693pestles
pestos84719083pest_os
pests75933273pest__s
petal76526893pe_tal_
petsais938433petsais
peytrals1355493peytrals
pistils93314303pistils
pistols93213983pistols
portals94015563portals
postal84317533postal_
rascals959663rascals
ratals64219583_ratals
reals55038653re__als
reatas64021013reata_s
recitals1039763recitals
recoals94214623recoals
rectal84418133rectal_
redials84416883redials
redtails968003redtails
refutals1165503refutals
rental63922023rental_
repeals94014523repeals
resails74616743resails
resale64025543res_ale
resales74724903res_ales
resaws93713513res_aws
resays93714153res_ays
rescale93215473rescale
rescales103414573rescales
reseal64819643reseal_
reseats74319583reseats
reseaus74012153reseaus
resells73313203resells
resoaks1148973resoaks
restable101618443restable
restables111511423restables
restack1339433restack
restacks1438093restacks
restaff1339013restaff
restaffs1444783restaffs
restage83316193restage
restages92815773restages
restamp1146483restamp
restamps1234703restamps
restart7320033restart
restarts8310873restarts
restate73824883restate
restates83423433restates
resters74130403resters
restorals978073restorals
rests54935873rest__s
restyle1038763restyle
restyles1139193restyles
retags73414303re_tags
retails74718973re_tails
retotals838463retotals
reveals103812723reveals
sals46851673__s_als
seals54839693__seals
seitans73312303seitans
sendals81912263sendals
sepals85217373se_pals
septal84513383septal_
serials73919743serials
servals103410743servals
sestets7911473sestets
setal56430903se_tal_
sextans14349263sextans
sials54227243__sials
siestas738813siesta_s
sisals63013573sis_als
spitals93011593spitals
stabs76221383__stabs
stags66226743__stags
stale55637103__stale
stales65538293__stales
stalk94518003__stalk
stalks104614553__stalks
stall54722353__stall
stalls64019933__stalls
stars55836573__stars
stats55933363__stats
stays86022023__stays
steals64020063__steals
teals56234133te__als
tectal83713253tectal_
tepals85415043te_pals
tertials8510073tertials
teslas64212173tesla_s
testa54822043testa__
testable101412623testable
testacy1235963testacy
testae64216253testa_e
testate73916233testate
testates83615453testates
testees74215913testees
testers74124543testers
testes65125823test_es
testily102910803testily
testis64916713test_is
testons7313563testons
tests56530193test__s
totals63115163_totals
unseals73212573unseals
usuals637783_usuals
vandals113211663vandals
vasal85516293vas_al_
vassal979243vassal_
vastly12508723vast_ly
vasts86423773vast__s
veal76936813ve__al_
vealy115817773ve__aly
vectors123212593vectors
veejays2042313veejays
veenas91410413veena_s
vegans103910853ve_gans
vegetal1156303vegetal_
veils84918803ve__ils
veinal93812963veinal_
velars93913723ve_lars
venal85523213ve_nal_
venial94218283venial_
ventage11109623ventage
ventages12119773ventages
ventail10310453ventail
venters103717733venters
ventral103612173ventral_
vents86125933vent__s
verbal112513663verbal_
verglas1137813verglas
veritas103012753verita_s
vernal93514213vernal_
versal93013753versal_
verstes104014283verst_es
versts93914733verst__s
verticals1457243verticals
verts85724733vert__s
vertus94613603vert_us
vesical12159813vesical_
vesicle12217923vesicle
vesicles13127073vesicles
vesperals1443933vesperals
vespers1239033vespers
vespids1334613vespids
vessel937953vessel_
vest75743603vest___
vested104217353vest_ed
vestee94319153vest_ee
vestiary1444313vestiary
vestige1137433vestige
vestiges1238243vestiges
vesting114618683vesting
vestings12359143vestings
vestless11258843vestless
vestries11314053vestries
vestry1238623vest_ry
vestural1156473vestural_
vesture10310373vesture
vestures11311043vestures
vetoes92914083ve_toes
vets76835093ve_t__s
vetters104016323vetters
vexils1647173ve_xils
vials85822383v__ials
victuals1344773victuals
vinals94716483v_inals
visas84317653vis_a_s
vista85416603vista__
vistaed1138023vistaed
vistaless1254573vistaless
visual938803visual_
vital84819673v_ital_
vocals113811583v_ocals
weals85428743we__als
westers105221963westers
wests85727003west__s
yentas94614213yenta_s
zeals145320853ze__als
zesters163517293zesters
zestily19167563zestily
zests145419743zest__s
zetas145018163ze_ta_s

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 Limit1340273647.00019146.7
3Display Results3643640.1232959.3
 (SQL Overall)1786913647.27924548.8
 
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.