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

405 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
vervets1341975(None) 
velvets13326691velvets
versets103913101versets
verves124617881verve_s
vervet124619061vervet_
berets85822522ber_ets
brevets12519392brevets
cermets1139712cermets
corvets124715022corvets
curvets12399912curvets
ferrets103111392ferrets
nerves94216192nerve_s
overbets132510682overbets
overlets112312362overlets
oversets113114172oversets
overwets14219952overwets
perverts1337532perverts
revets94022172re_vets
servers103214832servers
serves94423652serve_s
tercets93512442tercets
terrets72913582terrets
trevets10499972trevets
varlets10411572varlets
varves124414782varve_s
velvet123613752velvet_
velvety16304002velvety
vergers114412632vergers
verges104320172verge_s
veriest103719132veriest
verists103613672verists
verites103822262verites
vermes115019142verme_s
versers103813522versers
verses94223762verse_s
verset94327322verset_
verstes104014282verstes
versts93914732ver_sts
verts85724732ver__ts
verve115417722verve__
aerates74627493aerates
aeries64737783aerie_s
aeriest73924053aeriest
afreets1037013afreets
armets84918353_armets
averments1449093averments
averters11249513averters
averts95715243aver__ts
barbets114915843barbets
barrets94917103barrets
beavers124417323beavers
beckets15399823beckets
beets76131443be__ets
beeves114615043beeve_s
befrets1237613befrets
begets96215523be_gets
bennets94712163bennets
berates94126873berates
beret74946363ber_et_
bermes106023003berme_s
besets85718803be_sets
bevels113913983be_vels
breves115516423breve_s
brevet115717333brevet_
burets84321263bur_ets
burnets93813263burnets
carets85330773car_ets
carnets93918403carnets
carpets113915333carpets
carvels124914593carvels
carvers124817533carvers
carves115128453carve_s
cerates95428253cerates
ceres75540013cer_e_s
cereus85215523cer_eus
cerites94823433cerites
cermet10321153cermet_
certes84623083certe_s
cervelas1344673cervelas
cervelats1443493cervelats
cerveza2142333cerveza
cervezas2242013cervezas
chevrets16255323chevrets
civets115212543_civets
cornets94820573cornets
corsets94819803corsets
corvees124613793corvees
corves115122523corve_s
corvet114626933corvet_
coverlets1437053coverlets
covets114819643_covets
cruets85314953_cruets
curets84922343cur_ets
curves114619283curve_s
curvet114720243curvet_
deaves105319533deave_s
deets65330243de__ets
delvers113411993delvers
delves104917083delve_s
derates84028893derates
derats74625063der_ats
derivers123811363derivers
derives114017813derive_s
devels104313903de_vels
devest104418703de_vest
devests114410473de_vests
duvets1039223_duvets
eaves85231993_eave_s
ebbets10376833_ebbets
eeriest73620673eeriest
egrets72712243_egrets
elvers93814983_elvers
elves85118743_elve_s
emmets10349153_emmets
erects84116183_erects
ergots74512373_ergots
ernes55224813_erne_s
erses55826803_erse_s
eructs83610793_eructs
erupts8348903_erupts
ervils948773_ervils
evens84817103_e_vens
events94814073_e_vents
everts94514893_e_verts
eves76230463_e_ve_s
feres86038183fer_e_s
ferments13311473ferments
ferrels10248623ferrels
ferret93021173ferret_
ferrety13287013ferrety
fervent13310063fervent
fervors1336233fervors
fevers125414893fe_vers
forgets113813793forgets
frets85523403_fr_ets
gargets94614573gargets
garnets84115403garnets
garrets84413623garrets
garveys14124463garveys
genets75716663ge_nets
gerents82612923gerents
germens1078623germens
gorgets94711783gorgets
greets75117423_greets
grivets11357973grivets
gurnets84010793gurnets
harvest132112753harvest
harvests14246173harvests
heavens13439303heavens
heavers133717193heavers
heaves124120303heave_s
helmets12309073helmets
helves124316063helve_s
herders113914123herders
heres86245903her_e_s
hereto9313693her_eto
heriots10312063heriots
hermits12312143hermits
heroes94923823heroe_s
herpes115517323herpe_s
hornets104113553hornets
jarveys20123413jarveys
jennets14517633jennets
jereeds15326393jereeds
jerkers18287083jerkers
jerseys1733243jerseys
keets95123483ke__ets
keeves133711983keeve_s
kermes124616123kerme_s
kermess13396223kermess
kernels11417953kernels
kernes104717523kerne_s
kerseys1433993kerseys
kevels134410713ke_vels
keysets1434343keysets
leavens10409303leavens
leavers103717783leavers
leaves94222383leave_s
leets54927123le__ets
levees93714523le_vees
levels94113283le_vels
leverets11297603lever_ets
levers94621323le_vers
markets133314033markets
marvels123810093marvels
meets74224613me__ets
mercers114412773mercers
merces105720743merce_s
merdes94518603merde_s
meres75143573mer_e_s
merest84725113mer_est
mergees104411233mergees
mergers103813423mergers
merges94122483merge_s
merits8320873mer_its
merles85322763merle_s
merlots92710123merlots
nereis6315343ner_eis
nerts55924983ner__ts
nervate1039523nervate
nerve86617373nerve__
nerved104111683nerve_d
nerviest11188833nerviest
nervous1037143nervous
neves87021873ne_ve_s
overacts1339653overacts
overbeats14279823overbeats
overbet122716063overbet_
overcuts1337513overcuts
overeats112415263overeats
overheats15229993overheats
overlet102619033overlet_
overmelts1447263overmelts
overseas112612423overseas
oversees112415903oversees
overset102821473overset_
oversews14289423oversews
overviews1844283overviews
overvote1438953overvote
overvotes1538423overvotes
overwet132013933overwet_
pargets105215193pargets
peaveys15324063peaveys
peeves113814873peeve_s
pellets94014783pellets
pelmets11309693pelmets
pelves114514663pelve_s
percents122713373percents
percepts14247643percepts
peres76246643per_e_s
perfects15107353perfects
permits11314003permits
perpents122312043perpents
perses85428063perse_s
pertest9317043pertest
perverse1336103perverse
pervert12315583pervert
pervs105117373perv__s
presets94216423presets
prevents133012293prevents
privets122910053privets
purveys15615903purveys
reavers108320743reavers
reaves94127573reave_s
reeves94721493reeve_s
reflets103513153reflets
reglets83512983reglets
regreets9287853regreets
regrets83212923regrets
reivers105117083reivers
reives95723043reive_s
relets64025673re_lets
remeets93712413remeets
rennets75212633rennets
rerents73319423rerents
resets65427613re_sets
rets45352563__r_ets
revels94220573re_vels
revers94529633re_vers
reverts104715043re_verts
revest94623603re_vest
revests104413733re_vests
revet84938843re_vet_
rewets94617213re_wets
rivets94417113_rivets
secrets9311773secrets
selves94119613selve_s
sennets73712583sennets
septets998953septets
seres55448893ser_e_s
serest64831613ser_est
sergers83815633sergers
serges74225963serge_s
series64540973serie_s
serpents102410373serpents
servals103410743servals
servants1137993servants
serve85425963serve__
served104616813serve_d
server94917713serve_r
servos93812723serv_os
sestets7911473sestets
sevens93813663se_vens
severs94121123se_vers
sextets1497143sextets
sherbets1335213sherbets
sorbets93012513sorbets
sterlets8169273sterlets
streets73312613streets
surveys13357573surveys
swervers1455213swervers
swerves1377533swerve_s
swivets13436963swivets
targets84314223targets
telnets738373telnets
tenets65518953te_nets
tercels94110363tercels
terces83921413terce_s
tercet83624913tercet_
terete6319333ter_ete
termers95414503termers
ternes65422903terne_s
terret63425623terret_
territs72714503territs
tersest71713993tersest
trets55928023_tr_ets
trevet94818913trevet_
trivets103911583trivets
turrets73010673turrets
turves94212693turve_s
valets93715623v_alets
valves124113783valve_s
variers103712663variers
varies94330873varie_s
variety1337743variety
varlet9423503varlet_
varments1339063varments
varve115716853varve__
varved134110603varve_d
vealers103214293vealers
veepees1245813veepees
veeps104715723ve__eps
veeries102916893veerie_s
veers84521363ve__ers
vees75439433ve__e_s
veges94118863ve_ge_s
vegete1039483ve_gete
vegies104314273vegie_s
veilers103911823veilers
veiners104112523veiners
veinlets11144833veinlets
veldts10417753ve_ldts
velites103417303velites
velverets1543083velverets
velveted1533833velveted
vendees114011453vendees
venders113717003venders
veneers103710293veneers
venges104015143venge_s
venters103717733venters
vents86125933ve__nts
venues95115203venue_s
verbals121910743verbals
verbena1235373verbena
verbenas1345343verbenas
verbids13259203verbids
verbless1336033verbless
verbs104614393ver__bs
verdicts1446013verdicts
verdins112812333verdins
verge93419833verge__
verged114815153verge_d
verger104315693verge_r
verglas1137813verglas
verier94620963verie_r
verisms123011253verisms
verist93823893verist_
veritas103012753veritas
verite94323443ver_ite
verity123714853ver_ity
vermeil1285223vermeil
vermeils1374813vermeils
vermis114214963ver_mis
vermuth1543533vermuth
vermuths1642603vermuths
verniers11227843verniers
versants1137783versants
verse84723583verse__
versed104515513verse_d
verser94516963verse_r
versos93812803ver_sos
verst84429373ver_st_
verste94515633ver_ste
versus94211143ver_sus
vert77249373ver__t_
vertex1637373verte_x
vertexes18105633vertexes
vertu85017613ver__tu
vertus94613603ver_tus
vervain1335563vervain
vervains1435293vervains
vespers1239033vespers
vessels1035933vessels
vestees103513173vestees
vests85325983ve__sts
vetivers1435163vetivers
vetiverts1542343vetiverts
vetoers10359473vetoers
vetoes92914083vetoe_s
vets76835093___vets
vetters104016323vetters
vexers165210403ve_xers
vexes155719123ve_xe_s
violets102210003violets
vireos94212453vir_eos
vires84529683vir_e_s
vivers124717363v_ivers
weavers133714463weavers
weaves123616373weave_s
weets85427723we__ets
weevers13379993weevers
wergelts1253413wergelts
wherves16548053wherve_s
worsets105512843worsets
zeroes154314343zeroe_s

Search took 7 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 Limit1340274056.12321889.1
3Display Results4054050.1402892.9
 (SQL Overall)1786914056.66926794.3
 
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.