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

120 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
ebon6682110(None) 
ebons74316091ebons
ebony104511511ebony
eon36052081e_on
exon117116801exon
abo59045962abo_
aboon74918702aboon
abos67734412abos
aeon45634612aeon
agon56531882agon
anon46134852anon
axon115524302axon
azon135725052azon
ban58366842_ban
bean66443862bean
bebop11410792bebop
been65335782been
belon73924112belon
ben56554922_ben
beton76022062beton
bin56658642_bin
bo410957572_bo_
boa56954032_boa
bob76755672_bob
bod67055542_bod
bog67852412_bog
bond75334362_bond
bone65949322_bone
bong75633412_bong
bonk105531712_bonk
bony96732082_bony
boo58163662_boo
boon67142172boon
bop77549482_bop
born67338412_born
bos57966812_bos
bot59680402_bot
bow87051902_bow
box1210142342_box
boy87753562_boy
bun56348142_bun
chon96627792chon
cion613330912cion
clon66232482clon
con510268022_con
coon67248942coon
debone93714782debone
demon86520312demon
devon95113682devon
don46757652_don
earn46737552earn
ebb72418632eb_b
ebbs82411992ebbs
ebook114510802ebook
ego46726052ego_
egos55821652egos
eikon939462eikon
elan46734242elan
elbow10117702elbow
eloin55923202eloin
embow1297562embow
en28052392e__n
enol45823822enol
enow77819872enow
eons46638712e_ons
epos66723732epos
ern35738362e_rn
eros45238452eros
even75222272even
exons125813342exons
eyen76223662eyen
felon84619292felon
fon66352272_fon
goon57236172goon
heron85025502heron
hon67759382_hon
icon66922042icon
ikon85814952ikon
ion36051022_ion
iron46728462iron
jeon116821442jeon
jeton124815402jeton
kaon87521022kaon
kebob135110922kebob
leben7314852leben
lemon75618182lemon
lion46334442lion
loon47344792loon
melon73922082melon
meson74118312meson
mon57561582_mon
moon67140812moon
muon65722732muon
neon47026422neon
noon47134622noon
oboe66822942oboe
obol65220612obol
on28057182__on
pelon74423212pelon
peon65635242peon
phon95925382phon
pion67235292pion
poon67341262poon
rebop9313282rebop
reborn810016962reborn
recon75624242recon
redon65424882redon
rewon86920582rewon
seton55223542seton
son37761952_son
soon46240502soon
tenon53320512tenon
ton310265102_ton
toon47740632toon
udon56017742udon
upon65817582upon
won66252062_won
xenon122612452xenon
yon67348952_yon
zoon137326982zoon

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.310576422.6
2DLD Change Limit298721200.87634100.5
3Display Results1201200.0304000.0
 (SQL Overall)1786911201.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.