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

185 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
sagos6612387(None) 
dagos76419441dagos
sagas66025881sagas
sages65339061sages
sago56332671sago_
sags55948401sag_s
sargos74318271sargos
saros55238061saros
segos64919481segos
abos67734412_abos
ados57633512_ados
agas55938842_agas
ages55844592_ages
agios65919862_agios
ago48845522_ago_
agog68019002_agog
agon56531882_agon
agons66423782_agons
ags47551662_ag_s
apos65433822_apos
askos95011772askos
avos77227012_avos
bags76645502bag_s
bigos85020012bigos
cages85936012cages
calos74431902calos
camos95927612camos
capos94826072capos
cargos94619182cargos
dados75522432dados
dago65725092dago_
dagoes85714602dagoes
dags66642602dag_s
datos65222782datos
egos55821652_egos
fados95620732fados
fagot9323402fagot
fagots1039962fagots
fags86939122fag_s
fanos85926502fanos
faros85532022faros
gages74529972gages
gags66441062gag_s
gogos77516522gogos
gos47155132__gos
hags86740842hag_s
halos85230252halos
imagos9117552imagos
jaggs148111492jaggs
jags126132792jag_s
jatos125116822jatos
kagus105812032kagus
kayos127714702kayos
lags56546222lag_s
largos74815062largos
logos67225332logos
mages85036022mages
magot8326392magot
magots9312362magots
mags75444532mag_s
magus85318752magus
makos116518362makos
mangos94319332mangos
manos74933622manos
mayos105521932mayos
nags55436022nag_s
naos47429732na_os
pages85235072pages
pagod95013682pagod
pagods105310192pagods
pargos95719042pargos
ragas65326062ragas
rages64539442rages
raggs75216472raggs
ragis66325602ragis
rags55448372rag_s
ratos55528762ratos
sabes76437462sabes
sabot7931782sabot
sabots8314702sabots
sabs66643742sa_bs
sacks114228872sacks
sacs65739072sa_cs
sades65239892sades
sadis64930852sadis
safes85226722safes
sag46163402sag__
saga55331172sag_a
sage55044592sag_e
sager65432052sager
sagest74920262sagest
saggy105917462saggy
sagum8512872sagum
sagy85327082sag_y
saids65328852saids
saigas74114292saigas
sails55738102sails
sains55639972sains
sajou12311692sajou
sajous13310582sajous
sakes95540752sakes
sakis95323672sakis
sales56055592sales
salol55222142salol
salols64017872salols
salon55228552salon
salons63823692salons
salps74423242salps
sals46851672sa_ls
salts55431882salts
salvos94613382salvos
sambos104315192sambos
samosa8510202samosa
samps96124672samps
sands65228582sands
sanes55649072sanes
sangas75222652sangas
sanghs105312062sanghs
sans45153362sa_ns
santos64421832santos
sapor75119252sapor
sapors84118812sapors
saps65346372sa_ps
sards64736182sards
sarges75128592sarges
sargo65424412sargo_
saris54544952saris
sarks96632462sarks
sarod65325872sarod
sarods74918572sarods
sass45035622sa_ss
sates54949322sates
satis55633682satis
saughs104812052saughs
sauls55128122sauls
saves85838632saves
savor85417942savor
savors95616102savors
savoy114713882savoy
savoys12427892savoys
saws75839482sa_ws
saxes125229342saxes
says75942102sa_ys
scags85520972scag_s
segnos73610442segnos
sego56525182sego_
segs54933882seg_s
shags95123862shag_s
shakos134912192shakos
shamos114216982shamos
shogs95319712shogs
shoos84226362shoos
sighs95416742sighs
siglos7311472siglos
signs65516322signs
silos56029432silos
skags104316072skag_s
slags66525902slag_s
slogs64521842slogs
smogs85112162smogs
snags64421312snag_s
snogs66017492snogs
solos54830792solos
sorgos74514662sorgos
sos37761602s__os
stages75629492stages
stags66226742stag_s
sughs95313322sughs
sumos75720092sumos
swages104417072swages
swags94921252swag_s
tacos77023552tacos
tags55545232tag_s
tangos74216302tangos
taos45541002ta_os
taros55640822taros
usages759602usages
vagus96713812vagus
wages95330932wages
wagon94312952wagon
wagons103911212wagons
wags86140552wag_s
yagis95416572yagis
yags86632292yag_s
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.296603685.8
2DLD Change Limit538001851.71631352.0
3Display Results1851850.0632936.5
 (SQL Overall)1786911852.07586116.1
 
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.