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

202 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
egis5652065(None) 
aegis6316781aegis
eggs66516151eggs
egos55821651egos
agas55938842agas
ages55844592ages
agin56132712agin
agio57828452agio
agios65919862agios
agism84614062agism
agist66325582agist
ags47551662ag_s
ahis76135382ahis
ais39083572_ais
amis66445312amis
anis45746462anis
axis116127912axis
begin85117352begin
begins94415302begins
begs75733832beg_s
bigs76235012bigs
bis56860652_bis
bris65539612bris
cedis84317082cedis
chis95933312chis
cigs75625102cigs
cis57748032_cis
cris66233432cris
dais57040702dais
defis96717502defis
degas75119162degas
delis64928542delis
digs66036052digs
dis46459892_dis
ears46356592ears
eats47054872eats
ebbs82411982ebbs
ecus65421462ecus
edges75718722edges
edhs86212102edhs
edit54934862edit
edits65819032edits
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
egad64215412egad
egads74610922egads
egal55119432egal
eger55923562eger
egers65120372egers
egest65222342egest
egg56918672eg_g
eggy96611852eggy
egises7312492egises
ego46726052eg_o
egoism977472egoism
egoist7612282egoist
ekes86726602ekes
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
emic86422742emic
emir65918692emir
emirs76116152emirs
emit65438412emit
emits75421462emits
ems56435492e_ms
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epic86921302epic
epics95014282epics
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
etic66123952etic
etuis54013132etuis
eves76230462eves
evil75318072evil
evils84114262evils
ewes76328702ewes
exes116530812exes
exist124618942exist
exit114428672exit
exits125515912exits
eyas76427432eyas
eyes75837882eyes
figs85332642figs
gas48870252_gas
geds66730812geds
gees55647882gees
gels56836102gels
gems75329112gems
gens55740072gens
gets55442482gets
ghis85020162ghis
gib66443522_gib
gibs75529262_gibs
gid57047262_gid
gids65933732_gids
gie47149542_gie
gies55641422_gies
gig56040752_gig
gigs66631182_gigs
gin46055752_gin
gins55543952_gins
gip67645362_gip
gips75632922_gips
gist56046762_gist
git46266052_git
gits55744592_gits
gos47155132_gos
his66359502_his
ibis66519562ibis
iggs66612672iggs
iris45732542iris
is27048212__is
iwis77117002iwis
jigs126524762jigs
kegs95824012keg_s
kepis115313362kepis
khis117017982khis
kis78051472_kis
kois85129392kois
kris86423602kris
leges64427282leges
legist71315252legist
legit61323502legit
legits71313002legits
legs56133692leg_s
leis45739602leis
lenis56326862lenis
levis85818552levis
lewis85315842lewis
lexis125916032lexis
lis37162272_lis
megs75530632meg_s
metis75025902metis
migs76935312migs
mis58162612_mis
negs55727362neg_s
negus64513562negus
obis66226832obis
pegs75531762peg_s
penis75129322penis
peris75537072peris
phis95724902phis
pigs76634222pigs
pis56362032_pis
pois66539042pois
psis68120342psis
qis126934382_qis
ragis66325602ragis
rais45252622rais
reges65628782reges
regius7311922regius
regs55436572reg_s
reis45343232reis
rigs55137592rigs
segos64919482segos
segs54933882seg_s
seis45542392seis
semis74623532semis
sis37360542_sis
skis84825282skis
sris45434152sris
teggs74710742teggs
tegs56031492teg_s
this76027382this
tis37056642_tis
tuis44829642tuis
ughs85410972ughs
veges94118862veges
vegie94614512vegie
vegies104314272vegies
vigs85427272vigs
vis66747612_vis
wigs84931252wigs
wis66552332_wis
xis106935332_xis
yagis95416572yagis
yeggs10608162yeggs
yetis85418392yetis
yogis95617742yogis
ywis105313102ywis
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.1231452772.4
2DLD Change Limit298722021.01629401.6
3Display Results2022020.0464391.3
 (SQL Overall)1786912021.185150794.1
 
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.