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

139 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
weblog123422(None) 
weblogs1334221weblogs
beclog1136862beclog
blog75723822__blog
analog7159973analog
apolog938903apolog
beblood12106083beblood
bebop11410793beb_op
beclogs1237073beclogs
beflag1265883beflag
befog1159013be_fog
bellow114213353bellow
belon73924113be_lon
belong93411043be_long
below104617193be_low
biog76122323__biog
blob86027093__blob
bloc85023273__bloc
blogs85319233__blogs
blot65842323__blot
blow95827193__blow
bog67852413__b_og
cello74919583cello_
cellos84517803cellos
celom9515693ce_lom
clog76123243__clog
colog86619933_colog
debag94212303deb_ag
debtor938333debtor
debug94210063deb_ug
decalog1136003decalog
defog1048523de_fog
deploy1237583deploy
dialog837973dialog
doblon938013doblon
duolog835803duolog
ebon66821103_eb_on
ebook114510803_ebook
elbow10117703_elbow
epilog976463epilog
eulogy1035633_eulogy
felloe93513923felloe
fellow123712743fellow
felon84619293fe_lon
flog85523893__flog
geology12257323geology
hello86522983hello_
hellos95321683hellos
helo75332853he_lo_
helos84928063he_los
helot85332683he_lot
isolog737403isolog
jello126716273jello_
jellos134714283jellos
jetlag1434523jetlag
keblah1545313keblah
kebob135110923keb_ob
log46252683___log
mellow114112223mellow
melon73922083me_lon
merlon83012353merlon
merlot83217613merlot
neology11238293neology
oblong935383_oblong
pelon74423213pe_lon
peplos101211543peplos
prolog94212973prolog
pueblo1035553pueblo_
pueblos1134843pueblos
putlog965553putlog
rebloom1145663rebloom
rebook125213203rebook
reboot84119333reboot
rebop9313283reb_op
redleg839273redleg
reflag1098083reflag
reflow12379653reflow
reglow10339403reglow
replot83818593replot
replow114210343replow
sawlog1035793sawlog
seadog838743seadog
semilog1046003semilog
slog56728273__slog
sublot82315523sublot
teflon937453teflon
teloi54217383te_loi
telos55424523te_los
temblor1144093temblor
theolog1146153theolog
unclog956603unclog
wallop113310293wallop
wallow123913513wallow
waterlog1245043waterlog
weakon13357623weakon
weal75838683weal__
weald95615023weal_d
wealds10459103wealds
weals85428743weal_s
wealth12379223wealth
weapon11288113weapon
weason93210823weason
web85735563web___
webbed1436433webbed
webbing1536123webbing
webby1537153web_by
webcam1545543webcam
weber10313523web_er
webers11310943webers
webfed1535033webfed
webfoot1544213webfoot
webless1237003webless
weblike1635923weblike
webpage1543133webpage
webs96622123web__s
webwork1944843webwork
webworm1744313webworm
wedlock1744553wedlock
weeklong1641323weeklong
weel75834083weel__
welch134411493we_lch
weld84727733we_l_d
weldor10317653weldor
welds94719163we_lds
well75832043we_l_l
welled103820213welled
wellie92814913wellie
welling112920313welling
wells85426193we_lls
welly114620013we_lly
welsh113110363we_lsh
welt75547863we_l_t
welts85225193we_lts
wetly114511713wetl_y
whilom1436133whilom
willow12369693willow
wog76242733w___og
yellow12429883yellow
zealot15313473zealot

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161395.37320978.2
3Display Results1391390.0463021.7
 (SQL Overall)1786911395.79530835.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.