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

158 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
lanoline831195(None) 
landline9311441landline
lanolin7310641lanolin_
lanolines939981lanolines
lanolins8310531lanolins
aniline7418472_aniline
gantline9410902gantline
gasoline938522gasoline
kaoline11310142ka_oline
landlines1039762landlines
longline938762longline
mandoline1248412mandoline
airline7315033_airline
alanine7316863alan__ine
aline57243153_a__line
alkaline12168283alkaline
aneling82719503_aneling
anglice1089213_anglice
angling92816043_angling
anguine839913_anguine
anilin6417793_anilin_
anilines8415143_anilines
anilins7416793_anilins
ankling122912063_ankling
anodize1738683_anodize
anodyne1144163_anodyne
anoint6423633_ano_int
anole55330383_anol__e
anolyte10159003_anolyte
anomie83215963_anomi_e
antlike11312073_antlike
apolune945283_apolune
baculine1238983baculine
balkline1437973balkline
banalize191010933banalize
bantling112612003bantling
baseline10310753baseline
buntline10198063buntline
cajoling18318423cajoling
canaling112016413canaling
canalise10816213canalise
canalize19914493canalize
candling122313873candling
canine83826703can__ine
canoeing11310213canoeing
canonise10511093canonise
canonize1959833canonize
carline93923623ca_rline
caroling113317003caroling
cauline92215603ca_uline
choline122915383_choline
crinoline1147773crinoline
dandling112511733dandling
dangling112611233dangling
dateline9810363dateline
eanling81416673ean_ling
fanglike1636823fanglike
fanlike142610503fan_like
fanzine1937123fan_zine
flatline11298923fla_tline
gangling112411403gangling
gantlines1039333gantlines
gaoling93314653ga_oling
gasolene945553gasolene
gasolines1047483gasolines
guanosine1044303guanosine
hairline1137873hairline
halocline1445343halocline
halolike1537403halolike
handlike1639153handlike
handling132312713handling
hardline12310273hardline
incline9314643_incline
inosine7314283_inosine
isoline7314013_isoline
jangling17249623jangling
jawline17137063ja_wline
kaolin1039583ka_olin_
kaolines1239293ka_olines
kaolins1139363ka_olins
labeling11311653labeling
laboring112110143laboring
laborite10410703laborite
lacelike1438493lacelike
ladling92813393la_dling
ladylike1634683ladylike
lakelike1137383lakelike
lalling83519633la_lling
lamblike1636153lamblike
lancing103314123lan_cing
landing92819323lan_ding
landside10147443landside
landslide1184273landslide
langsyne1242823langsyne
lanose6313593lano__se
lanosity1146353lanosity
lardlike1336503lardlike
larine63927043la__rine
latrine7715133la_trine
laughline1342913laughline
lauwine1036373la_uwine
lavalike1536283lavalike
lawine93316463la__wine
lawlike14137073la_wlike
lazulite1745033lazulite
leonine7311233l_eonine
leporine1049303leporine
lifeline11167663lifeline
linelike12159003linelike
linguine937593linguine
lionlike1234983lionlike
lobeline1039963lobeline
longlines1047983longlines
mainline1039863mainline
maline84529093ma__line
mandolin1148583mandolin_
mandolines1347103mandolines
mandolins1248433mandolins
mangling122312623mangling
manlike133012783man_like
mantling112012613mantling
marline93320973ma_rline
moline84422033__moline
monocline1347793monocline
monokine1448483monokine
online6315843_on_line
paneling111013633paneling
pangolin1147773pangolin_
pangolins1247373pangolins
paroling113316213paroling
parvoline1477173parvoline
pavonine1346663pavonine
pemoline12310273pemoline
picoline12310853picoline
plantlike1544943plantlike
proline92321593_proline
quinoline1845123quinoline
ralline73518413ra_lline
rankling132610113rankling
ratline74517803ra_tline
saline65132703sa__line
sandlike1339713sandlike
sandling102214413sandling
sanguine947633sanguine
sanidine939853sanidine
santolina946263santolina
saponine1039223saponine
syncline1356073syncline
taborine102510683taborine
tagline82412453ta_gline
tangling101712543tangling
tangolike1453843tangolike
tanklike1136013tanklike
tapeline10310363tapeline
valine94623093va__line
vaseline1138613vaseline
wangling132310993wangling
xanthine1847253xanthine

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621586.53022383.2
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.02925422.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.