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

482 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
abayas11401170(None) 
abacas104414721abacas
abakas123911741abakas
abaya104413171abaya_
kabayas16316801kabayas
abaca95118042abaca_
abacus10349762abacus
abaka114313822abaka_
abamps1236252abamps
abas68642082ab__as
abases85720772abases
abasias9711012abasias
abates85825032abates
abatis84317932abatis
abbas95918642ab_bas
abomas101113582abomas
abyes105518532ab_yes
abys97221882ab_y_s
abyss10669462ab_yss
agamas97413442agamas
albatas938372albatas
aliyas93911802aliyas
anabas8314082anabas
asanas6514112asanas
baas66844672_ba_as
babas96325732_babas
balas76937212_balas
bays97143912_bay_s
cabalas113516002cabalas
cabanas112413032cabanas
kabakas12367402kabakas
kabalas133911062kabalas
kabaya15387122kabaya_
mayas105924382_mayas
papayas1437272papayas
playas114612282playas
qabalas18289502qabalas
rayas85922052_rayas
aahs716428563a_a_hs
aals49941143a_a_ls
aas310975393__a_as
aba512850953ab__a_
abaci94718843aba_ci
aback134816173aba_ck
abaft10318063aba_ft
abamp11310603aba_mp
abase76023483aba_se
abased96514993abased
abaser86414343abaser
abasers95311973abasers
abash106016513aba_sh
abashes12510373abashes
abasia8712953abasia
abate76627843aba_te
abated95918453abated
abater85518123abater
abaters95115193abaters
abator84512713abator
abators94413073abators
abattis9297823abattis
abaxial1646183abaxial
abba810522643ab_ba_
abbes96723523ab_bes
abbess10509773abbess
abbeys13538423abbeys
abbots1039283abbots
abeam9316533ab_eam
abeles84719393abeles
abelias93213563abelias
abets75621673ab_ets
abeyant1248083abeyant
abfarad1344223abfarad
abfarads1443163abfarads
abhors11410623abhors
abides94719893abides
ablates92416903ablates
ablauts936083ablauts
ables75935543ab_les
ablins8316193ablins
ably99725133ably__
abmhos1334973abmhos
abodes94417513abodes
abohms1335003abohms
aboma91114603aboma_
abomasa11114613abomasa
abomasi11115493abomasi
aboral8314373aboral
aborts84916183aborts
abos67734413ab__os
aboves114512843aboves
abrades10312073abrades
abreast9311273abreast
abris75722603ab_ris
abroad9310943abroad
abs59356073ab___s
abulias93210693abulias
abuses85119103abuses
abuts75417073ab_uts
abwatts1233403abwatts
aby810238063ab_y__
abye97921003ab_y_e
abysm12598143ab_ysm
abysms13565653abysms
acacias11510393acacias
acarus8312193acarus
acyls104211523a_cyls
adages8412953adages
adapts9107813adapts
afars85716513afa_rs
agama85815573agama_
agapae9388043agapae
agapai9456843agapai
agapes95212413agapes
agars66120643aga_rs
agas55938843__agas
agates76121333agates
agaves104611513agaves
aggadas1054983aggadas
aghas97014873a_ghas
agitas7310593agitas
agmas85919873a_gmas
agoras7613343agoras
agrias74315393agrias
ajivas1655133ajivas
ajugas1435263ajugas
akelas10311193akelas
alamos8415003alamos
alands75418373alands
alans55636173ala_ns
alants67722023alants
alanyls1084353alanyls
alarms85913053alarms
alas46358123__alas
alaskas1136683alaskas
alates64833963alates
albas75925393a_lbas
albata839333albata_
alfas87219043a_lfas
algas65624933a_lgas
alias55834603a_lias
aliya83713483aliya_
aliyah12397493aliyah
aliyahs13395323aliyahs
aliyos9349533aliyos
alkyds14404363alkyds
alkyls13465723alkyls
allays94313743allay_s
allyls9437273allyls
almas76629773a_lmas
alohas9411703alohas
alpacas1137073alpacas
alphas1139513alphas
always12409133alway_s
amahs107819063ama_hs
amas67746293__amas
amass77119683ama_ss
amazes175613473amazes
ambages1269623ambages
ambaris113112123ambaris
amboynas1543233amboynas
amebas10311453amebas
amias75831463a_mias
amigas95912163amigas
amyls104512683a_myls
anas46649863__anas
anatase738943anatase
angas65827983a_ngas
animas84418723animas
anlas55626933a_nlas
annas55824883a_nnas
anoas57226493a_noas
antas55432033a_ntas
aortas65417783aortas
apneas83211383apneas
aquas142412613a_quas
araks94820883ara_ks
arames84622573arames
areas55935773a_reas
arecas84817443arecas
arenas65021993arenas
arepas85515703arepas
argalas84011083argalas
arias55438023a_rias
armadas1038173armadas
aromas81018613aromas
arras55626133a_rras
arrayal1055843arrayal
arrayals1154483arrayals
arrays95311683array_s
aryls87015813a_ryls
asana5315483asana_
asramas938303asramas
assays977903assay_s
atabal839743atabal
atabals938413atabals
atalayas1144783atalayas
ataman81013063ataman
atamans9710433atamans
ataps76414833ata_ps
ataxias14189343ataxias
atlas55821583a_tlas
atmas75721013a_tmas
aubades1038743aubades
auras55932553a_uras
avails939693avails
avatar937523avatar
avatars1036443avatars
avgas96912133a_vgas
awaits96411953awaits
awakes135012473awakes
awards107113453awards
away108024223away__
ayah108022993__ayah
ayahs116813523aya_hs
ayes76543513__ayes
ays67050293__ay_s
azaleas1636993azaleas
azans146516883aza_ns
baa510650423_ba_a_
baal67033113_ba_al
baals76122703_baals
baases85218013baases
baba88828343_baba_
babes95834113_babes
babkas146010143babkas
babus95620333_babus
backs135729623_backs
badass949293_badass
bads77048863_ba_ds
baffs134718053_baffs
bagass938933_bagass
bags76645503_ba_gs
bahts105617803_bahts
bails75933523_bails
baits76630583_baits
baizas173810823baizas
bakes117035373_bakes
balatas9311833balatas
balds85524643_balds
bales76250083_bales
balks114926293_balks
balls76236413_balls
balms95723923_balms
bals66354043_ba_ls
balsa77920413_balsa
balsas86417523balsas
bams87044453_ba_ms
banal75925993_banal
bananas93312223bananas
bandas95120543bandas
bands85233423_bands
banes74945583_banes
bangs85627773_bangs
banks115527903_banks
banns75321233_banns
bans66555133_ba_ns
banyan1139483banyan
banyans1237913banyans
baps86040843_ba_ps
barbs95928193_barbs
barcas101016603barcas
bards87139643_bards
bares75457133_bares
barfs104826003_barfs
barks115735813_barks
barms96128463_barms
barns76335143_barns
bars66564093_ba_rs
baryes116218503baryes
barytas12378283barytas
bas58681753_b__as
basal75722283_basal
bases75644353_bases
basis75429863_basis
basks115621763_basks
bass66146783_ba_ss
basts75936933_basts
bates75846343_bates
baths105922923_baths
bats66962333_ba_ts
batts76727563_batts
bauds85821043_bauds
bawds116115493_bawds
bawls105719323_bawls
bay89661643_bay__
bayamo1335603_bayamo
bayamos1434663_bayamos
bayard124411663_bayard
bayards13379683_bayards
bayed115423023_bayed
bayman133712703_bayman
bayou10512363_bayou
bayous11411143_bayous
bazar163816003_bazar
bazars174613113_bazars
bemas96424283_bemas
betas75528763_betas
beys913829553_bey_s
bias64738153_b_ias
bimas95521743_bimas
boas66150833_b_oas
bolas74733763_bolas
boras75938303_boras
botas75328783_botas
boyar106013763_boyar
boyars115611983_boyars
boylas113011723_boylas
boyos105418283_boyos
boys96737333_boy_s
bras65746453_b_ras
bravas114913323bravas
brays106723113bray_s
brazas175812433brazas
bunas75126573_bunas
bunyas11359433bunyas
buras74736293_buras
buys95726793_buy_s
bwanas1157443bwanas
byes95230533_b_yes
bys85229463_b_y_s
cabala103516913cabala_
cabals104020153caba_ls
cabana103913563cabana_
cabbalas1467373cabbalas
cacas95627983_cacas
camas96333523_camas
casabas1139983casabas
casas75327843_casas
casavas1237813casavas
cays95437673_cay_s
charas114223593charas
chays135319743chay_s
clays105521333clay_s
coalas87418963coalas
dadas75819863_dadas
days87637133_day_s
dramas95814653dramas
drays95819773dray_s
embays131408323embay_s
eyas76427433__eyas
falbalas1345473falbalas
favas115618593_favas
fays108535363_fay_s
flays116321053flay_s
fracas11311993fracas
frays116920103fray_s
galas65731643_galas
gamas85431353_gamas
gamays126310903gamay_s
gayal9312713_gayal
gayals1039513_gayals
gays87338023_gay_s
gramas94317203gramas
grays95621333gray_s
guavas1037153guavas
hahas117118443_hahas
halalas104214083halalas
hamadas1339663hamadas
hawalas13348353hawalas
hays106138073_hay_s
hoyas115016163_hoyas
jacanas1638263jacanas
javas155915423_javas
jays146328343_jay_s
jnanas13207303jnanas
kaas86531843_ka_as
kababs14409763kaba_bs
kabaka11348503kabaka_
kabala124011553kabala_
kabars124513953kaba_rs
kabbalas1674353kabbalas
kakas85117343_kakas
kamalas13339123kamalas
kanakas10327213kanakas
kanas95326913_kanas
kapas116021733_kapas
katas95922093_katas
kavas125919953_kavas
kayak1138363_kayak
kayaks1236333_kayaks
kayos127714703_kayos
kays116032193_kay_s
kbars114612603kba_rs
koalas104011663koalas
labara83712893labara_
lamas75532793_lamas
lambadas1354873lambadas
lavas85422223_lavas
lays76043253_lay_s
lianas63713383lianas
llamas888973llamas
mamas95930773_mamas
mananas93414733mananas
manas76240423_manas
maracas11313773maracas
maras75443283_maras
masalas9312053masalas
masas75630413_masas
maya95824583_maya_
mayan105616903_mayan
mayos105521933_mayos
mays96940023_may_s
mbiras1077143mbiras
nadas66320813_nadas
naganas847983naganas
nalas55528363_nalas
nanas55928633_nanas
napas75924353_napas
nays75931593_nay_s
nyalas936903nyalas
obas65730933ob__as
obeys107010643obey_s
obias76116853ob_ias
ofays11488923ofay_s
okays12609443okay_s
pacas96029403_pacas
pajamas18278153pajamas
palapas11311493palapas
panadas103312213panadas
panamas113112753panamas
papas94927493_papas
papaya1337503papaya_
papayan1445303papayan
paras76143043_paras
patacas11311003patacas
pays95940223_pay_s
pirayas1277483pirayas
pitayas1286263pitayas
playa105812943playa_
plays106320773play_s
plazas17409913plazas
prays105022433pray_s
pyas96225703__pyas
qabala17399193qabala_
qabalah21285033qabalah
qabalahs22253293qabalahs
quays174612043quay_s
rabatos93010893rabatos
rabats83116223raba_ts
ragas65326063_ragas
raias54631123_raias
rajas127317723_rajas
ramadas1039303ramadas
raya75224823_raya_
rayah116013503_rayah
rayahs12579193_rayahs
rays77642353_ray_s
reatas64021013reatas
riatas63915083riatas
ruanas6311263ruanas
ryas77224613__ryas
sabals84618863saba_ls
sabayon1244233sabayon
sabayons1343963sabayons
sabras85116363sab_ras
sagas66025883_sagas
samaras9312913samaras
sataras7315053sataras
satays94411683satay_s
says75942103_say_s
shamas113717933shamas
shays116021433shay_s
slays85723683slay_s
soyas84520913_soyas
spays105520513spay_s
stays86022023stay_s
sways115518463sway_s
tabards10310383tabards
tablas83716163tab_las
takas95520683_takas
talas55935893_talas
tambalas1237033tambalas
tapas74627713_tapas
taramas9612693taramas
thuyas1234773thuyas
tiaras6314533tiaras
trays85623433tray_s
ulamas8910453ulamas
varas86028193_varas
ways107737953_way_s
yays105728913_yay_s
zananas16319563zananas

Search took 7 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.1231452772.4
2DLD Change Limit1127164826.54617219.1
3Display Results4824820.1563089.7
 (SQL Overall)1786914826.82526181.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.