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

256 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
ergs5552381(None) 
bergs84718041bergs
eggs66516151eggs
engs56121391engs
eras45441501eras
erg45531071erg_
ergo56420151ergo
erns45428221erns
eros45238451eros
errs45622531errs
ers36046281er_s
regs55436571regs
ags47551662_ags
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
argus66716542argus
arks85936872arks
arms66137492arms
ars37670932ar_s
arts49650262arts
bags76645502bags
begs75733832begs
berg75425542berg_
berks115423122berks
berms95323662berms
bigs76235022bigs
bogs75742752bogs
brags85625102brags
bras65746452bras
brigs85823222brigs
bris65539612bris
bros65635662bros
bugs76035912bugs
burgs84924092burgs
ceres75540012ceres
ceros74726072ceros
cigs75625102cigs
cogs77340032cogs
crags85622572crags
cris66233432cris
crus65828482crus
dags66642602dags
derms85022892derms
digs66036052digs
dogs66440152dogs
drags75521112drags
dregs76114862dregs
drugs75214652drugs
drys86314802drys
dugs614832282dugs
earls56127512earls
earns55927562earns
ears46356592ears
eats47054872eats
ebbs82411992ebbs
ecrus75113862ecrus
ecus65421462ecus
edge65719682edge
edges75718742edges
edgy94713532edgy
edhs86212102edhs
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
egg56918672e_gg
eggy96611852eggy
egis56520652egis
ego46726052e_go
egos55821652egos
ekes86726602ekes
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
ems56435492e_ms
emus66821682emus
ends56528522ends
eng46726782eng_
ens37245922e_ns
eons46638712eons
epos66723732epos
er28345142er__
era35741502er_a
erase54925492erase
ere36352772er_e
ergot65422892ergot
ergots74512372ergots
ern35738352er_n
erne46727422erne
ernes55224812ernes
erose55727272erose
err35626532er_r
erses55826802erses
erst47436432erst
erugo6369852erugo
erugos7347342erugos
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
euros54920242euros
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyes75837882eyes
eyras84715922eyras
eyres84921772eyres
fags86939122fags
feres86038182feres
ferns85220082ferns
figs85332642figs
fogs87035002fogs
frags96322172frags
frigs96019272frigs
frogs96220772frogs
frugs96114282frugs
fugs85730692fugs
gags66441062gags
germs85118872germs
gigs66631182gigs
grigs75318192grigs
grogs76319412grogs
hags86740842hags
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872her_s
hogs87139662hogs
hugs86129752hugs
iggs66612672iggs
ires45639282ires
iris45732552iris
irks86220132irks
jags126132792jags
jerks166514892jerks
jigs126524762jigs
jogs127129332jogs
jugs125525602jugs
kegs95824022kegs
kerbs115013672kerbs
kerfs125413572kerfs
kerns94719562kerns
kris86423602kris
lags56546222lags
legs56133692legs
logs57343112logs
lugs55233522lugs
mags75444532mags
megs75530632megs
mercs96020452mercs
meres75143572meres
merge84523692merge
merges94122492merges
merks114722402merks
merls77423902merls
migs76935322migs
mogs75439332mogs
mugs76232042mugs
nags55436022nags
negs55727362negs
nerds65719252nerds
nerts55924982nerts
nogs56534612nogs
orbs66626252orbs
orcs67025432orcs
ores46056682ores
orgy85218002orgy
ors35750112or_s
orts46538332orts
peags86122842peags
pegs75531762pegs
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pigs76634222pigs
prigs85219702prigs
progs86624152progs
pros65742782pros
pugs76332772pugs
rags55448372rags
ras37575392_ras
rebs65733562rebs
recs65734182recs
reds56042862reds
rees45364192rees
refs75732242refs
reg46146492reg_
reges65628792reges
reis45343232reis
rems66237722rems
reps65937952reps
rerigs74014792rerigs
res35565042_res
rets45352562rets
revs75027052revs
rigs55137592rigs
rugs56033682rugs
sags55948402sags
segs54933882segs
seres55448892seres
serfs84922012serfs
serge64727472serge
serges74225972serges
sers45746652ser_s
sris45434152sris
tags55545232tags
teggs74710742teggs
tegs56031492tegs
terga63315642terga
terms75523472terms
terns55226872terns
togs57242432togs
tres46542902tres
trigs65423062trigs
trogs67022602trogs
trugs65516802trugs
tugs56231672tugs
urbs65922052urbs
urds55922422urds
urge54722412urge
urges64619912urges
urns46323892urns
urps66920472urps
urus46426132urus
verbs104614392verbs
verge93419842verge
verges104320182verges
verts85724732verts
vigs85427272vigs
vugs87022872vugs
wags86140552wags
wigs84931252wigs
wogs86531402wogs
xerus12313332xerus
yags86632292yags
yeggs10608162yeggs
yerks125416562yerks
zags146826682zags
zerks185113822zerks
zeros144918112zeros
zigs145422792zigs

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 Filter178691298720.280638182.1
2DLD Change Limit298722560.78338150.7
3Display Results2562560.0763368.4
 (SQL Overall)1786912561.139156884.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.