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

373 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
veggies123755(None) 
veggie1136301veggie_
vegies104314271ve_gies
aggies83515512_aggies
baggies113814852baggies
biggies113813522biggies
buggies114613812buggies
doggies103613022doggies
jaggies163311082jaggies
leggier9368232leggier
leggiest10308232leggiest
leggins9259472leggins
luggies93011212luggies
moggies113111722moggies
piggies113813482piggies
raggies93214732raggies
reggaes948882reggaes
veeries102916892veeries
veges94118872ve_g_es
vegged124910022vegg_ed
vegging13308872vegging
vegie94614512ve_gie_
venges104015152veng_es
verges104320182verg_es
vuggier12296812vuggier
vuggiest13216922vuggiest
wedgies123910212wedgies
aegis6316783ae_gi_s
aegises8311373aegises
aeries64737783ae_ries
aggie73415013_aggie_
anergies9310453anergies
avenges1157543aveng_es
baggie102912193baggie_
baggier113611643baggier
baggiest123011753baggiest
beagles103212123beagles
beanies93821093beanies
beedies10314203beedies
begazes1937963begazes
beggaries1356233beggaries
beggars11378223beggars
begged115013813begg_ed
begging123012653begging
begins94415303be_gins
begrimes1376513begrimes
begrims1276763begrims
beguiles1146103beguiles
beguines11127213beguines
beiges91014413beig_es
beignes10149243beignes
belies84631053be_lies
bellies94023723bellies
bennies93917313bennies
berries94423553berries
bevies114017303be_vies
biggie103810933biggie_
biggins113410693biggins
boggier113711583boggier
boggiest123110933boggiest
boggles113411823boggles
bogies94724313_bogies
boogies103719013boogies
bougies103715183bougies
budgies115312513budgies
buggier113611343buggier
buggiest123410363buggiest
clergies1137903clergies
daggles103611913daggles
dearies83526273dearies
decries103319803decries
defies104624053de_fies
degames113312623degames
degases93413103degases
degrees92810723degrees
deifies113317453deifies
deities82621923deities
dellies83622213dellies
demies94825803de_mies
dengues938183dengues
denies74729643de_nies
derbies103016053derbies
derries83124623derries
dexies145018343de_xies
dingies93618243dingies
doggie93910893doggie_
doggier103810943doggier
doggiest113410523doggiest
dogies85022253_dogies
dreggier1193553dreggier
dreggiest12124543dreggiest
druggies11126223druggies
eagles73819163_eagles
eagres74014573_eagres
easies64126633_easies
eddies83313163_eddies
edges75718743_edg_es
edgier8469733_edgier
edgiest92310353_edgiest
eggars8398973_eggars
egged85114393_egg_ed
egger74414413_egg_er
eggers84612583_eggers
egging93210983_egging
eggless935663_eggless
eggs66516153_egg__s
egis56520653_e_gi_s
egises7312493_egises
elegies81312903elegies
energies9310783energies
engines81114463_engines
envies9314053_envies
espies83716803_espies
eyries93816813_eyries
faggier12309843faggier
faggiest132910183faggiest
fellies104119743fellies
ferlies103216693ferlies
ferries103521083ferries
foggier12349913foggier
foggiest13249653foggiest
fogies104118063_fogies
fuggier12348963fuggier
fuggiest13228813fuggiest
gaggles103512593gaggles
genies75324943ge_nies
gies55641423___gies
giggles103312933giggles
goggles103510793goggles
guggles103410543guggles
haggis11209513haggi_s
haggises1335883haggises
haggles123312483haggles
heavies132713873heavies
hedges115016263hedg_es
hedgier12367883hedgier
hedgiest13298133hedgiest
heinies102514543heinies
henges104516463heng_es
henries102718283henries
herries104025073herries
higgles123911803higgles
hoagies112811993hoagies
hogties112813993hogties
hongies112716473hongies
jaggier16339183jaggier
jaggiest17289323jaggiest
jellies143816533jellies
jemmies18318333jemmies
jennies143511623jennies
jerkies183411583jerkies
jerries143817513jerries
jetties143613123jetties
jiggier16377823jiggier
jiggiest17277693jiggiest
jiggles164111433jiggles
joggles164410413joggles
juggles164510843juggles
kebbies1537253kebbies
kedges124812983kedg_es
kegged13469263kegg_ed
kegger12388083kegg_er
keggers13357043keggers
kegging14328293kegging
kellies113516853kellies
kelpies13289903kelpies
kerries113317913kerries
kewpies16246923kewpies
leagues837943leagues
ledges84918013ledg_es
ledgier9458503ledgier
ledgiest10288593ledgiest
lefties10312073lefties
legacies1139043legacies
legates82917683legates
leges64427293le_g_es
legged95713093legg_ed
leggiero10342763leggiero
leggin8268593leggi_n
legginess1135033legginess
legging103912643legging
leggings11316193leggings
legits71313003le_gits
legumes1036633legumes
levies93919863le_vies
lezzies1536203lezzies
loggias9356783loggias
loggie84011993loggie_
loggier93811143loggier
loggiest103011013loggiest
longies82916553longies
luggie8318903luggie_
magpies12310363magpies
mealies92821933mealies
meanies93620743meanies
megrims1276103megrims
meinies92516073meinies
mercies113817563mercies
mergees104411233mergees
merges94122493merg_es
miggles113512033miggles
moggie103210103moggie_
muggees11338883muggees
muggier11288943muggier
muggiest12228533muggiest
muggins11248073muggins
naggier9309153naggier
naggiest102610013naggiest
neddies92710703neddies
negates83215843negates
negliges1034833negliges
neguses837933neguses
nellies73418723nellies
newbies12147423newbies
newies91014073ne_wies
newsies101310383newsies
niggles93512203niggles
noggins9288453noggins
noogies82814583noogies
ologies8615023ologies
orgies72316093_orgies
overlies112417043overlies
peages94321853peag_es
peavies122213403peavies
peeries93623023peeries
pegged114811913pegg_ed
pegging122811133pegging
pennies94218813pennies
peonies93620153peonies
perries93226603perries
piggie103210773piggie_
piggier113510003piggier
piggiest12259663piggiest
piggins113010473piggins
pigmies122610993pigmies
pogies94123543_pogies
porgies103017003porgies
puggier11309383puggier
puggiest12219223puggiest
puggries12166383puggries
pygmies15205673pygmies
raggees93710913raggees
raggles93813283raggles
readies83324713readies
reagins84215643reagins
redries83721713redries
reflies104418533reflies
refries104419733refries
regains84316583regains
regales83520793regales
reges65628793re_g_es
reggae858953reggae_
regimes104514743regimes
regius7311923re_gius
regives115014213regives
reglues838713reglues
reifies104218283reifies
relies65036423re_lies
remiges103015473remiges
replies94521043replies
reties65436193re_ties
retries74129073retries
rugbies10339353rugbies
saggier92912063saggier
saggiest102812723saggiest
sedges83817813sedg_es
sedgier9399053sedgier
sedgiest10259763sedgiest
seggars9377783seggars
segues7412073se_gues
selkies113513353selkies
serges74225973serg_es
series64540973se_ries
serries73925353serries
snuggies10246363snuggies
soggier93410883soggier
soggiest102711643soggiest
staggies101210323staggies
stogies8413693stogies
swaggies13136693swaggies
techies12513603techies
teddies92711283teddies
teggs74710743tegg__s
tekkies1035943tekkies
tellies73820503tellies
tennies73017973tennies
tergites9310543tergites
terries73425633terries
toggles93710973toggles
uglies7412323_uglies
vagaries12310293vagaries
varies94330873v_aries
vealier102712173vealier
vealiest112513203vealiest
veepees1245813veepees
vees75439433ve___es
vegans103910853ve_gans
vegete1039483vegete_
veils84918803ve__ils
veinier10269583veinier
veiniest1139383veiniest
veins84620493ve__ins
veliger1137313veliger
veligers1237023veligers
velites103417303velites
velures1039093velures
vendees114011453vendees
vendues11318623vendues
venenes102712133venenes
veneries112815033veneries
venge95117993veng_e_
venged114011993veng_ed
venging123710943venging
venines103516613venines
venins93816703ve_nins
venires103012453venires
venues95115203ve_nues
venules104011483venules
venuses103111413venuses
verbids13259203verbids
verbiles1338923verbiles
verdins112812333verdins
verge93419843verg_e_
verged114815163verg_ed
verger104315703verg_er
vergers114412633vergers
verging123812303verging
verglas1137813verglas
verier94620963ve_rier
veriest103719133ve_riest
verifies141313483verifies
verites103822263verites
verities111418043verities
vermes115019143ve_rmes
vermis114214963vermi_s
vernier102711273vernier
verniers11227843verniers
vernixes1836053vernixes
verses94223763ve_rses
versines112213823versines
verstes104014283verstes
vertices13612283vertices
verves124617883ve_rves
vespids1334613vespids
vestees103513173vestees
vestiges1238243vestiges
vestries11314053vestries
vetches153411263vetches
vetoes92914083ve_toes
vexes155719123ve__xes
vexils1647173ve_xils
vichies15310623vichies
vies75238623v___ies
vigias104110893v_igias
vigils104210193v_igils
virgins1137863virgins
vogie95116663v_ogie_
vogues104011923v_ogues
vuggs10579133vugg__s
waggles123812003waggles
wearies103020223wearies
wedges114614583wedg_es
wedgie11428373wedgie_
wedgier12428283wedgier
wedgiest13307983wedgiest
weenies102915093weenies
weepies122811743weepies
wellies103719073wellies
wiggier12418863wiggier
wiggiest13269013wiggiest
wiggles123312463wiggles
yeggmen1442673yeggmen
yeggs10608163yegg__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.406440125.6
2DLD Change Limit1340273736.76619808.9
3Display Results3733730.1402664.3
 (SQL Overall)1786913737.31224438.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.