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

221 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
eyas7642743(None) 
eras45441501eras
etas46432271etas
eyass84410781eyass
eyes75837881eyes
eyras84715921eyras
pyas96225701pyas
ryas77224611ryas
yeas78638421yeas
aas310975392_aas
abas68642082abas
agas55938842agas
alas46358122alas
amas67746292amas
anas46649862anas
as211083072__as
ayah108022992ayah
ayahs116813522ayahs
ayes76543512ayes
ays67050292ay_s
baas66844672baas
bas58681752_bas
bays97143912bays
bemas96424282bemas
betas75528762betas
beys913829552bey_s
bias64738152bias
boas66150832boas
bras65746452bras
byes95230532byes
bys85229462by_s
cays95437672cays
cyan96419622cyan
cyans105714812cyans
cycas126513822cycas
cymas126417882cymas
days87637132days
degas75119162degas
devas96218882devas
deys85027472dey_s
dyad96415452dyad
dyads10549972dyads
dyes85331892dyes
ear36867882e_ar
ears46356592ears
ease45042332e_ase
east46659102e_ast
easy76224492e_asy
eat36989052e_at
eats47054872eats
eau37450942e_au
ebbs82411982ebbs
ecus65421462ecus
edhs86212102edhs
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
egad64215412egad
egads74610922egads
egal55119432egal
eggs66516152eggs
egis56520652egis
egos55821652egos
ekes86726602ekes
elan46734242elan
elans55527752elans
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
ems56435492e_ms
emus66821682emus
emyds1144922emyds
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
ephas10311542ephas
epos66723732epos
era35741502era_
erase54925492erase
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
eta35834192eta_
eths76619522eths
etnas54713932etnas
eves76230462eves
ewes76328702ewes
exam132514622exam
exams14199082exams
exes116530812exes
eyases94513682eyases
eye65539772ey_e
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyers86521332eyers
eyne76322462eyne
eyra76217552eyra
eyre75525252eyre
eyres84921772eyres
eyry106315882eyry
fas68262932_fas
fays108535362fays
fetas85624402fetas
gas48870252_gas
gays87338022gays
getas65421482getas
goas55239942goas
gyms107514592gyms
gyps105115022gyps
has67372652_has
hays106138072hays
hoyas115016162hoyas
hylas114815902hylas
hyps125418412hyps
jays146328342jays
kaas86531842kaas
kas77058582_kas
kays116032192kays
keas86337092keas
keys116322162key_s
koas85635092koas
kvas117015942kvas
kyak105213632kyak
kyaks11459162kyaks
kyar116916842kyar
kyars124813962kyars
kyat116025522kyat
kyats125012442kyats
kyes115124932kyes
las37281472_las
lays76043252lays
leas45954182leas
leys76430182ley_s
lyase85512412lyase
lyes75530832lyes
mas58175812_mas
mayas105924382mayas
mays96940022mays
mesas76823202mesas
moas65545342moas
mycs115314292mycs
mynas105815232mynas
nays75931592nays
nemas75321572nemas
obas65730932obas
ocas66729632ocas
odas57230262odas
okas85225392okas
oyes74940132oyes
pas58775742_pas
pays95940222pays
peas65755062peas
pias66542552pias
pya87023752pya_
pyes95528992pyes
ras37575392_ras
rayas85922052rayas
rays77642352rays
rias45540592rias
rya67622012rya_
ryes75529352ryes
says75942102says
seas45755272seas
skas85325712skas
soyas84520912soyas
spas67036722spas
tas38477102_tas
teas45851492teas
tepas76521682tepas
texas126514932texas
twas76824082twas
tyes76433372tyes
upas68322382upas
utas45924952utas
vas67755772_vas
was68767562_was
ways107737952ways
wekas123911792wekas
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
yea66445752yea_
yeah106725412yeah
yeahs115214552yeahs
yean75834582yean
yeans86624882yeans
year76534252year
years84527672years
yeast85327942yeast
yens75832262yens
yeps95924402yeps
yes66250612_yes
yews105323962yews
zas126946832_zas
zetas145018162zetas

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.0802233637.5
2DLD Change Limit298722211.68617717.7
3Display Results2212210.0932376.3
 (SQL Overall)1786912211.85996122.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.