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 “sagas” 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
sagas6602588(None) 
agas55938841_agas
ragas65326061ragas
saga55331171saga_
sages65339061sages
sagos66123871sagos
sags55948401sag_s
saigas74114291saigas
sangas75222661sangas
aas310975392_a_as
abas68642082_abas
aga410447232_aga_
agar58726412_agar
agars66120642_agars
ages55844592_ages
aghas97014872_aghas
agmas85919872_agmas
ags47551662_ag_s
alas46358122_alas
algas65624932algas
amas67746292_amas
anas46649862_anas
angas65827992angas
asanas6514112asanas
avgas96912132avgas
baas66844672ba_as
babas96325732babas
bagass938932bagass
bags76645502bag_s
balas76937212balas
cacas95627982cacas
cages85936012cages
camas96333522camas
casas75327842casas
dadas75819862dadas
daggas937972daggas
dagos76419442dagos
dags66642602dag_s
degas75119162degas
fags86939122fag_s
fangas105017202fangas
favas115618592favas
gaga66625552gaga_
gages74529972gages
gags66441062gag_s
galas65731642galas
gamas85431362gamas
gas48870252__gas
gigas75415582gigas
hags86740842hag_s
hahas117118442hahas
jaggs148111492jaggs
jagras1438462jagras
jags126132792jag_s
javas155915422javas
kaas86531842ka_as
kagus105812032kagus
kakas85117342kakas
kanas95326912kanas
kapas116021732kapas
katas95922092katas
kavas125919952kavas
lagan66520342lagan
lagans75717782lagans
lags56546222lag_s
lamas75532792lamas
lavas85422222lavas
mages85036022mages
magmas115512502magmas
mags75444532mag_s
magus85318752magus
mamas95930772mamas
manas76240432manas
mangas94122932mangas
maras75443292maras
masas75630412masas
mayas105924382mayas
nadas66320812nadas
nags55436022nag_s
nalas55528362nalas
nanas55928632nanas
napas75924352napas
pacas96029402pacas
pagan86121162pagan
pagans95717922pagans
pages85235072pages
pangas99921112pangas
papas94927492papas
paras76143042paras
raga55930812raga_
rages64539442rages
raggs75216472raggs
ragis66325602ragis
rags55448372rag_s
raias54631122raias
rajas127317722rajas
rayas85922052rayas
sabal75422482sabal
sabals84618862sabals
sabes76437462sabes
sabras85116362sabras
sabs66643742sa_bs
sacks114228872sacks
sacs65739072sa_cs
sades65239892sades
sadis64930852sadis
safes85226722safes
sag46163402sag__
sage55044592sag_e
sager65432052sager
sagest74920262sagest
saggar84010852saggar
saggars93610682saggars
saggy105917462saggy
sago56332672sag_o
sagum8512872sagum
sagy85327082sag_y
saids65328852saids
saiga64717932saiga_
sails55738102sails
sains55639972sains
sakes95540752sakes
sakis95323672sakis
salad65321832salad
salads75316962salads
salal55425702salal
salals65120082salals
sales56055592sales
salpas85116922salpas
salps74423242salps
sals46851672sa_ls
salsa56718922salsa
salsas65316132salsas
salts55431882salts
sambas104219262sambas
samps96124672samps
sands65228582sands
sanes55649072sanes
sanga66023802sanga_
sangar73617692sangar
sangars83116252sangars
sanghs105312072sanghs
sans45153362sa_ns
saps65346372sa_ps
saran53730302saran
sarans64224432sarans
sards64736182sards
sarges75128592sarges
sargos74318272sargos
saris54544952saris
sarks96632462sarks
saros55238062saros
sass45035622sa_ss
satay84718462satay
satays94411682satays
sates54949322sates
satis55633682satis
saughs104812052saughs
sauls55128122sauls
saunas63915432saunas
saves85838632saves
saws75839482sa_ws
saxes125229342saxes
says75942102sa_ys
scags85520972scag_s
seas45755272s_eas
segos64919482segos
segs54933882seg_s
shags95123862shag_s
shamas113717942shamas
sheas86331792sheas
shwas116415102shwas
sighs95416742sighs
sigmas94111362sigmas
signs65516322signs
sikas94617022sikas
simas75727552simas
skags104316072skag_s
skas85325712s_kas
skuas95611732skuas
slags66525902slag_s
snags64421312snag_s
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
somas76030372somas
soras55041012soras
soyas84520912soyas
spas67036722s_pas
stages75629492stages
stags66226742stag_s
stoas55126022stoas
subas74724072subas
sugar6312912sugar
sugars7312422sugars
sughs95313322sughs
suras55336332suras
swages104417072swages
swags94921252swag_s
syngas10368912syngas
tags55545242tag_s
taigas73712572taigas
takas95520682takas
talas55935892talas
tapas74627712tapas
togas67823002togas
usages759602usages
vagal94613632vagal
vagus96713812vagus
varas86028192varas
vigas94817882vigas
wages95330932wages
wags86140552wag_s
yagis95416572yagis
yags86632292yag_s
yogas96615602yogas
yugas95012062yugas
zags146826682zag_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.326548131.9
2DLD Change Limit538002201.73331044.4
3Display Results2202200.0633492.1
 (SQL Overall)1786912202.12284208.8
 
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.