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 “beclown” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
beclown143542(None) 
beclowns1544681beclowns
beckon14309382becko_n
becloak1545042becloak
beclog1136862beclo_g
beclogs1237072beclogs
becloud1246292becloud
beclowned1743252beclowned
becrowd1555182becrowd
bedgown1443772bedgown
bellow114213352bellow_
bellows124313302bellows
belon73924112be_lo_n
below104617192be_low_
belows114614182be_lows
blown105716672b__lown
clown105214732__clown
decrown13206052decrown
recrown12257572recrown
reflown13316212reflown
baclofen1543103baclofen
bacon95620593bac_o_n
ballon84117493ballo_n
balloon93711433balloon
barlow112911423barlow_
barlows12259973barlows
beacon10511373beaco_n
beblood12106083beblood
beckons15279143beckons
beclasp1335263beclasp
becloaks1644933becloaks
beclothe1545023beclothe
beclouds1345373beclouds
beclowning1843423beclowning
become123312593bec_ome
becrawl1444583becrawl
becrowds1683773becrowds
bedgowns1543113bedgowns
beflower16166273beflower
begloom1255243begloom
begroan1036103begroan
behowl1445533be_howl
bellman1137183bellman
bellmen1138143bellmen
bellowed14158603bellowed
bellower13159063bellower
bellowing1547193bellowing
belong93411043be_long
belons84119413be_lons
bemoan10310253be_moan
benzoin1846263benzoin
berlin83116373berl_in
besnow1145713besnow_
besnows1245153besnows
bestow1149463bestow_
bestows1248863bestows
bestrown1345203bestrown
bethorn1238643bethorn
beton76022063be_to_n
bicorn103610103bic_orn
bicron103710773bicro_n
billon83713833billo_n
billow114111223billow_
billows123611293billows
billowy15366903billowy
blawn106813703b__lawn
blow95827193b__low_
blows105423833b__lows
blowy134315323b__lowy
brown105619533b__rown
clon66232483__clo_n
clowns114810113__clowns
crown105620083__crown
declaw1266703declaw_
declaws1336253declaws
decrowns14265063decrowns
eloin55923203_e_loin
fellow123712743fellow_
fellows134212433fellows
felon84619293fe_lo_n
flown116213993__flown
letdown1144263letdown
lown76929293___lown
mellow114112223mellow_
mellows123812233mellows
melon73922083me_lo_n
merlon83012353merlo_n
newmown1542283newmown
pelon74423213pe_lo_n
reckon123010543recko_n
reclean938523reclean
recoin84320293rec_oin
recon75624243rec_o_n
recrowns13246143recrowns
reflow12379653reflow_
reflows13258983reflows
reglow10339403reglow_
reglows11288843reglows
regrown11237363regrown
reloan6415693re_loan
renown9369983re_nown
replow114210343replow_
replows12329703replows
reshown13257903reshown
resown94112923re_sown
teflon937453teflo_n
uncrown1236323uncrown
yellow12429883yellow_
yellows13329603yellows
yellowy16255693yellowy

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271106.54620474.6
3Display Results1101100.0333333.3
 (SQL Overall)1786911106.98225593.1
 
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.