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

187 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
mayas10592438(None) 
mamas95930781mamas
manas76240431manas
maras75443301maras
masas75630411masas
maya95824591maya_
mayan105616901mayan
mayos105521931mayos
mays96940031may_s
rayas85922051rayas
aas310975392_a_as
abas68642082_abas
abayas114011702abayas
agas55938842_agas
alas46358122_alas
amas67746302_amas
amias75831472amias
amyls104512692amyls
anas46649862_anas
ayah108022992_ayah
ayahs116813522_ayahs
ayes76543512_ayes
ays67050292_ay_s
baas66844672ba_as
babas96325732babas
balas76937212balas
bays97143912bay_s
cacas95627982cacas
camas96333532camas
casas75327842casas
cays95437672cay_s
dadas75819862dadas
days87637132day_s
eyas76427432_eyas
favas115618592favas
fays108535362fay_s
galas65731642galas
gamas85431372gamas
gayal9312712gayal
gayals1039512gayals
gays87338022gay_s
hahas117118442hahas
hays106138072hay_s
hoyas115016162hoyas
javas155915422javas
jays146328342jay_s
kaas86531862ka_as
kakas85117352kakas
kanas95326922kanas
kapas116021742kapas
katas95922102katas
kavas125919962kavas
kayak1138372kayak
kayaks1236332kayaks
kayos127714702kayos
kays116032202kay_s
lamas75532802lamas
lavas85422222lavas
lays76043252lay_s
maar66025062ma_ar
maars74621632maars
mabes96331532mabes
macaw12311762macaw
macaws1337022macaws
maces97139962maces
machs125722562machs
macks135127602macks
macs86742512ma_cs
madam10316222madam
madams11310942madams
madras94316432madras
mads76845382ma_ds
maes66948402ma_es
mafias113913572mafias
mages85036022mages
magmas115512512magmas
mags75444532ma_gs
magus85318752magus
maids86327152maids
mails76037782mails
maims96321792maims
mains75635112mains
mairs76228302mairs
makar115614972makar
makars124612632makars
makes115336852makes
makos116518362makos
malar76424442malar
malars85020682malars
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mama86231602mama_
mambas125716242mambas
mammas94616412mammas
mana65341962mana_
manat76039992manat
manats84623462manats
manes76648962manes
mangas94122932mangas
manias84029032manias
mannas85019802mannas
manos74933622manos
mans66354552ma_ns
mantas85725362mantas
manus75924932manus
maps86141052ma_ps
mara67444582mara_
marcs95726622marcs
mares76457632mares
markas124717012markas
marks115933482marks
marls75535162marls
mars66261872ma_rs
marts77442232marts
mas58175822m__as
masa65034722masa_
masks115320532masks
mass66044942ma_ss
massa75518922massa
massas85116462massas
masts77035762masts
mates75251362mates
maths105624022maths
mats65460292ma_ts
matts76829182matts
matzas1749702matzas
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
mavis105622722mavis
maws96437142ma_ws
maxes145629532maxes
maxis145721562maxis
may88757632may__
maybe12311132maybe
maybes1339242maybes
mayday1535882mayday
maydays1634492maydays
mayed115522402mayed
mayest114614792mayest
mayhap1635232mayhap
mayo96524302may_o
mayor106616622mayor
mayors115714192mayors
mayst106622672mayst
mazes165632172mazes
mesas76823202mesas
micas96823052micas
minas75434112minas
moas65545342m_oas
molas75132092molas
monas74732152monas
moras76438782moras
moxas145014402moxas
muras75329582muras
mycs115314292m_ycs
mynas105815232mynas
nadas66320812nadas
nalas55528362nalas
nanas55928632nanas
napas75924352napas
nays75931592nay_s
pacas96029402pacas
papas94927492papas
paras76143052paras
pays95940222pay_s
playas114612282playas
pyas96225702_pyas
ragas65326062ragas
raias54631122raias
rajas127317722rajas
raya75224822raya_
rayah116013502rayah
rayahs12579192rayahs
rays77642352ray_s
ryas77224612_ryas
sagas66025882sagas
says75942102say_s
soyas84520912soyas
takas95520682takas
talas55935892talas
tapas74627712tapas
varas86028202varas
ways107737952way_s
yays105728912yay_s

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001872.45321932.3
3Display Results1871870.0464065.2
 (SQL Overall)1786911872.81263545.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.