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

411 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
onlays939871(None) 
inlays9389871inlays
onlay84212941onlay_
unlays93810491unlays
allays94313742allays
anlas55626932anla_s
belays114313852belays
clays105521332_clays
delays104014052delays
flays116321052_flays
inlay85214322inlay_
lays76043252__lays
nays75931592_n_ays
nongays11176532nongays
nonplays1344892nonplays
noways12127732noways
ofays11488922o_fays
oilways1334872oilways
okays12609442o_kays
ollas54218282olla_s
onloads8246672onloads
only75319722onl_y_
outlays102610902outlays
plays106320772_plays
relays94316752relays
slays85723682_slays
splays114910872splays
unlay84613702unlay_
unsays9399542unsays
alans55636173_alans
alas46358123_ala_s
allay85620393allay_
alleys95113303alleys
alloys94014563alloys
always12409133always
analyse10208893analyse
analyst10189323analyst
anas46649863an_a_s
anears63717183anears
angas65827983anga_s
anlace82513923anlace
anlaces92313733anlaces
anlage72514223anlage
anlages82414103anlages
anlases72514903anlases
annals66415923annals
annas55824883anna_s
annoys967523annoys
anoas57226493anoa_s
antas55432033anta_s
anyways1644423anyways
arrays95311683arrays
assays977903assays
atlas55821583atla_s
ays67050293___ays
balas76937213bala_s
bays97143913__bays
belay105021523belay_
bendays13327513bendays
bialys11387913bialys
blabs95619633_blabs
blahs105616513_blahs
blams95023853_blams
blats75132503_blats
blaws105620463_blaws
bolas74733763bola_s
boylas113011723boyla_s
brays106723113_brays
bylaws14415833bylaws
byplays1743103byplays
byways1734673byways
cays95437673__cays
chays135319743_chays
chlamys1733783chlamys
clads85722733_clads
clags85621123_clags
clams95127673_clams
clans75031013_clans
claps95626183_claps
class75525483_class
claws106020833_claws
clay95927413_clay_
cloys104916943_cloys
coalas87418963coala_s
cogways1634633cogways
colas75436773cola_s
colbys13407153colbys
collars93816573collars
coneys115218423con_eys
confabs1435393confabs
congas94417033conga_s
conveys15308223conveys
convoys15267023convoys
copays134911273copays
cullays12347703cullays
days87637133__days
decays124612913decays
delay94820633delay_
derays105514253derays
doblas93812293dobla_s
dollars83311023dollars
donas65926473don_a_s
dongas84914613donga_s
donkeys15426663donkeys
donnas75511323donna_s
doulas75114993doula_s
downplays1842503downplays
doyleys14384923doyleys
drays95819773_drays
eclats8313033eclats
elans55527753_elans
embays131408323embays
endplays14123773endplays
endways1444443endways
enjoys1644603enjoys
enlace82213233enlace
enlaces92313393enlaces
envoys1255133envoys
essays965653essays
fays108535363__fays
flabs105818643_flabs
flags95321283_flags
flams105125013_flams
flans85327973_flans
flaps105621383_flaps
flats86429743_flats
flaws115920343_flaws
flay106332803_flay_
fleys117015603_fleys
foleys123810463foleys
forays124813003forays
frays116920103_frays
galahs105512673galahs
galas65731643gala_s
gamays126310903gamays
gays87338023__gays
glads75620613_glads
glams85822933_glams
glans65125833_glans
glass65518133_glass
gleys96514853_gleys
gnars66718853gn_ars
gnats65217713gn_ats
gnaws96311143gn_aws
gonads84511733gon_ads
grays95621333_grays
gulags837543gulags
gunplays1442713gunplays
halals95018313halals
hays106138073__hays
henleys1334843henleys
hollas94616903holla_s
honans94814503hon_ans
hondas10313353honda_s
honeys124016083hon_eys
honkeys17439513honkeys
hoorays13418373hoorays
hulas84920883hula_s
hylas114815903hyla_s
inlace82513043inlace
inlaces92512903inlaces
inlaid7310133inlaid
inland7310313inland
inlands838783inlands
inlayer1036933inlayer
inlayers1135633inlayers
inlets63915573inlets
inly75622213inl_y_
invars9310003invars
jalaps15299183jalaps
jays146328343__jays
kalams12310603kalams
kays116032193__kays
knaps115511173kn_aps
knars94416113kn_ars
kneads11357093kneads
koalas104011663koala_s
kolas94822233kola_s
kulaks976113kulaks
labs67145123__labs
lacs66942483__lacs
lads56549133__lads
lags56546223__lags
lams66552263__lams
laps66848873__laps
lars46956573__lars
las37281473__la_s
lass47444543__lass
lats45962703__lats
lavs76734153__lavs
laws76441683__laws
lay68865353__lay_
leys76430183__leys
lilacs837483lilacs
logways1434513logways
longans84510813longans
longways1543873longways
malars85020683malars
mays96940023__mays
mislays12349243mislays
molars85517323molars
molas75132093mola_s
mollahs12328283mollahs
monads94515303mon_ads
monas74732153mon_a_s
moneys115513623mon_eys
monkeys16407423monkeys
moolahs12347383moolahs
moolas83615593moola_s
mooleys1236863mooleys
morays114613883morays
motleys1235683motleys
muleys11409643muleys
mylars114310443mylars
naans55815253_naans
nabs66236193_n_abs
nags55436023_n_ags
nalas55528363_nalas
nans46139393_n_ans
naos47429733_n_aos
naps66238583_n_aps
nay66952773_n_ay_
neaps75618323_neaps
nears55529423_nears
neats55931903_neats
nolos54423353nol_os
nomads94711603nomads
nomas74726413noma_s
nonas55126653nona_s
nonclass1046243nonclass
nonfans1037533nonfans
nongay10169153nongay_
nonplay1246683nonplay_
nonwars10109003nonwars
noondays1242883noondays
nopals84914023nopals
novas85215363nova_s
noway111112843noway_
oafs76425263o__afs
oaks86527903o__aks
oars46846033o__ars
oats46554213o__ats
obas65730933o_ba_s
obeahs1135863obeahs
obeys107010643o_beys
obias76116853obia_s
oblast8613663oblast
oblasts947293oblasts
oblate82214743oblate
oblates91913243oblates
ocas66729633o_ca_s
oceans81211003oceans
octads987333octads
octans81411143octans
oculars948363oculars
odahs95610083o_dahs
odas57230263o_da_s
ofay106416103o_fay_
offals1235893offals
ogams84112683o_gams
oghams1245853oghams
oglers74313183oglers
ogles65223183ogl_es
ohias84415563ohia_s
oilcans936813oilcans
oilers64721193oilers
oils46337973oil__s
oilway1235743oilway_
oily77932253oil_y_
okas85225393o_ka_s
okay115917663o_kay_
okras94410973okra_s
olds55926573o_l_ds
oldy85316843o_ldy_
oleos55419683o_leos
oles46453473o_l_es
olios54520853o_lios
olla44821173olla__
onery8414113onery_
ones46146533on__es
onions64016433onions
online6315843online
onload7268633onload
onos46229003on__os
ons36148513on___s
onsets64013543onsets
onus45826813on__us
onuses65616253onuses
onward1039053onward
onwards1137173onwards
onyx1478363on__yx
onyxes1654603onyxes
opahs105411983o_pahs
opals75718353o_pals
orals55826483o_rals
orcas75918623orca_s
oreads73915773oreads
orfrays1343533orfrays
organs7912913organs
orles55326213orl_es
orlons6411013orlons
orlops847303orlops
ottars64112223ottars
outlaws10249603outlaws
outlay92711793outlay_
outplays13246843outplays
outsays102710403outsays
ovals85413393o_vals
overlays14239693overlays
owlets93110393owlets
owls76022933owl__s
oxalis1339223oxalis
oxlips1544433oxlips
palais8420423palais
parlays123910453parlays
pays95940223__pays
pilafs113511023pilafs
pilaus84114133pilaus
pilaws11399433pilaws
plans75731273_plans
plats75531373_plats
platys11459853_platys
play95928983_play_
playa105812943_playa
playas114612283_playas
ploys105816593_ploys
polars84419353polars
polys105718763pol_ys
poplars113910333poplars
prays105022433_prays
quays174612043_quays
rays77642353__rays
relay84424673relay_
repays113813973repays
replays12399763replays
resays93714153resays
rollways1444233rollways
runways13134443runways
salads75316963salads
salals65120083salals
satays94411683satays
says75942103__says
selahs9313213selahs
shays116021433_shays
slabs75322643_slabs
slags66525903_slags
slams74927903_slams
slaps76025713_slaps
slats55436903_slats
slaws85222713_slaws
slay76436383_slay_
snags64421313sn_ags
snaps74719563sn_aps
snaws86116363sn_aws
sneaks104312493sneaks
sneaps84510863sneaps
solans64122493solans
sonars64818973son_ars
sonless72612613sonless
sonly85718053sonl_y_
spays105520513_spays
splats84817303splats
splay105816043splay_
sprays115913643sprays
stays86022023_stays
strays96417933strays
sunrays1037083sunrays
sways115518463_sways
talars66021683talars
talas55935893tala_s
tellys9348843tellys
tilaks1097353tilaks
todays10458103todays
tokays13397773tokays
tolans64319273tolans
tolars64817923tolars
tolas54532773tola_s
tollways1444133tollways
tongas74315513tonga_s
tonlets73212503tonlets
trays85623433_trays
uhlans937573uhlans
ulans54921303_ulans
ulnas55716533ulna_s
unais53420773un_ais
unaus53216573un_aus
unbans81912623unbans
unbars82113033unbars
uncaps1039813uncaps
uneasy9278853uneasy
unhats91110623unhats
unjams1555703unjams
unlace82215173unlace
unlaces92513623unlaces
unlade72714153unlade
unlades82612833unlades
unlaid7311753unlaid
unlash938793unlash
unleads8228623unleads
unless62413073unless
unloads8278523unloads
unmans82211993unmans
unsay83212843unsay_
velars93913723velars
volleys13316643volleys
waylays1634673waylays
ways107737953__ways
xylans1635883xylans
yays105728913__yays
yulans958673yulans
zonulas1637023zonula_s

Search took 6 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.1401276364.3
2DLD Change Limit1127164115.64319974.5
3Display Results4114110.1233341.5
 (SQL Overall)1786914115.90630255.8
 
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.