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

204 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
ego4672605(None) 
ago48845521ago
egg56918671egg
egos55821651egos
ergo56420151ergo
go38748741_go
sego56525181sego
abo59045962abo
ado49146872ado
aero45435342aero
ag311067462ag_
aga410447232aga
age47154332age
agio57828452agio
agog68019002agog
agon56531882agon
ags47551662ags
apo511142122apo
avo68936232avo
azo128233392azo
beg65944132beg_
begot84625952begot
begs75733832begs
bio57846082bio
bo410957572_bo
bog67852412bog
boo58163662boo
bro56236602bro
cero66329452cero
cog69552902cog
coo59566362coo
dago65725082dago
deco76125972deco
demo77427552demo
do310155252_do
dog57449752dog
duo48536142duo
ear36867882ear
eat36989052eat
eau37450942eau
ebb72418632ebb
ebon66821102ebon
echo96615952echo
ecu56828232ecu
ed38645182e_d
eddo63411802eddo
edge65719662edge
edgy94713522edgy
edh76921562edh
eds46638922eds
eek77935102eek
eel37946842eel
ef57345362e_f
eff96128622eff
efs66829602efs
eft66038822eft
egad64215412egad
egal55119432egal
eger55923562eger
eggs66516152eggs
eggy96611852eggy
egis56520652egis
eh58339962e_h
eke75630092eke
el26745292e_l
eld46733792eld
elf66138522elf
elk76726122elk
ell36735682ell
elm57531742elm
els37645722els
em49445152e_m
eme55837182eme
ems56435492ems
emu55929982emu
en28052392e_n
end46834352end
eng46726782eng
engs56121392engs
enol45823822enol
enow77819872enow
ens37245922ens
eon36052082eon
epos66723732epos
er28345142e_r
era35741502era
ere36352772ere
erg45531072erg
ergot65422892ergot
ergs55523812ergs
ern35738352ern
eros45238452eros
err35626532err
ers36046282ers
erugo6369852erugo
es29048222e_s
ess36030882ess
et26964192e_t
eta35834192eta
eth66630982eth
euro45325272euro
eve66331162eve
ewe66630982ewe
ex98835642e_x
exon117116802exon
expo1349182expo
eye65539772eye
fog76945562fog
fro65530642fro
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gen45950512gen
get47467462get
gey75738302gey
goa47343802_goa
gob68950892_gob
god57449792_god
gogo69722832gogo
goo47754772goo
gor47848262_gor
gos47155132_gos
got49870442_got
gox117137182_gox
goy77844552_goy
grego7310522grego
hao67251122hao
helo75332852helo
hero74635782hero
ho510258272_ho
hog78049062hog
igg57116792igg
jo99539602_jo
jog117438312jog
keg86432532keg_
kegs95824012kegs
keno87926432keno
keto86223452keto
leg46446112leg_
legs56133692legs
leno47331392leno
levo76820062levo
lo28053442_lo
log46252682log
logo57931762logo
loo38359822loo
meg66040952meg_
mega77620872mega
megs75530632megs
memo85924792memo
meno66031352meno
mho86624622mho
mo49158482_mo
mog66949672mog
moo58460512moo
neg47237342neg_
negs55727362negs
no29353242_no
nog46847312nog
noo37154042noo
oho66534382oho
ono36838032ono
oxo107322962oxo
peg65843062peg_
pegs75531762pegs
pengo84317592pengo
pepo87622152pepo
peso66925822peso
poo57757112poo
pro55837262pro
redo56029362redo
reg46146492reg_
regs55436572regs
repo66027542repo
rho65924832rho
sago56332672sago
seg45544882seg_
segno64814742segno
segos64919482segos
segs54933882segs
so28855442_so
tao38358952tao
teg45741622teg_
tegg65315922tegg
tegs56031492tegs
tho67433962tho
to218858982_to
tog410255042tog
too38965422too
two67925832two
udo49027302udo
ugh76520682ugh
upo58925862upo
veg76931062veg_
veto76622992veto
who95526772who
wo510447762_wo
wog76242732wog
woo66949802woo
yegg96511792yegg
yo59748552_yo
zero134822462zero
zoo126238912zoo

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 Filter178691140840.1101624463.6
2DLD Change Limit140842040.87316132.9
3Display Results2042040.0802550.0
 (SQL Overall)1786912041.063168100.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.