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 “pyes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

348 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
pyes9552899(None) 
ayes76543511ayes
byes95230531byes
dyes85331891dyes
eyes75837881eyes
kyes115124931kyes
lyes75530831lyes
oyes74940131oyes
pees65257371pees
pes57259781p_es
pies66949601pies
pyas96225701pyas
pye86432501pye_
pyres105523881pyres
pyxes175911401pyxes
ryes75529351ryes
tyes76433371tyes
wyes105727501wyes
yes66250611_yes
abyes105518532abyes
aces67645092aces
ages55844592ages
ales47067102ales
anes45255932anes
apes66047432apes
apres75426402apres
apses76823912apses
ares45871022ares
ates45047922ates
aves76142602aves
awes76037552awes
axes117337852axes
aye67151762aye_
ays67050292ay_s
bees65453382bees
bes56557432_bes
beys913829552beys
bye86134592bye_
byres104421382byres
bys85229462by_s
bytes105217492bytes
cees65941592cees
cues65438982cues
cymes1210118922cymes
dees56356632dees
deys85027472deys
dies55653522dies
does56554472does
dues56045502dues
dye75334842dye_
dyed96720762dyed
dyer85522112dyer
dyers96617132dyers
dykes135215572dykes
dynes95917582dynes
ekes86726602ekes
emes65434662emes
epees75219832epees
es29048222__es
eses45336102eses
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyers86521332eyers
eyres84921772eyres
fees76450602fees
fes66551672_fes
foes76543442foes
fyces139813642fyces
fykes156312692fykes
gaes56348032gaes
gees55647882gees
gies55641422gies
goes55644092goes
gybes115012722gybes
gyms107514592gyms
gyps105115022gyps
gyres94820322gyres
gyves125711552gyves
haes77651022haes
hes66654202_hes
hies74842832hies
hoes75755732hoes
hues75235232hues
hypes135818672hypes
hyps125418412hyps
ices66129642ices
ides57734232ides
ires45639282ires
jees115938542jees
joes116635892joes
kaes85734062kaes
keys116322162keys
kues86426772kues
kye107327272kye_
kytes125012912kytes
lees45455882lees
les35663072_les
leys76430182leys
lies46454192lies
lues45943552lues
lye66533412lye_
lyres85019962lyres
lyse76320592lyse
lyses84518252lyses
maes66948392maes
mycs115314292mycs
noes45845392noes
obes66036832obes
odes57243242odes
oes35866192_oes
okes84936342okes
oles46453472oles
ones46146532ones
opes65942612opes
ores46056682ores
oses46641512oses
owes75137102owes
oxes116530722oxes
oyer75927652oyer
oyers87620882oyers
oyez166020352oyez
paces96741112paces
pacs85842182pacs
pads76742952pads
pages85235072pages
pales75753802pales
pals66951352pals
pams85641762pams
panes76148692panes
pans65855722pans
paps86443452paps
pares77164482pares
pars67560792pars
pas58775742p_as
pase65346862pase
pases75346502pases
pass65239952pass
pates76047892pates
pats66460852pats
paves104833922paves
paws96038182paws
paxes144928422paxes
payed115925932payed
payee105524722payee
payees114812902payees
payer105125722payer
payers114621822payers
pays95940222pays
pe47649032p_e_
pea56657242p_ea
peas65755062peas
pec76744412p_ec
pecs84634102pecs
ped66751522p_ed
pedes85327282pedes
peds75835242peds
pee56066512p_ee
peed76239182peed
peek106031432peek
peeks115021112peeks
peel65535612peel
peels75226422peels
peen65938082peen
peens76428192peens
peep85833692peep
peeps95822362peeps
peer66238352peer
peers75130272peers
peg65843062p_eg
pegs75531762pegs
peh86740962p_eh
pehs95625762pehs
pekes114623562pekes
peles75738082peles
pen56558842p_en
penes75839222penes
pens65649642pens
pep76447082p_ep
peps85134512peps
per56353092p_er
peres76246642peres
peso66925822p_eso
pest65555292p_est
pet56477302p_et
pets66248332pets
pew86442302p_ew
pews95731532pews
phew128417112phew
phis95724902phis
physes14399782physes
pias66542552pias
pics85633912pics
pie55457402pie_
pied75035362pied
pier66035292pier
piers75926332piers
pigs76634222pigs
pikes115031032pikes
piles74742612piles
pines76048862pines
pins65558452pins
pipes96030142pipes
pips85837132pips
pis56362032p_is
piss65033332piss
pits66348742pits
pixes144323172pixes
plea66830602plea
pleas75627032pleas
pleb86123812pleb
plebs95814582plebs
pled75231432pled
plew97222812plew
plews105415352plews
plex137321372plex
plies74526512plies
plus66324832plus
plyer106214332plyer
plyers114912982plyers
pods76540152pods
poem86225772poem
poems95715552poems
poesy105014062poesy
poet65552902poet
poets76024442poets
pois66539042pois
pokes116133012pokes
poles75351002poles
pols66044562pols
pomes94833932pomes
poms87037742poms
pones74547042pones
pons65850602pons
poos65949112poos
popes95933812popes
pops86340952pops
pores75849032pores
pose66441732pose
poses74642762poses
pots66452362pots
pows95537662pows
poxes145325722poxes
pree67044732pree
prees75937172prees
prep86427672prep
preps96220692preps
presa74319042presa
prese75228382prese
press75425952press
prest75736352prest
prex135722972prex
prey96228482prey
preys105717782preys
prez156126312prez
pries74339532pries
pros65742782pros
pryer104415312pryer
pryers115012242pryers
psis68120342psis
pubes94423402pubes
pubs85029212pubs
puces94924632puces
puds75630512puds
pugs76332772pugs
pukes114523022pukes
pules74538812pules
puls65437562puls
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842p_us
puses75532202puses
puss64830132puss
puts65641752puts
pya87023752py_a
pyic116915822pyic
pyin96823232pyin
pyins105815862pyins
pyoses114314302pyoses
pyre94925552pyre
pyrex175211212pyrex
pyro96019392pyro
pyros105718292pyros
pyx157817012py_x
pyxies18338292pyxies
pyxis17458632pyxis
rees45364192rees
res35565042_res
roes45954132roes
rues46044482rues
ryas77224612ryas
rye66032542rye_
rykes125513032rykes
sees45361052sees
shes75734352shes
snyes85012752snyes
spaes76029972spaes
spies76037622spies
spues75025382spues
styes86316522styes
sues46247652sues
syces106416462syces
sykes124816862sykes
tees45353582tees
ties45248312ties
toes46956442toes
tres46542902tres
tye65837442tye_
tyee75131422tyee
tyees86019452tyees
tyer75323392tyer
tyers86220052tyers
tykes125817062tykes
tynes85920302tynes
types105721062types
tyres84725232tyres
ukes86122812ukes
uses44931112uses
utes45930882utes
vees75439432vees
vies75238622vies
voes75432822voes
waes76048602waes
wees76249122wees
woes76440662woes
wye96331972wye_
wyles114615322wyles
wyns105717032wyns
wytes114113432wytes
ye57650062_ye_
yea66445752_yea
yeas78638422_yeas
yeh97135772_yeh
yen66847382_yen
yens75832262_yens
yep86638962_yep
yeps95924402_yeps
yet66960692_yet
yew96436292_yew
yews105323962_yews
zees136331892zees
zymes1924712942zymes

Search took 1 second 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 Filter178691298720.0602978183.3
2DLD Change Limit298723480.72041488.9
3Display Results3483480.0933741.9
 (SQL Overall)1786913480.873204686.1
 
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.