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

114 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
belon7392411(None) 
belong93411041belong
belons84119411belons
below104617191below
beton76022061beton
felon84619291felon
melon73922081melon
pelon74423211pelon
aeon45634612ae_on
azlon144312872azlon
bacon95620592bacon
ballon84117492ballon
baron78131242baron
baton75822422baton
beacon10511372beacon
bean66443862be_an
beano75421552beano
bebop11410792bebop
beckon14309382beckon
beclog1136862beclog
beclown1435422beclown
been65335782be_en
befog1159012befog
began86319572began
begin85117352begin
begone9512132begone
begot84625952begot
begun85113442begun
bel57148462bel__
belay105021522belay
belch124415502belch
belga8313232belga
belie75630382belie
bell66237182bel_l
belle75827832belle
bellow114213352bellow
bells76432162bells
belly104625492belly
belongs10408222belongs
belows114614182belows
bels66142492bel_s
belt65754032bel_t
belts75931162belts
bemoan10310252bemoan
ben56554922be__n
berlin83116372berlin
besom95716972besom
besot76429712besot
betons84919552betons
betony114211582betony
bevor101510812bevor
beyond1237072beyond
billon83713832billon
bison75716982bison
blin67228172b_lin
blob86027092b_lob
bloc85023272b_loc
blog75723822b_log
blond85618372b_lond
blot65842322b_lot
blow95827192b_low
blown105716672b_lown
bolo65535952bolo_
bolos75531372bolos
bolson8410682bolson
boon67142172b_oon
boron76727142boron
boson76019732boson
celom9515692celom
clon66232482_clon
colon78630192colon
demon86520312demon
devon95113682devon
ebon66821102_ebon
elan46734242_elan
eloin55923202_eloin
eon36052082_e_on
exon117116802_exon
felons93615762felons
felony123710322felony
halon86124862halon
helo75332852helo_
helos84928062helos
helot85332682helot
heron85025502heron
jeon116821442je_on
jeton124815402jeton
kelson1038152kelson
lemon75618182lemon
melons84117712melons
melton8311552melton
merlon83012352merlon
meson74118312meson
nelson638422nelson
neon47026422ne_on
nylon82910512nylon
orlon5415002orlon
peon65635242pe_on
pleon74216382pleon
pylon103614002pylon
recon75624242recon
redon65424882redon
reloan6415692reloan
rewon86920582rewon
salon55228552salon
seton55223542seton
solon55026132solon
talon55824112talon
teflon937452teflon
teloi54217382teloi
telos55424522telos
telson6310292telson
tenon53320512tenon
xenon122612452xenon

Search took 3 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 Filter178691538000.360496363.9
2DLD Change Limit538001141.78030224.7
3Display Results1141140.0333454.5
 (SQL Overall)1786911142.17382232.4
 
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.