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

324 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
saros5523806(None) 
faros85532021faros
sagos66123871sagos
sards64736181sards
sargos74318271sargos
saris54544951saris
sarks96632461sarks
sarod65325871sarod
sarods74918571sarods
taros55640821taros
abos67734412_abos
ados57633512_ados
apos65433822_apos
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
arose55832082_arose
ars37670932_ar_s
arts49650262_arts
arvos86015662_arvos
askos95011772askos
avos77227012_avos
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
baron78131242baron
barons85025382barons
bars66564092bar_s
biros75325132biros
bros65635662_bros
calos74431902calos
camos95927612camos
capos94826072capos
carbos105122262carbos
carbs96031462carbs
cards85137932cards
cares77369182cares
cargos94619182cargos
carks115534212carks
carls77037422carls
carns75937562carns
carob95325222carob
carobs104818102carobs
carol75128612carol
carols85124982carols
carom95025562carom
caroms105619572caroms
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
ceros74726072ceros
claros84015112claros
dados75522432dados
dagos76419442dagos
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
datos65222782datos
duros65422692duros
earls56127512earls
earns55927562earns
ears46356592ear_s
eros45238452_eros
euros54920242euros
fados95620732fados
fanos85926502fanos
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faro76136922faro_
farts88336842farts
garbs86321412garbs
gars55750742gar_s
giros65722652giros
gyros95616482gyros
halos85230252halos
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
heros84930862heros
jarls126120962jarls
jars117338352jar_s
jatos125116822jatos
karns96624142karns
karoo92519582karoo
karoos102415802karoos
kaross101910012kaross
karts97630112karts
kayos127714702kayos
lards65331862lards
lares54852632lares
largos74815062largos
laris54737462laris
larks95227812larks
lars46956572lar_s
macros104017012macros
makos116518362makos
manos74933612manos
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
mayos105521932mayos
naos47429732na_os
narcos86714202narcos
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
paras76143042paras
pards85634332pards
pareos87023772pareos
pares77164482pares
pargos95719042pargos
paris75145942paris
parks116134462parks
parol74826272parol
parols84722612parols
parous84024162parous
parrs75928672parrs
pars67560792par_s
parts77743372parts
parvos116614752parvos
pharos11312062pharos
praos74923562praos
pros65742782_pros
pyros105718292pyros
rares55247442rares
ratos55528762ratos
sabes76437462sabes
sabot7931772sabot
sabots8314692sabots
sabras85116362sabras
sabres85520862sabres
sabs66643742sa_bs
sacks114228872sacks
sacs65739072sa_cs
sades65239892sades
sadis64930852sadis
safes85226722safes
safrol937282safrol
safrols1036862safrols
sagas66025882sagas
sages65339062sages
sago56332672sago_
sags55948402sa_gs
saids65328852saids
sails55738102sails
sains55639972sains
sajou12311692sajou
sajous13310582sajous
sakes95540752sakes
sakis95323662sakis
sales56055592sales
salol55222142salol
salols64017872salols
salon55228552salon
salons63823682salons
salps74423242salps
sals46851672sa_ls
salts55431882salts
salvos94613382salvos
sambos104315192sambos
samosa8510202samosa
samps96124672samps
sands65228582sands
sanes55649072sanes
sans45153352sa_ns
santos64421832santos
sapor75119252sapor
sapors84118812sapors
saps65346372sa_ps
saran53730302saran
sarans64224432sarans
sarcous9312932sarcous
sard55344242sar_d
saree55044662saree
sarees65329942sarees
sarge65531132sarge
sarges75128592sarges
sargo65424412sargo
sari45444042sar_i
sarin55239252sarin
sarins63932622sarins
sark84938972sar_k
sarky125521782sarky
sarode75317512sarode
sarodes84216142sarodes
sarong73914872sarong
sarongs84511802sarongs
saroses73619332saroses
sartor6313872sartor
sartors7314952sartors
sass45035622sa_ss
sates54949322sates
satis55633672satis
sauls55128122sauls
saves85838632saves
savor85417942savor
savors95616102savors
savoy114713882savoy
savoys12427892savoys
saws75839482sa_ws
saxes125229342saxes
says75942102sa_ys
scares85033002scares
scarfs114714682scarfs
scarps104718602scarps
scars75433532scar_s
scarts85321492scarts
scrod85115062scrod
scrods94111602scrods
sears54744912sear_s
segos64919482segos
seres55448892seres
serfs84922012serfs
serosa6313022serosa
serous65023562serous
serow86720442serow
serows96016392serows
sers45746652ser_s
servos93812722servos
shakos134912182shakos
shamos114216982shamos
shards104319172shards
shares95236412shares
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
shoos84226352shoos
shris84221442shris
silos56029422silos
sires55945372sires
sirs44338332sir_s
smarms105712532smarms
smarts86218002smarts
snares65329032snares
snarfs95113422snarfs
snarks104815732snarks
snarls64016872snarls
soars54732512soar_s
solos54830792solos
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorgos74514662sorgos
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
sos37761602s__os
spares84834552spares
sparks124616362sparks
spars75431542spar_s
sris45434152s_ris
stares66038752stares
stars55836572star_s
starts65423122starts
strop77422242strop
strops86220382strops
strow88920572strow
strows96718272strows
stroy87720392stroy
stroys95914602stroys
sumos75720092sumos
suras55336322suras
surds65624662surds
surfs85022542surfs
swards105415132swards
swarfs125612062swarfs
swarms116112162swarms
tacos77023552tacos
taos45541002ta_os
tares57456562tares
tarns56433952tarns
taro46846912taro_
taroc75721642taroc
tarocs84615662tarocs
tarok97921072tarok
taroks106115282taroks
tarot55943932tarot
tarots66422992tarots
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
tiros54524892tiros
toros54336192toros
tsars56717102tsar_s
tyros85118592tyros
varas86028192varas
vars75742072var_s
varus85921182varus
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
yards95324612yards
yarns85621792yarns
zarfs174713622zarfs
zeros144918102zeros

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.0961861364.6
2DLD Change Limit538003241.92028020.8
3Display Results3243240.0933483.9
 (SQL Overall)1786913242.10984727.8
 
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.