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

153 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
lobeline103996(None) 
lobelines1138561lobelines
globelike1643852globelike
labeling11311642labeling
libeling1139872libeling
lifeline11167662lifeline
lobefin1244602lobefin_
lobefins1344822lobefins
lobelia947212lobeli_a
lobelias1047202lobelias
longline938762longline
lovevine1444112lovevine
obelise9310172_obelise
obelize1838242_obelize
zibeline1946362zibeline
adobelike1642503adobelike
baseline10310753baseline
beeline93314723_beeline
belie75630383__beli_e
belike124616283__belike
belive115415303__belive
berline93716853__berline
bloodline1245173bloodline
blueline1036873blueline
bobbling12238643bobbling
bobolink1644493bobolink
boweling143410683boweling
bowline123613113bo_wline
bubaline1247163bubaline
byline11311643__byline
cobaltine13135613cobaltine
cobbling15248803cobbling
codeine103815033code_ine
cokelike1336813cokelike
compline14313553compline
corbeling1439033corbeling
covelline1446533covelline
dateline9810353dateline
domelike15177753domelike
dovelike16157133dovelike
doweling13279763doweling
feline94820143__feline
globalise1245153globalise
globalize2144763globalize
globulin1144193globulin_
globulins1244173globulins
gobbling14257533gobbling
goblin939503gob_lin_
goblins1039243gob_lins
hobbling16227583hobbling
hoblike16158303hob_like
hoelike141411163ho_elike
homelike17179533homelike
hoselike15179643hoselike
hotline10712353ho_tline
hoveling15189593hoveling
labelling1238083labelling
lacelike1438493lacelike
lakelike1137383lakelike
landline9311443landline
lanoline8311953lanoline
leveling122910433leveling
libelant1048563libelant
libelee92510983libel_ee
libelist10310823libelist
libellee10227733libellee
libelling1236873libelling
libertine1147433libertine
lifelike15166223lifelike
lifelines12147053lifelines
linelike12159003linelike
lobbing123110913lob_bing
lobbying1633603lobbying
lobulate1078833lobulate
lobule82910063lobul__e
lobulose1044033lobulose
localise101511853localise
localite101411543localite
localize191410483localize
loftlike1534393loftlike
lolling83415773lo_lling
lomein8410203lome_in_
lomeins969483lome_ins
lonelier838003lonelier
lonelily1144973lonelily
loneliness1046083loneliness
longlines1047983longlines
lordlike1345813lordlike
lordling1077743lordling
lovelier1136433lovelier
lovelies1139893lovelies
lovelily1444333lovelily
loveliness1345303loveliness
lovevines1544003lovevines
lowering122210913lowering
lowlife1335143lo_wlife
mobilise1248143mobilise
mobilize2158023mobilize
modeling12311073modeling
moline84422033mo__line
myeline1238253_myeline
nobbling13228273nobbling
nobelium1245713nobelium
nonelite8313613nonelite
noselike12158573noselike
novelise1137953novelise
novelize2046843novelize
obeli73711933_obeli__
obelia8329453_obeli_a
obelias9279033_obelias
obelised1136173_obelised
obelises1039103_obelises
obelisk1345193_obelisk
obelism1138203_obelism
obelized2036333_obelized
obelizes1937513_obelizes
obeying1336543_obeying
oblige937653_ob_lige
offline1345783_offline
olefine1038023_olefine
oleine6313793_ole_ine
online6315843_o_nline
opaline9412483_opaline
outline72321333_outline
pipeline12149503pipeline
plotline1037643plo_tline
popelike16177853popelike
potline91015233po_tline
reline65434353__reline
roofline1136193roofline
ropelike14157853ropelike
roselike12169183roselike
roweling122811123roweling
shoreline1246623shoreline
sideline91011093sideline
sobering111912783sobering
soberize1998883soberize
subline9316893sub_line
tapeline10310363tapeline
timeline1039243timeline
toelike11149823to_elike
topline92313183to_pline
toweling122910373toweling
towline102911543to_wline
tubelike1436093tubelike
vaseline1138613vaseline
vomerine1347683vomerine
vowelize2344763vowelize
wobbling16246923wobbling
wobegone1443003wobegone
yodeling1357673yodeling
zibelines2045733zibelines
zibelline2044303zibelline

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621536.34323043.0
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.82926166.5
 
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.