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

220 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
nalas5552836(None) 
alas46358121_alas
anlas55626931anlas
balas76937211balas
galas65731641galas
nadas66320811nadas
nala46930391nala_
nanas55928631nanas
napas75924351napas
nyalas936901nyalas
talas55935891talas
aals49941142aal_s
aas310975392_a_as
abas68642082_abas
agas55938842_agas
ala312463602_ala_
alae45643752_alae
alan46844082_alan
alans55636172_alans
alar46340072_alar
albas75925392_albas
albs68628572_albs
ales47067102_ales
alfas87219042_alfas
algas65624932_algas
alias55834602_alias
alls46740922_alls
almas76629772_almas
alms65834922_alms
alps65529242_alps
als36663022_al_s
alts46639902_alts
amas67746292_amas
anabas8314082anabas
anas46649862_anas
angas65827982angas
annas55824882annas
anoas57226492anoas
antas55432032antas
atlas55821582atlas
baals76122702baals
baas66844672ba_as
babas96325732babas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
balsa77920412balsa
balsas86417522balsas
bolas74733762bolas
cacas95627982cacas
calash11312432calash
calfs104919382calfs
calks115421602calks
callas84526752callas
calls75634732calls
calms95222352calms
calos74431902calos
camas96333522camas
casas75327842casas
coalas87418962coalas
colas75436772colas
dadas75819862dadas
dalasi7610622dalasi
dales66439742dales
dals57145122dal_s
falls85727652falls
favas115618592favas
gala55635162gala_
galah95917622galah
galahs105512672galahs
galax135314462galax
galeas74618502galeas
gales65442482gales
galls64729322galls
gals57946502gal_s
gamas85431352gamas
hahas117118442hahas
halal85623592halal
halals95018312halals
hales85449842hales
halls85633782halls
halmas117017892halmas
halms105225212halms
halos85230252halos
halts85230102halts
halvas124714172halvas
hulas84920882hulas
hylas114815902hylas
jalap143612472jalap
jalaps15299182jalaps
javas155915422javas
jnanas13207302jnanas
kaas86531842ka_as
kakas85117342kakas
kalam11315112kalam
kalams12310602kalams
kales95730982kales
kalpas124112942kalpas
kanas95326912kanas
kapas116021732kapas
katas95922092katas
kavas125919952kavas
koalas104011662koalas
kolas94822232kolas
lalls55324132lalls
lamas75532792lamas
las37281472__las
lavas85422222lavas
malar76424442malar
malars85020682malars
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mamas95930772mamas
manas76240422manas
maras75443282maras
masas75630412masas
mayas105924382mayas
molas75132092molas
naan47621932na_an
naans55815252naans
nabes75427092nabes
nabis76020582nabis
nabs66236192na_bs
nachas114914192nachas
nada58022902nada_
naffs116213962naffs
nags55436022na_gs
naiad6313402naiad
naiads739012naiads
naifs87617422naifs
nails55730402nails
nairas6312772nairas
nakfas1334682nakfas
naled65525052naled
naleds7469132naleds
names74833362names
nana46632892nana_
nans46139392na_ns
naos47429732na_os
napa66927262napa_
napes74828462napes
nappas105511612nappas
naps66238582na_ps
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
nasal56217592nasal
nasals63312462nasals
natal53921492natal
nates55238332nates
naval85315832naval
navar83912732navar
navars92810572navars
naves87030382naves
nawab10810922nawab
nawabs1185062nawabs
nays75931592na_ys
nazis145216082nazis
nemas75321572nemas
nills54926672nills
nils46132452nil_s
nipas77116672nipas
nolos54423352nolos
nomas74726412nomas
nonas55126652nonas
novas85215362novas
nulls55019982nulls
nyala836822nyala_
ollas54218282ollas
pacas96029402pacas
palais8420422palais
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pal_s
papas94927492papas
paras76143042paras
ragas65326062ragas
raias54631122raias
rajas127317722rajas
rales54947492rales
rayas85922052rayas
sagas66025882sagas
salad65321832salad
salads75316962salads
salal55425702salal
salals65120082salals
sales56055592sales
salpas85116922salpas
salps74423242salps
sals46851672sal_s
salsa56718922salsa
salsas65316132salsas
salts55431882salts
tablas83716162tablas
takas95520682takas
tala45938052tala_
talar56225382talar
talars66021682talars
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tapas74627712tapas
tolas54532772tolas
vales85434262vales
varas86028192varas
wales86142832wales
walks126218502walks
wallas95719392wallas
walls85529382walls

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 Filter178691538000.0931921408.6
2DLD Change Limit538002201.71631352.0
3Display Results2202200.0633492.1
 (SQL Overall)1786912201.87295454.6
 
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.