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

275 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
talas5593589(None) 
alas46358121_alas
atlas55821581atlas
balas76937211balas
galas65731641galas
nalas55528361nalas
tablas83716161tablas
takas95520681takas
tala45938051tala_
talar56225381talar
talars66021681talars
talcs74817181talcs
tales55451371tales
talks94322691talks
talls55133431talls
talus55423261talus
tapas74627711tapas
tolas54532771tolas
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
anas46649862_anas
anlas55626932anlas
atmas75721012atmas
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_
galah95917642galah
galahs105512682galahs
galax135314462galax
galeas74618512galeas
gales65442482gales
galls64729322galls
gals57946502gal_s
gamas85431362gamas
hahas117118442hahas
halal85623592halal
halals95018312halals
hales85449842hales
halls85633782halls
halmas117017892halmas
halms105225212halms
halos85230252halos
halts85230102halts
halvas124714172halvas
hulas84920882hulas
hylas114815902hylas
jalap143612472jalap
jalaps15299182jalaps
javas155915422javas
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
manas76240432manas
maras75443292maras
masas75630412masas
mayas105924382mayas
molas75132092molas
nadas66320812nadas
nala46930392nala_
nanas55928632nanas
napas75924352napas
nyalas936902nyalas
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
stalag7310022stalag
stalags838642stalags
stales65538292stales
stalks104614552stalks
stalls64019932stalls
tabes76033922tabes
tabla73318362tabla_
tables84524892tables
tabs66842982ta_bs
tabus74820922tabus
taces76237802taces
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tacts76524122tacts
tads57143942ta_ds
taels56822072taels
tafias93111962tafias
tags55545242ta_gs
tahrs85412332tahrs
taigas73712572taigas
tails55634192tails
tains54936322tains
tajes124920692tajes
taka87623592taka_
takes94437792takes
talc66226812tal_c
tale46154162tal_e
taler56034862taler
talers64628142talers
tali46837162tal_i
talk86230092tal_k
talky126215682talky
tall47240212tal_l
tallis63319962tallis
tally84526862tally
talon55824112talon
talons64019442talons
taluk94812872taluk
talukas11316212talukas
taluks10418282taluks
tamal73522622tamal
tamals84116632tamals
tames75242012tames
tamis76728732tamis
tamps95524092tamps
tams67247932ta_ms
tangs65028362tangs
tankas104613772tankas
tanks94624742tanks
tans46154832ta_ns
taos45541002ta_os
tapa65129152tapa_
tapes75838602tapes
tapis75028862tapis
taps66050682ta_ps
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527122tarps
tars46763952ta_rs
tarts57242022tarts
tas38477102t__as
tasks94917582tasks
tass45640572ta_ss
tatar56122062tatar
tatars64619792tatars
tates55444982tates
tats46858132ta_ts
taus46342732ta_us
tauts56125512tauts
tavs75630972ta_vs
taws75641592ta_ws
taxa116820102taxa_
taxes124730822taxes
taxis126821972taxis
taxus125512482taxus
tazzas1436282tazzas
teals56234132teal_s
teas45851492t_eas
tela45532972tela_
telae54323292telae
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692tel_s
tepas76521682tepas
teslas64212172teslas
texas126514932texas
tiaras6314552tiaras
tilak91011552tilak
tilaks1097352tilaks
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
toeas55726422toeas
togas67823002togas
tola45236332tola_
tolan55124012tolan
tolans64319272tolans
tolar55524112tolar
tolars64817942tolars
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toras55540372toras
tubas75119582tubas
tufas85314382tufas
tules54532792tules
tunas54224122tunas
twas76824082t_was
vales85434262vales
varas86028192varas
wales86142832wales
walks126218502walks
wallas95719392wallas
walls85529382walls

Search took 4 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.623286823.4
2DLD Change Limit538002752.93618324.3
3Display Results2752750.1401964.3
 (SQL Overall)1786912753.69948307.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.