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

166 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
egg5691867(None) 
eggs66516151eggs
eggy96611851eggy
ego46726051ego
eng46726781eng
erg45531071erg
igg57116791igg
tegg65315921tegg
yegg96511791yegg
ag311067462_ag
aga410447232aga
age47154332age
ago48845522ago
agog68019002agog
ags47551662ags
bag67059222bag
beg65944132beg
begs75733832begs
berg75425542berg
big67345722big
bog67852412bog
bug65340742bug
cig67036182cig
cog69552902cog
dag57753012dag
dig57544472dig
dog57449752dog
dug58138692dug
ear36867882ear
eat36989052eat
eau37450942eau
ebb72418632ebb
ecu56828232ecu
ed38645182e_d
edge65719682edge
edgy94713532edgy
edh76921562edh
eds46638922eds
eek77935102eek
eel37946842eel
ef57345362e_f
eff96128622eff
efs66829602efs
eft66038822eft
egad64215412egad
egal55119432egal
eger55923572eger
eggar7458882eggar
egged85114392egged
egger74414412egger
egis56520652egis
egos55821652egos
eh58339962e_h
eke75630092eke
el26745292e_l
eld46733792eld
elf66138522elf
elk76726122elk
ell36735682ell
elm57531742elm
els37645722els
em49445152e_m
eme55837182eme
ems56435492ems
emu55929982emu
en28052392e_n
end46834352end
engs56121392engs
ens37245922ens
eon36052082eon
er28345142e_r
era35741502era
ere36352772ere
ergo56420152ergo
ergs55523812ergs
ern35738352ern
err35626532err
ers36046282ers
es29048222e_s
ess36030882ess
et26964192e_t
eta35834192eta
eth66630982eth
eve66331162eve
ewe66630982ewe
ex98835642e_x
eye65539772eye
fag76852362fag
fig76242832fig
fog76945562fog
fug76234512fug
gag57753632gag
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gen45950512gen
get47467462get
gey75738302gey
gig56040752gig
go38748742_go
hag77255742hag
hog78049062hog
hogg96617532hogg
hug76037362hug
iggs66612672iggs
jag116542712jag
jagg136115312jagg
jig115633512jig
jog117438312jog
jug115529542jug
keg86432542keg
kegs95824022kegs
lag47862122lag
leg46446112leg
leggy105210242leggy
legs56133692legs
log46252682log
lug46138062lug
mag67956482mag
meg66040952meg
mega77620872mega
megs75530632megs
mig65646082mig
migg85716802migg
mog66949672mog
mug65837692mug
mugg86316012mugg
nag46450812nag
neg47237342neg
negs55727362negs
nog46847312nog
nogg65115942nogg
peag75431342peag
peg65843062peg
pegs75531762pegs
pig65744972pig
pug65337182pug
rag45761322rag
ragg65622692ragg
reg46146492reg
regs55436572regs
rig46748122rig
rug46039152rug
sag46163402sag
seg45544882seg
sego56525182sego
segs54933882segs
tag47259492tag
teg45741622teg
teggs74710742teggs
tegs56031492tegs
tog410255042tog
tug45937402tug
ugh76520682ugh
veg76931062veg
vig75637522vig
vug76127412vug
vugg95612712vugg
wag76451752wag
wig76740382wig
wog76242732wog
yag76947732yag
yeggs10608162yeggs
zag137539472zag
zig136931902zig

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140841660.37637457.4
3Display Results1661660.0305533.3
 (SQL Overall)1786911660.656272394.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.