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

156 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
eggs6651615(None) 
egg56918671egg_
eggy96611851eggy
egis56520651egis
egos55821651egos
engs56121391engs
ergs55523811ergs
iggs66612671iggs
teggs74710741teggs
yeggs10608161yeggs
aegis6316782aegis
agas55938842agas
ages55844592ages
ags47551662_ags
bags76645502bags
begs75733832begs
bergs84718042bergs
bigs76235022bigs
bogs75742752bogs
bugs76035912bugs
cigs75625102cigs
cogs77340032cogs
dags66642602dags
degas75119162degas
digs66036052digs
dogs66440152dogs
dugs614832282dugs
ears46356592ears
eats47054872eats
ebbs82411992ebbs
ecus65421462ecus
edge65719682edge
edges75718742edges
edgy94713532edgy
edhs86212102edhs
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
egad64215412egad
egads74610922egads
egal55119432egal
eger55923572eger
egers65120372egers
egest65222342egest
eggar7458882eggar
eggars8398972eggars
egged85114392egged
egger74414412egger
eggers84612582eggers
ego46726052e_go
ekes86726602ekes
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
ems56435492e_ms
emus66821682emus
ends56528522ends
eng46726782eng_
ens37245922e_ns
eons46638712eons
epos66723732epos
eras45441502eras
erg45531072erg_
ergo56420152ergo
erns45428232erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyes75837882eyes
fags86939122fags
figs85332642figs
fogs87035002fogs
fugs85730692fugs
gags66441062gags
gas48870252_gas
geds66730812geds
gees55647882gees
gels56836102gels
gems75329112gems
gens55740072gens
gets55442482gets
gigs66631182gigs
gos47155132_gos
hags86740842hags
hoggs107212462hoggs
hogs87139662hogs
hugs86129752hugs
igg57116792igg_
jaggs148111492jaggs
jags126132792jags
jigs126524762jigs
jogs127129332jogs
jugs125525602jugs
kegs95824022kegs
lags56546222lags
leges64427292leges
leggy105210242leggy
legs56133692legs
logs57343112logs
lugs55233522lugs
mags75444532mags
megs75530632megs
miggs96311372miggs
migs76935322migs
mogs75439332mogs
muggs94912322muggs
mugs76232042mugs
nags55436022nags
negs55727362negs
negus64513562negus
noggs75811182noggs
nogs56534612nogs
peags86122842peags
pegs75531762pegs
pigs76634222pigs
pugs76332772pugs
raggs75216472raggs
rags55448372rags
reges65628792reges
regs55436572regs
rigs55137592rigs
rugs56033682rugs
sags55948402sags
segos64919482segos
segs54933882segs
tags55545232tags
tegg65315922tegg_
tegs56031492tegs
togs57242432togs
tugs56231672tugs
ughs85410972ughs
veges94118872veges
vigs85427272vigs
vuggs10579132vuggs
vugs87022872vugs
wags86140552wags
wigs84931252wigs
wogs86531402wogs
yags86632292yags
yegg96511792yegg_
zags146826682zags
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 Limit298721560.89033564.0
3Display Results1561560.0463391.3
 (SQL Overall)1786911561.216146949.8
 
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.