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 “sierras” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

197 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
sierras73786(None) 
sierra637311sierra_
sierran737191sierran
sirras63814861si_rras
sherpas1238092sherpas
sherris10168802sherris
siennas736122siennas
siestas738812siestas
sieurs659042sieur_s
sirra54416322si_rra_
sirrah9379752si_rrah
sirrahs10377302si_rrahs
surras65919532s_urras
terras63516972_terras
airers64922313airer_s
arras55626133__arras
asterias8317013asterias
biers76225223bie_r_s
birrs74917103bi_rr_s
cerias83321983_cerias
cirrus8349173ci_rrus
dermas94116813_dermas
derris73615273_derris
durras74713373_durras
eras45441503__e_ras
errs45622533__err_s
eyras84715923__eyras
ferias95020393_ferias
fiestas1038433fiestas
firers94922683firer_s
hijras1635773hi_jras
hirers94518063hirer_s
ixoras1337193_ixoras
kerrias11289513_kerrias
kiers95320093kie_r_s
kinaras1159123kinaras
libras83711703li_bras
liernes739623liernes
liers55130403lie_r_s
liras56021983li__ras
mirzas1738183mi_rzas
murras84916013_murras
operas8312453ope_ras
osetras737333osetras
osiers63412793osie_r_s
ossetras844093ossetras
overran10311663overran
overrash1436953overrash
picaras11311283picaras
pierces113411193pierces
pierrot948833pierrot
pierrots1044963pierrots
piers75926333pie_r_s
pietas84516503pie_tas
pleuras937413pleuras
ristras7311563ristras
sabras85116363s_abras
samaras9312913samaras
sataras7315063sataras
scenas84114703sce_nas
scleras948223scleras
sears54744913s_ear_s
seas45755273s_e__as
seeress7311573seeress
seers55136383s_eer_s
selvas93812913s_elvas
sennas64214233s_ennas
senoras72714953senoras
sepias83616103s_epias
sera46141393s_e_ra_
serac75925203s_e_rac
seracs84418573s_eracs
serai56830163s_e_rai
serais64326133s_erais
seral56336383s_e_ral
serdab937833s_erdab
serdabs1035323s_erdabs
seres55448893s_e_res
serfs84922013s_e_rfs
serges74225973s_erges
serial64625863s_erial
serials73919753s_erials
series64540973s_eries
serifs94017053s_erifs
serins64029673s_erins
serosa6313023s_erosa
serosas7312663s_erosas
serous65023563s_erous
serows96016393s_erows
serrano768463s_errano
serranos857873s_erranos
serrate73017543s_errate
serrates82617023s_errates
serries73925353s_erries
serry84824123s_err_y
sers45746653s_e_r_s
serums83916303s_erums
serval93913413s_erval
servals103410753s_ervals
serves94423653s_erves
servos93812723s_ervos
sewars94018633s_ewars
sferics1236133sferics
sharias102516003sharias
shears93820903shear_s
sheas86331793she__as
sheers94322403sheer_s
sheilas1059403sheilas
sheltas10279673sheltas
sherds105614723she_rds
sherifs13299683sherifs
sherpa1138093sherpa_
sherries111812903sherries
sherry124510413sherr_y
shiers94921753shie_r_s
shirrs94413173shirr_s
sidearms1144093sidearms
sidebars1146643sidebars
sidecars1145903sidecars
sidereal946063sidereal
sieges73816833sie_ges
siemens938413siemens
sienna647193sienna_
siesta639503siesta_
sieur5911893sieur__
sieverts1145713sieverts
sieves93216003sie_ves
sifakas1443333sifakas
sigmas94111363si_gmas
signoras9306553signoras
sikas94617023si__kas
silesias848523silesias
silicas9310603silicas
silvas92912183si_lvas
simars84916933simar_s
simas75727553si__mas
sirdar7269103si_rdar
sirdars8228213si_rdars
sirees64624583si_rees
sirens65318153si_rens
sires55945373si__res
sirree64017343si_rree
sirrees73410573sirrees
sirs44338333si__r_s
sirups83710533si_rups
sistra639333sistra_
sitars65417593sitar_s
sivers95324153siver_s
sizars154812623sizar_s
sizers155215813sizer_s
skerries12168673skerries
skerry13356103skerr_y
skiers104713703skie_r_s
skirrs10448193skirr_s
smears84714433smear_s
smegmas1233503smegmas
smerks12449713sme_rks
smiercase1342753smiercase
sneers64016173sneer_s
soras55041013s__oras
spears84019473spear_s
speers85019953speer_s
speirs85013233speir_s
sperms102512603spe_rms
spiers84421743spie_r_s
spireas94412513spireas
sporran936743sporran
sporrans1045523sporrans
steers63820983steer_s
stellas72813043stellas
stemmas11256973stemmas
stereos74314973stereos
steres63929533ste_res
sterna63712763sterna_
sternal73411913sternal
sterns64616763ste_rns
sterols7313443sterols
suers55128483sue_r_s
suras55336333s__uras
surra55521343s_urra_
sutras64818593s_utras
swears94114073swear_s
swerves1377533swerves
terra54419663_terra_
terrae62915213_terrae
tetras63017623_tetras
tiaras6314553ti_aras
tierces93710453tierces
tiers55526523tie_r_s
viers85621953vie_r_s
virgas1048883vi_rgas
whereas13448903whereas
wirers94617893wirer_s
wirra83210823wi_rra_
yerbas11119293_yerbas
yirrs8469193yi_rr_s
zebras1737853_zebras

Search took 8 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 Filter1786911340270.466383457.1
2DLD Change Limit1340271976.92319359.7
3Display Results1971970.0633127.0
 (SQL Overall)1786911977.45223978.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.