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

246 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
errs4562253(None) 
ears46356591ears
eras45441501eras
ergs55523811ergs
erns45428231erns
eros45238451eros
err35626531err_
ers36046281e_rs
airs46447432airs
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137502arms
arras55626142arras
arris56824682arris
ars37670932_ars
arts49650262arts
bars66564092bars
bears75739042bears
beers75628392beers
bergs84718042bergs
berks115423122berks
berms95323662berms
berry104521772berry
birrs74917102birrs
bras65746452bras
bris65539612bris
bros65635662bros
brr56921922brr_
brrr65312292brrr
burrs74925652burrs
burs65847422burs
carrs75730852carrs
cars67364762cars
ceres75540012ceres
ceros74726072ceros
cors66656442cors
cris66233432cris
crus65828482crus
currs75624392currs
curs65645542curs
dears65736882dears
deers64930522deers
derms85022892derms
derris73615272derris
derry94721372derry
dorrs65520592dorrs
dors56747602dors
drys86314802drys
durrs65519992durrs
ear36867882ear_
earl45838142earl
earls56127512earls
earn46737552earn
earns55927562earns
eats47054872eats
ebbs82411992ebbs
ecru65819532ecru
ecrus75113862ecrus
ecus65421462ecus
edhs86212102edhs
eds46638932e_ds
eels46536742eels
eery76129622eery
effs105114032effs
efs66829602e_fs
efts76519482efts
egers65120372egers
eggs66516152eggs
egis56520652egis
egos55821652egos
ekes86726602ekes
elds56324862elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
emirs76116162emirs
ems56435492e_ms
emus66821682emus
ends56528532ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epos66723732epos
er28345142e_r_
era35741502e_ra
erase54925492erase
ere36352772e_re
erg45531072e_rg
ergo56420152ergo
ern35738362e_rn
erne46727432erne
ernes55224812ernes
erose55727282erose
erred65915672erred
error53712232error
errors63311312errors
erses55826802erses
erst47436432erst
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
euro45325272euro
euros54920242euros
eves76230462eves
ewers86018822ewers
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyers86521332eyers
eyes75837882eyes
eyra76217552eyra
eyras84715922eyras
eyre75525252eyre
eyres84921772eyres
eyry106315882eyry
fears84829392fears
feres86038182feres
ferns85220082ferns
ferry116020802ferry
firs76637722firs
furs76735042furs
gars55750742gars
gears64628692gears
germs85118872germs
hears86737372hears
heirs85618562heirs
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
herry114922472herry
hers75844872hers
ires45639282ires
iris45732552iris
irks86220132irks
jars117338352jars
jeers124818132jeers
jerks166514892jerks
jerry155016182jerry
keirs95313682keirs
kerbs115013672kerbs
kerfs125413572kerfs
kerns94719562kerns
kerry124916092kerry
kirs85831752kirs
kors85933022kors
kris86423612kris
lars46956572lars
lears55938732lears
leers54828982leers
lehrs86111132lehrs
mars66261872mars
mercs96020452mercs
meres75143572meres
merks114722402merks
merls77423902merls
merry104721492merry
mirs66940582mirs
mors65950062mors
murrs75521302murrs
nears55529422nears
nerds65719252nerds
nerts55924982nerts
oars46846032oars
orbs66626252orbs
orcs67025432orcs
ores46056682ores
orra46120722orra
orris54516552orris
ors35750112_ors
orts46538332orts
ours47237562ours
parrs75928672parrs
pars67560792pars
pears75138612pears
peers75130272peers
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perry105222712perry
pervs105117372pervs
pros65742782pros
purrs75320432purrs
purs65641042purs
ras37575392_ras
rears54739652rears
rebs65733562rebs
recs65734182recs
reds56042872reds
rees45364192rees
refs75732242refs
regs55436572regs
reis45343232reis
rems66237722rems
reps65937952reps
res35565042_res
rets45352562rets
revs75027052revs
sears54744912sears
seers55136382seers
seres55448892seres
serfs84922012serfs
serry84824122serry
sers45746652sers
sirs44338342sirs
sris45434152sris
tars46763952tars
tears55436462tears
terms75523472terms
terns55226872terns
terra54419672terra
terras63516972terras
terry84721872terry
torrs53923562torrs
tors46157382tors
tres46542902tres
urbs65922062urbs
urds55922442urds
urns46323902urns
urps66920482urps
urus46426142urus
vars75742072vars
veers84521362veers
verbs104614392verbs
verts85724732verts
wars78659802wars
wears86030302wears
weirs84316492weirs
xerus12313332xerus
years84527672years
yerks125416562yerks
yirrs8469192yirrs
zerks185113822zerks
zeros144918112zeros

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.326548131.9
2DLD Change Limit298722461.05028449.5
3Display Results2462460.0604100.0
 (SQL Overall)1786912461.436124436.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.