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

408 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
pugree9211247(None) 
pugaree10208031pugaree
puggree11176111puggree
pugrees10218521pugrees
puree74632841pu_ree
agree65226032_agree
burgee97120592burgee
degree82814852degree
gree56641562__gree
muggee103612832muggee
pree67044732p__ree
pugarees11195492pugarees
puggaree12174332puggaree
pugged114314522pugged
puggrees12194262puggrees
pure65543332pu_r_e
pureed95017802pu_reed
purees84721682pu_rees
purer75127902pu_rer
purge85324602pu_rge
purged104918262purged
purger94717232purger
purges94421762purges
purred94218072purred
purse76028892pu_rse
puttee85919722puttee
upgrew1233652upgrew
agee56241493_ag_ee
aglee65728493_aglee
agreed84712503_agreed
agrees74915323_agrees
aigret73720023aigret
apogee9312553apog_ee
auger64922473aug_er
augers73818703augers
augite7312613augite
augured987193augured
augurer8136343augurer
aurae54128113au_rae
aurei54821863au_rei
aures55137093au_res
bargee94624443bargee
bourree91311343bourree
bree67241263__bree
bugeye1236533bugeye
bugged114318403bugged
bugger104418723bugger
bugle84721943bug_le
bugled104918133bugled
bugler94717723bugler
bugles94822443bugles
bugseed1136173bugseed
bungee96319773bungee
buret77444013bu_ret
burgees104915893burgees
burger94020793burger
burgle94815863burgle
burke115122763bu_rke
burred95820723burred
burrer83718473burrer
burse75527253bu_rse
cure66149123cu_r_e
cured85932133cu_red
curer75030753cu_rer
cures75645433cu_res
curet75447643cu_ret
curie74533043cu_rie
curred94319263curred
currie84317263currie
curse75829143cu_rse
curve104920023cu_rve
cuvee10316143cu_vee
decree93117783decree
degreed10258883degreed
degrees92810723degrees
dree56638323__dree
dungaree1045613dungaree
dure56341813du_r_e
dured75025403du_red
dures65635923du_res
durrie73713263durrie
eagre64315323eagr_e
eagres74014573eagres
egret63327313_egret
entree61817883entree
free75940183__free
fugged124615383fugged
fugle94915543fug_le
fugled114813693fugled
fugles104715783fugles
fugue94313373fug_ue
fugued11478713fugued
fugues104511683fugues
fuhrer1235033fuhrer
furred104514433furred
furze176815813fu_rze
fusee86224583fu_see
fuzee175718883fu_zee
gee45359203__g_ee
ghee85726113__ghee
glee55239063__glee
grebe85114943__grebe
greed75125693__greed
greek105915943__greek
green65522143__green
grees65132473__grees
greet65835323__greet
grew85620263__grew
grey85624043__grey
grue55825713__grue
guggle94110433guggle
guglet84018223guglet
gumtree1045873gumtree
gurge75419783gu_rge
gurged95513363gurged
gurges84716863gurges
gurgle83912473gurgle
hiree85427803_hiree
huge86321653hug__e
huger94914873hug_er
hugged124113643hugged
hugger114713123hugger
humvee1439203humvee
jugate14379463jugate
jugged163813933jugged
juggle154310283juggle
jurel124516333ju_rel
kugel1068563kug_el
laree56036293_laree
lucre76415523lucr_e
lucres84513303lucres
luge55531643lug__e
luged74019093lug_ed
luger65322083lug_er
lugers74617023lugers
luges65928753lug_es
lugged94417053lugged
lugger83916553lugger
luggie8318903luggie
lungee75119813lungee
lure45142463lu_r_e
lured65427493lu_red
lurer54625313lu_rer
lures56138533lu_res
lurex124816733lu_rex
maugre9308973maugr_e
mergee94018133mergee
mugged114113833mugged
muggees11338883muggees
mugger103914703mugger
mure65941333mu_r_e
mured85726703mu_red
mures75937213mu_res
murex145517173mu_rex
murre74821073mu_rre
murres85019043murres
murrey114312253murrey
mustee83922103mustee
ngwee9311073_ngwee
nugget8311723nugget
nurse54420123nu_rse
ogee57629883_og_ee
ogre56320743_ogr_e
ogres65818633_ogres
ourie54027303ou_rie
outgrew1136713outgrew
outre53922203outr_e
outsee63121803outsee
padre86018163padr_e
padres95016983padres
page76036103pag__e
paged95926783pag_ed
pager84728203pag_er
pagers94423253pagers
pages85235073pag_es
paired95017523paired
parae76335703p_arae
pardee93922023pardee
pare66760843p_ar_e
pared86946763p_ared
pareo74632603p_areo
parer75839903p_arer
pares77164483p_ares
pareu74928743p_areu
pareve114613013p_areve
parge85831853p_arge
parged104922033parged
parges94529543parges
parget94529393parget
parle75836163p_arle
parred95024073parred
parrel84515983parrel
parse75236993p_arse
parve109824853p_arve
passee84522023passee
pattee84323383pattee
pawnee113115403pawnee
payee105524723p_ayee
pedigree1244883pedigree
pee56066513p___ee
peered93819483peered
peerie83617893peerie
peewee11311963peewee
pegged114811903pegged
pensee8417313pensee
pere66450263p_er_e
perea75026443p_erea
peres76246643p_eres
perse75429523p_erse
petrel83111533petrel
pewee10319973p_ewee
pierce104010393pierce
pigged114214153pigged
piggie103210773piggie
piglet93420923piglet
pigpen1136583pigpen
pigweed1465093pigweed
plugged12408033plugged
plugger11378423plugger
pogey116017893pog_ey
pogies94123543pogies
pogrom1138593pogrom
pollee83623273pollee
pommee122813283pommee
pongee94920193pongee
poorer82613993poorer
pore66451263p_or_e
pored85234513p_ored
pores75849033p_ores
poured95116743poured
pourer84516043pourer
preed85128113p__reed
preen75925053p__reen
prees75937173p__rees
prep86427673p__rep
prese75228383p__rese
prex135722973p__rex
prey96228483p__rey
prez156126313p__rez
pubes94423403pu_bes
puce85127883pu__ce
puces94924633pu_ces
pucker143817633pucker
puddle103914153puddle
pudgier11377723pudgier
puerile9310093puerile
puffed153510603puffed
puffer144610733puffer
pug65337183pug___
puggarees13173043puggarees
puggier11309383puggier
puggries12166383puggries
puggry13374823puggry
puggy124612323pug_gy
pugh106619233pug__h
pugs76332773pug__s
puisne856353puisne
puke105025463pu__ke
puked124716223pu_ked
pukes114523023pu_kes
pule65040953pu__le
puled84926523pu_led
puler74826623pu_ler
pulers83820283pulers
pules74538813pu_les
pulled94322193pulled
puller83820813puller
pullet84026333pullet
pulley113713403pulley
pulped114612533pulped
pulper103513273pulper
pulque1736213pulque
pulse74219973pu_lse
pulsed94013723pulsed
pulser84215193pulser
pulses83818663pulses
pumice1238223pumice
pummel12278043pummel
pumped133915563pumped
pumper124415553pumper
pungle94413573pungle
pungled114210083pungled
pungles104013713pungles
punier84519223punier
punker123718823punker
punkey154011173punkey
punkie123513613punkie
punned93416193punned
punner84918153punner
punnet83518843punnet
punted94618713punted
punter84320023punter
pupae96515643pu_pae
pupate104213123pupate
pupped105013273pupped
puppet93514593puppet
pur56840553pu_r__
purda82914693pu_rda
purely114013613pu_rely
purest84021933pu_rest
purfle112511183purfle
purgers104714003purgers
puri65931443pu_r_i
purin75527593pu_rin
purine85321893purine
puris75332023pu_ris
purl65631423pu_r_l
purled94520743purled
purls74723353pu_rls
purple102712673purple
purr64925813pu_r_r
purrs75320433pu_rrs
purs65641043pu_r_s
pursed95220883pursed
purser85020473purser
purses84826373purses
pursue84512253pursue
pursy105016413pu_rsy
purty105019403pu_rty
purvey14559573purvey
puses75532203pu_ses
pushed125017463pushed
pusher114318283pusher
pushes114621663pushes
pusley11379613pusley
pusses84322843pusses
putrefy1543313putrefy
putrid9311173putrid
putted94220253putted
puttees93612913puttees
putter83921443putter
puttie84116303puttie
putzed18409113putzed
putzes174212523putzes
puzzle16318603puzzle
pyre94925553p_yr_e
pyrene113210733p_yrene
pyres105523883p_yres
pyrex175211213p_yrex
quaere154110673quaere
quare143920543quar_e
quarte154115323quarte
quire144917123quir_e
quired163711943quired
quires154015733quires
ragee65432663rag_ee
raggee84217603raggee
ree37974073___ree
regreen8309043regreen
regreet83015953regreet
regret73723533regret
regrew10388563regrew
rugae65114763rug_ae
rugate75813813rugate
rugged94215373rugged
rugger84414513rugger
rugose737283rugose
rupee7321283ru_pee
rushee93818773rushee
saree55044663_saree
scree720031703_scree
signee73617233signee
siree55238813_siree
sirree64017333sirree
soiree62919483soiree
spree74830863_spree
spurge93711323spu_rge
spurges104111653spurges
spurred103610613spurred
spurrer93710213spurrer
spurrey12307803spurrey
sucre75019103sucr_e
sucres84218893sucres
sugared938583sugared
sugarer837323sugarer
sughed113610203sughed
supreme1137893supreme
sure45447413su_r_e
surer54833093su_rer
surge65027693su_rge
surged84118883surged
surger74320093surger
surges73924593surges
surrey94414573surrey
suttee63721543suttee
three87526913_three
thuggee1245263thuggee
tree47745813__tree
tugged93813523tugged
tugger84013103tugger
tugrik1134283tugrik
tureen63312723tu_reen
turret63121853turret
tutee5423523tu_tee
tuyere9408613tuyere
undee65327273_undee
unfree9413203unfree
unreel63612933_unreel
upgaze1833543upgaze
upgrade11215823upgrade
upgrow1234273upgrow
uphroe1136083uphroe
urea46528053_u_rea
urge54722413_u_rge
urged75316033_urged
urger64116473_urger
urges64619913_urges
yogee9518063yog_ee

Search took 10 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127164088.53013214.1
3Display Results4084080.2661533.8
 (SQL Overall)1786914088.95219961.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.