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

123 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
weblogs133422(None) 
weblog1234221weblog_
beclogs1237072beclogs
blogs85319232__blogs
webless1237002webless
analogs82810453analogs
apologs1038593apologs
beblood12106083beblood
bebloods13115233bebloods
bebops1237623beb_ops
beclog1136863beclog_
beflags1355493beflags
befogs1246453be_fogs
bellows124313303bellows
belongs10408223be_longs
belons84119413be_lons
belows114614183be_lows
biogs85016113__biogs
blobs95620033__blobs
blocs95219653__blocs
blog75723823__blog_
blots75626173__blots
blows105423833__blows
bogs75742753__b_ogs
cellos84517803cello_s
celoms10412123ce_loms
clogs85519553__clogs
cologs96517353_cologs
debags104211063deb_ags
debtors1038533debtors
debugs10467823deb_ugs
decalogs1245633decalogs
defogs1156683de_fogs
deploys1336523deploys
dialogs938103dialogs
doblons1037043doblons
duologs935363duologs
ebons74316093_eb_ons
ebooks12358333_ebooks
elbows1196713_elbows
epilogs1076583epilogs
eulogy1035633_eulogy
felloes104114383felloes
fellows134212433fellows
felons93615763fe_lons
flogs95919963__flogs
geology12257323geology
helloes103717463helloes
hellos95321683hello_s
helos84928063he_lo_s
helots95217703he_lots
isologs837433isologs
jealous1438093jealous
jellos134714283jello_s
jetlags1533863jetlags
keblahs1634563keblahs
kebobs14427293keb_obs
logs57343113___logs
mellows123812233mellows
melons84117713me_lons
merlons93311273merlons
merlots92710123merlots
nebulous1045093nebulous
neology11238293neology
oblongs1033533_oblongs
peplos101211543peplo_s
prologs103512133prologs
pueblos1134843pueblo_s
putlogs1065083putlogs
rebloom1145663rebloom
reblooms1244283reblooms
rebooks134010513rebooks
reboots93512093reboots
rebops10311433reb_ops
redlegs936823redlegs
reflags1156953reflags
reflows13258983reflows
regloss8218023regloss
reglows11288843reglows
replots93412633replots
replows12329703replows
sawlogs1135393sawlogs
seadogs958643seadogs
slogs64521843__slogs
sublots92410913sublots
teflons1036543teflons
telos55424523te_lo_s
temblors1244463temblors
theologs1246153theologs
unclogs1036803unclogs
wallops123410413wallops
wallows133613533wallows
waterlogs1345383waterlogs
weakons14287803weakons
wealds10459103weal_ds
weals85428743weal__s
wealths13365813wealths
weapons12278603weapons
weasons102310583weasons
webbings1633243webbings
webcams1643073webcams
webers11310943web_ers
webfoot1544213webfoot
weblike1635923weblike
webpage1543133webpage
webpages1643053webpages
webs96622123web___s
webwork1944843webwork
webworks2044663webworks
webworm1744313webworm
webworms1843763webworms
wedlock1744553wedlock
wedlocks1844393wedlocks
weldors11238003weldors
welds94719163we_l_ds
wellies103719073wellies
wells85426193we_l_ls
welts85225193we_l_ts
willows13299753willows
wogs86531403w___ogs
yellows13329603yellows
zealots1636763zealots
zealous1637813zealous

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.423422437.4
2DLD Change Limit1340271237.14018771.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.60923484.2
 
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.