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

262 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
pyas9622570(None) 
eyas76427431eyas
pas58775741p_as
pays95940221pays
peas65755061peas
pias66542551pias
pya87023751pya_
pyes95528991pyes
ryas77224611ryas
aas310975392_aas
abas68642082abas
agas55938842agas
alas46358122alas
amas67746292amas
anas46649862anas
as211083072__as
ayah108022992ayah
ayahs116813522ayahs
ayes76543512ayes
ays67050292ay_s
baas66844672baas
bas58681752_bas
bays97143912bays
bias64738162bias
boas66150832boas
bras65746452bras
byes95230532byes
bys85229462by_s
cays95437672cays
cyan96419622cyan
cyans105714812cyans
cycas126513822cycas
cymas126417882cymas
days87637132days
dyad96415452dyad
dyads10549972dyads
dyes85331892dyes
ephas10311542ephas
eras45441502eras
etas46432272etas
eyass84410782eyass
eyes75837882eyes
eyras84715922eyras
fas68262932_fas
fays108535362fays
gas48870252_gas
gays87338022gays
goas55239942goas
gyms107514592gyms
gyps105115022gyps
has67372652_has
hays106138072hays
hoyas115016162hoyas
hylas114815902hylas
hyps125418412hyps
jays146328342jays
kaas86531842kaas
kas77058582_kas
kays116032192kays
keas86337092keas
koas85635092koas
kvas117015942kvas
kyak105213632kyak
kyaks11459162kyaks
kyar116916842kyar
kyars124813962kyars
kyat116025522kyat
kyats125012442kyats
kyes115124932kyes
las37281472_las
lays76043252lays
leas45954182leas
lyase85512412lyase
lyes75530832lyes
mas58175822_mas
mayas105924382mayas
mays96940032mays
moas65545342moas
mycs115314292mycs
mynas105815232mynas
nays75931592nays
obas65730932obas
ocas66729632ocas
odas57230262odas
okas85225392okas
oyes74940132oyes
pa410456482p_a_
pac79054082p_ac
pacas96029402pacas
pacs85842182pacs
pad68057322p_ad
pads76742952pads
pah88853592p_ah
pal56761672p_al
pals66951352pals
pam77858392p_am
pams85641762pams
pan58466452p_an
pans65855732pans
pap76758402p_ap
papas94927492papas
paps86443452paps
par57467022p_ar
paras76143042paras
pars67560792pars
pase65346862p_ase
pash95638132p_ash
pass65239952pass
past65959012p_ast
pat58089462p_at
pats66460852pats
paw87651172p_aw
paws96038182paws
pax127346852p_ax
pay88461182p_ay
pea56657242pea_
peag75431342peag
peags86122842peags
peak106535202peak
peaks114825622peaks
peal68648102peal
peals75235492peals
pean66147172pean
peans75437642peans
pear69745232pear
pears75138612pears
pease75231112pease
peat65967932peat
peats76140192peats
pecs84634102pecs
peds75835242peds
pees65257372pees
pegs75531762pegs
pehs95625762pehs
pens65649642pens
peps85134512peps
pes57259782p_es
pets66248332pets
pews95731532pews
phase104617212phase
phat95837862phat
phis95724902phis
pia56848032pia_
pial65636702pial
pian66136092pian
pians75126962pians
picas94626522picas
pics85633912pics
pies66949602pies
pigs76634222pigs
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pins65558452pins
pips85837132pips
pis56362032p_is
piss65033332piss
pitas77427672pitas
pits66348742pits
plan65833942plan
plans75731272plans
plash104616562plash
plasm94114632plasm
plat66048872plat
plats75531372plats
play95928982play
playas114612282playas
plays106320772plays
pleas75627032pleas
plus66324832plus
pods76540152pods
pois66539042pois
pols66044562pols
poms87037742poms
pons65850602pons
poos65949112poos
pops86340952pops
pots66452362pots
pows95537662pows
pram85733492pram
prams96125512prams
prao66229022prao
praos74923562praos
prase76128752prase
prat65952042prat
prats76333392prats
prau66529472prau
praus74621752praus
pray96331532pray
prays105022432prays
proas75028802proas
pros65742782pros
psis68120342psis
psoas75012982psoas
pubs85029212pubs
puds75630512puds
pugs76332772pugs
pujas145513322pujas
puls65437562puls
pumas95121562pumas
punas74826752punas
puns66641482puns
pupas95219282pupas
pups86032232pups
purs65641042purs
pus55547842p_us
puss64830132puss
puts65641752puts
pye86432502py_e
pyic116915822pyic
pyin96823232pyin
pyins105815862pyins
pyran10514472pyran
pyrans11411062pyrans
pyre94925552pyre
pyres105523882pyres
pyro96019392pyro
pyros105718292pyros
pyx157817012py_x
pyxes175911402pyxes
pyxis17458632pyxis
ras37575392_ras
rayas85922052rayas
rays77642352rays
rias45540592rias
rya67622012rya_
ryes75529352ryes
says75942102says
seas45755272seas
skas85325712skas
soyas84520912soyas
spas67036722spas
spays105520512spays
tas38477102_tas
teas45851492teas
twas76824082twas
tyes76433372tyes
upas68322382upas
utas45924952utas
vas67755772_vas
was68767562_was
ways107737952ways
wyes105727502wyes
wyns105717032wyns
ya510251502_ya_
yag76947732_yag
yags86632292_yags
yah99046352_yah
yak107038562_yak
yaks116025202_yaks
yam87448992_yam
yams95330732_yams
yap85949822_yap
yaps95933522_yaps
yar67253832_yar
yaw97145152_yaw
yaws105531212_yaws
yay96948712_yay
yays105728912_yays
yeas78638422yeas
yes66250612_yes
zas126946832_zas

Search took 2 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 Filter178691298720.390458182.1
2DLD Change Limit298722621.00029872.0
3Display Results2622620.0803275.0
 (SQL Overall)1786912621.470121558.5
 
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.