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

335 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
pugrees1021852(None) 
pugarees11195491pugarees
puggrees12194261puggrees
pugree92112471pugree_
purees84721681pu_rees
agrees74915322_agrees
burgees104915892burgees
degrees92810722degrees
grees65132472__grees
muggees11338882muggees
prees75937172p__rees
pugaree10208032pugaree_
puggarees13173042puggarees
puggree11176112puggree_
puggries12166382puggries
puree74632842pu_ree_
pureed95017812pu_reed
purgers104714002purgers
purges94421762pu_rges
purses84826372pu_rses
puttees93612912puttees
aggress935593aggress
agree65226033_agree_
agreed84712503_agreed
aigrets82810533aigrets
apogees1037103apog_ees
augers73818703aug_ers
augites8312183augites
augurers9114813augurers
auguries947933auguries
aures55137093au_r_es
aureus65314883au_reus
bargees105415873bargees
bourrees10127643bourrees
brees75632553__brees
bugeyes1335513bugeyes
buggers114315663buggers
buggies114613813buggies
buglers105115323buglers
bugles94822443bug_les
bugseed1136173bugseed
bugseeds1242843bugseeds
bungees104513103bungees
burets84321263bu_rets
burgee97120593burgee_
burgers103918573burgers
burgess10409343burgess
burgles105615963burgles
buries84633273bu_ries
burkes124421313bu_rkes
burrers93814493burrers
burses84425513bu_rses
curers84923193cu_rers
cures75645433cu_r_es
curets84922343cu_rets
curies84934023cu_ries
curries93723163curries
curses85328273cu_rses
curves114619283cu_rves
cuvees1139373cu_vees
decrees102513123decrees
degree82814853degree_
degreed10258883degreed
digress938323digress
drees65628523__drees
dungarees1143153dungarees
dures65635923du_r_es
duress74712063du_ress
durries83817353durries
eagres74014573eagr_es
egress73310433_egress
egrets72712243_egrets
entrees71813773entrees
frees86131393__frees
fugles104715783fug_les
fugues104511683fug_ues
fuhrers1334813fuhrers
furies95126373fu_ries
furzes186613693fu_rzes
fusees95416403fu_sees
fuzees184910753fu_zees
gees55647883__g_ees
ghees95215553__ghees
glees65027593__glees
grebes93813613__grebes
gree56641563__gree_
greed75125693__greed
greeds84314283__greeds
greek105915943__greek
green65522143__green
greens75716873__greens
greet65835323__greet
greets75117423__greets
greys96614853__greys
grues65721963__grues
guggles103410543guggles
guglets9369693guglets
gumtrees1143883gumtrees
gurges84716863gu_rges
gurgles94312873gurgles
gurries83515953gurries
hirees95117293_hirees
huggers124211593huggers
humvees1534683humvees
hurries103919653hurries
ingress838653ingress
juggles164510843juggles
jurels133710583ju_rels
juries134120633ju_ries
kugels1146073kug_els
larees65323113_larees
lucres84513303lucr_es
lugers74617023lug_ers
luges65928753lug__es
luggers93713483luggers
luggies93011213luggies
lungees84412143lungees
lurers64217493lu_rers
lures56138533lu_r_es
lurexes1436073lu_rexes
mergees104411233mergees
muggee103612833muggee_
muggers113611933muggers
mures75937213mu_r_es
murexes1636973mu_rexes
murres85019043mu_rres
murreys12367323murreys
murries94118673murries
mustees94614923mustees
nuggets936383nuggets
nurses63919353nu_rses
ogees65119143_og_ees
ogres65818633_ogr_es
ogress7529503_ogress
outsees72616433outsees
padres95016983padr_es
pagers94423253pag_ers
pages85235073pag__es
pareos87023773p_areos
parers85530743p_arers
pares77164483p_ar_es
pareses94718883p_areses
pareus85420743p_areus
parges94529543p_arges
pargets105215193pargets
paries84742513p_aries
parles86334403p_arles
parrels94713493parrels
parries93925843parries
parses85534703p_arses
pawnees12298173pawnees
payees114812903p_ayees
pedigrees1343373pedigrees
peeress939503peeress
peeries93623023peeries
pees65257373p___ees
peewees1236803peewees
pegless1038053pegless
pensees9311203pensees
peres76246643p_er_es
perries93226603perries
perses85428063p_erses
petrels9279373petrels
pewees11311393p_ewees
phereses1348093phereses
pierces113411193pierces
piggies113813483piggies
piglets103311793piglets
pigmies122610993pigmies
pigpens1235503pigpens
pigweed1465093pigweed
pigweeds1553143pigweeds
pluggers12297023pluggers
plugless1133863plugless
pogeys124110353pog_eys
pogies94123543pog_ies
pogroms1237643pogroms
pollees93215333pollees
pongees104212543pongees
pores75849033p_or_es
porgies103017003porgies
pourers93513673pourers
pree67044733p__ree_
preed85128123p__reed
preen75925053p__reen
preens85020113p__reens
preps96220693p__reps
prese75228383p__rese
press75425953p__ress
prexes154915953p__rexes
preys105717783p__reys
prezes173614693p__rezes
pries74339533p__ries
progress1137023progress
pubes94423403pu__bes
puces94924633pu__ces
puckers153514673puckers
puddles113613823puddles
puffers15349203puffers
puggaree12174333puggaree_
pugged114314533pug_ged
puggier11309383puggier
puggiest12219223puggiest
pugs76332773pug___s
puisnes937423puisnes
pukes114523023pu__kes
pulers83820283pu_lers
pules74538813pu__les
pullers93618483pullers
pullets94015163pullets
pulleys12399143pulleys
pulpers114612283pulpers
pulques1835323pulques
pulsers94213153pulsers
pulses83818663pu_lses
pumices1338273pumices
pummels13236543pummels
pumpers133113673pumpers
punches144816133punches
pungles104013713pungles
punkers133714853punkers
punkeys16366493punkeys
punkies134216803punkies
punners94114233punners
punnets9409263punnets
punters93617043punters
punties94520783punties
pupates113311433pupates
puppets10317013puppets
puppies103212613puppies
purdas92612263pu_rdas
pure65543333pu_r_e_
purely114013633pu_rely
pureness101110183pu_reness
purer75127903pu_r_er
purest84021933pu_rest
purfles122511843purfles
purge85324603pu_rge_
purged104918263pu_rged
purger94717233pu_rger
purines94420763purines
purins83722653pu_rins
puris75332023pu_r_is
purled94520753pu_rled
purls74723353pu_r_ls
purples112712833purples
purred94218073pu_rred
purrs75320433pu_r_rs
purs65641043pu_r__s
purse76028893pu_rse_
pursed95220883pu_rsed
purser85020473pu_rser
pursers93916093pursers
pursues94111373pursues
purvey14559573pu_rvey
purveys15615903purveys
puses75532203pu__ses
pushers123814503pushers
pushes114621663pu_shes
pusleys12286233pusleys
pusses84322843pu_sses
pussies93615693pussies
putrefies1444663putrefies
putrefy1543313putrefy
puttee85919723puttee_
putters94219193putters
putties94420023putties
putzes174212523pu_tzes
puzzles17318973puzzles
pygmies15205673pygmies
pyrenes123511223p_yrenes
pyres105523883p_yr_es
pyrexes19305843p_yrexes
quaeres163310843quaeres
quartes163314933quartes
queries16315873queries
quires154015743quir_es
ragees74618663rag_ees
raggees93710913raggees
rees45364193___rees
regreen8309043regreen
regreens9257453regreens
regreet83015953regreet
regreets9287853regreets
regress82711453regress
regrets83212923regrets
rugbies10339353rugbies
ruggers94612313ruggers
rupees8312573ru_pees
rushees103311953rushees
sarees65329943_sarees
screes85023963_screes
signees83510803signees
sirees64624583_sirees
sirrees73410573sirrees
soirees72411643soirees
sprees85620643_sprees
spurges104111653spu_rges
spurrers10338463spurrers
spurreys13364603spurreys
spurries102311323spurries
sucres84218893sucr_es
sugarers936303sugarers
supremes1238363supremes
surgers83517483surgers
surges73924593su_rges
surreys10489443surreys
suttees74114063suttees
threes97117323_threes
thuggees1343123thuggees
tigress836093tigress
trees55835763__trees
tuggers93711443tuggers
tugless837383tugless
tugriks1233153tugriks
tureen63312723tu_reen
tureens7289873tu_reens
turrets73010673turrets
turves94212693tu_rves
tutees6514553tu_tees
tuyeres10417793tuyeres
uglies7412323_uglies
unfrees1048643unfrees
unreel63612933_unreel
unreels7258313_unreels
updries10209083updries
upgazes1933573upgazes
upgrades12216063upgrades
upgrew1233653upgr_ew
upgrows1334323upgrows
uphroes1236303uphroes
ureas55826013_u_reas
urgers73313623_urgers
urges64619913_u_rges
yogees10510633yog_ees

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 Limit1340273357.03019065.0
3Display Results3353350.1262658.7
 (SQL Overall)1786913357.56223630.1
 
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.