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

133 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
algas6562493(None) 
agas55938841a_gas
alas46358121al_as
albas75925391albas
alfas87219041alfas
alga57927601alga_
algae65319621algae
algal66518221algal
alias55834601alias
almas76629771almas
angas65827981angas
avgas96912131avgas
aas310975392a__as
abas68642082a_bas
abbas95918642abbas
aegis6316782aegis
aga410447232a_ga_
agar58726412a_gar
agars66120642a_gars
ages55844592a_ges
aghas97014872aghas
agmas85919872agmas
ags47551662a_g_s
ajugas1435262ajugas
ala312463602al_a_
alae45643752al_ae
alan46844082al_an
alans55636172alans
alar46340072al_ar
alba68328332alba_
albs68628572al_bs
alecs76620732alecs
alefs87319662alefs
alegar739282alegar
alegars838932alegars
ales47067102al_es
alfa77624272alfa_
algid75415582algid
algin65718762algin
algins74816432algins
algor6513052algor
algors7312552algors
algum82711762algum
algums9208042algums
alifs86121262alifs
aligns75312952aligns
aliyas93911802aliyas
allay85620392allay
allays94313742allays
alls46740922al_ls
alma66333022alma_
almah106917252almah
almahs118611612almahs
almes75126542almes
alms65834922al_ms
aloes54933672aloes
alohas9411702alohas
alphas1139512alphas
alps65529242al_ps
als36663022al__s
altar55520642altar
altars64518152altars
altos55822952altos
alts46639902al_ts
alums75720602alums
alway116113922alway
always12409132always
amas67746292a_mas
amias75831472amias
amigas95912172amigas
anas46649862a_nas
anga56831352anga_
anlas55626932anlas
annas55824882annas
anoas57226492anoas
antas55432032antas
aquas142412612aquas
areas55935772areas
argal65023392argal
argals75517712argals
argus66716542argus
arias55438022arias
arras55626132arras
atlas55821582atlas
atmas75721012atmas
auras55932562auras
balas76937212bal_as
balsas86417522balsas
belgas9311712belgas
callas84526752callas
clags85621122clags
daggas937972daggas
degas75119162degas
fangas105017192fangas
flags95321282flags
fleas86423662fleas
galas65731642gal_as
galeas74618512galeas
gas48870252__gas
gigas75415582gigas
glias64618492glias
halmas117017892halmas
halvas124714172halvas
kalpas124112942kalpas
lagan66520342lagan
lagans75717782lagans
lags56546222lag_s
lamas75532792lamas
las37281472_l_as
lavas85422222lavas
leas45954182_leas
mangas94122922mangas
nalas55528362nal_as
ollas54218282ollas
pangas99921102pangas
pleas75627032pleas
ragas65326062ragas
sagas66025882sagas
saigas74114292saigas
salpas85116922salpas
salsas65316132salsas
sangas75222652sangas
slags66525902slags
taigas73712562taigas
talas55935892tal_as
togas67823002togas
ulnas55716532ulnas
ulvas84511502ulvas
valgus1047102valgus
vigas94817882vigas
wallas95719392wallas
yogas96615602yogas
yugas95012062yugas

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.313570897.8
2DLD Change Limit538001331.57634137.1
3Display Results1331330.0334030.3
 (SQL Overall)1786911331.92292971.4
 
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.