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

238 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
ryas7722461(None) 
eyas76427431eyas
pyas96225701pyas
ras37575391r_as
rayas85922051rayas
rays77642351rays
rias45540591rias
rya67622011rya_
ryes75529351ryes
aas310975392_aas
abas68642082abas
agas55938842agas
alas46358122alas
amas67746292amas
anas46649862anas
areas55935772areas
arias55438022arias
arras55626132arras
aryls87015812aryls
as211083072__as
ayah108022992ayah
ayahs116813522ayahs
ayes76543512ayes
ays67050292ay_s
baas66844672baas
bas58681752_bas
bays97143912bays
bias64738152bias
boas66150832boas
bras65746452bras
brays106723112brays
byes95230532byes
bys85229462by_s
cays95437672cays
cyan96419622cyan
cyans105714812cyans
cycas126513822cycas
cymas126417882cymas
days87637132days
drays95819772drays
dryad10477582dryad
dryads11436622dryads
drys86314802dry_s
dyad96415452dyad
dyads10549972dyads
dyes85331892dyes
eras45441502eras
etas46432272etas
eyass84410782eyass
eyes75837882eyes
eyras84715922eyras
fas68262932_fas
fays108535362fays
frays116920102frays
gas48870252_gas
gays87338022gays
goas55239942goas
grays95621332grays
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
mas58175812_mas
mayas105924382mayas
mays96940022mays
moas65545342moas
mycs115314292mycs
mynas105815232mynas
nays75931592nays
obas65730932obas
ocas66729632ocas
odas57230262odas
okas85225392okas
orcas75918622orcas
oyes74940132oyes
pas58775742_pas
pays95940222pays
peas65755062peas
pias66542552pias
prays105022432prays
proas75028802proas
pya87023752pya_
pyes95528992pyes
rad47662002r_ad
rads56046602rads
rag45761322r_ag
ragas65326062ragas
rags55448372rags
rah68052402r_ah
rai37658222r_ai
raias54631122raias
rais45252622rais
raj105740222r_aj
rajas127317722rajas
ram56867272r_am
rams65950772rams
ran38266612r_an
rap56261962r_ap
raps66247732raps
rase46149982r_ase
rash76039932r_ash
rasp66029162r_asp
rat37892742r_at
rats46260372rats
raw67252252r_aw
raws75238212raws
rax108445722r_ax
ray66361992r_ay
raya75224822raya
rayah116013502rayah
rayahs12579192rayahs
read55942532read
reads64835272reads
real45750292real
reals55038652reals
ream65841612ream
reams75729622reams
reap65934742reap
reaps75626192reaps
rear45644552rear
rears54739652rears
rebs65733562rebs
recs65734182recs
reds56042862reds
rees45364192rees
refs75732242refs
regs55436572regs
reis45343232reis
rems66237722rems
reps65937952reps
res35565042r_es
rets45352562rets
revs75027052revs
rheas84816952rheas
rhos76319062rhos
rhus75114052rhus
ria36745502ria_
rial45938092rial
rials55026672rials
ribs65833012ribs
rids56539542rids
rifs74929002rifs
rigs55137592rigs
rims65936302rims
rins46153192rins
rips66237432rips
riyal84413432riyal
riyals94111082riyals
road56332112road
roads66523612roads
roam67132412roam
roams74919612roams
roan47234202roan
roans54926442roans
roar46328572roar
roars55622232roars
roast56230142roast
robs65837872robs
rocs65533662rocs
rods56442062rods
roes45954132roes
roms67038962roms
rotas54827722rotas
rots46454092rots
rows75941752rows
royal85014702royal
royals93711262royals
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
ruts44541492ruts
rye66032542ry_e
ryke115616402ryke
rykes125513032rykes
rynd86414102rynd
rynds9569972rynds
ryot75528562ryot
ryots85313782ryots
says75942102says
seas45755272seas
skas85325712skas
soyas84520912soyas
spas67036722spas
tas38477102_tas
teas45851492teas
trays85623432trays
twas76824082twas
tyes76433372tyes
upas68322382upas
ureas55826012ureas
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.0632836365.1
2DLD Change Limit298722380.90632971.3
3Display Results2382380.0465173.9
 (SQL Overall)1786912381.015176050.2
 
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.