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

152 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
lanolin731064(None) 
lanoline8311951lanoline
lanolins8310531lanolins
anilin6417792_anilin
kaolin1039582ka_olin
landline9311442landline
lanolines939982lanolines
mandolin1148582mandolin
pangolin1147772pangolin
aeolian738633_aeolian
aioli5318313_aioli_
aiolis6316843_aiolis
alanin6317273alan__in
alkalin11178183alkalin
aloin55227423_alo_in
aneling82719503_aneling
angling92816043_angling
aniline7418473_aniline
anilins7416793_anilins
ankling122912063_ankling
anodic92813133_anodic
anoint6423633_ano_int
anole55330383_anol_e
anoles64827433_anoles
anomic102516303_anomic
anomie83215963_anomie
anon46134853_ano__n
anopia83412393_anopia
anoxia133510023_anoxia
anoxic152610673_anoxic
antlion7310293_antlion
bantling112612003bantling
cajoling18318423cajoling
canakin131810833canakin
canaling112016413canaling
candling122313873candling
canikin13189753canikin
cannoli937263cannoli_
cannolis1037863cannolis
canoeing11310213canoeing
canola8313623canol_a
canolas9313993canolas
canon74725303cano__n
canonic11312933canonic
canopic1338803canopic
capelin11510973capelin
caplin103216303ca_plin
carlin84421823ca_rlin
caroli85918233caroli_
caroling113317003caroling
carotin92216733carotin
catlin83819083ca_tlin
cipolin1148783cipolin
colin76231693__colin
dandling112511733dandling
dangling112611233dangling
dunlin739723dun_lin
eanling81416673ean_ling
enolic8413353_enolic
fanon84619013fano__n
francolin1443783francolin
franklin15104603franklin
ganglia946613ganglia
gangling112411403gangling
ganglion1044393ganglion
ganoid8314443gano_id
gantline9410903gantline
gaoling93314653ga_oling
gasoline938523gasoline
glonoin875673glono_in
handling132312713handling
inulin6311733_inulin
jacobin1844393jacobin
jangling17249623jangling
javelin17306983javelin
kaoline11310143ka_oline
kaolins1139363ka_olins
labeling11311653labeling
laboring112110143laboring
laconic1139883laconic
ladling92813393la_dling
ladykin1543963ladykin
lagoon7410483lago_on
lain46146283la___in
lallan63414183la_llan
lalling83519633la_lling
lambkin1545243lambkin
laminin939973laminin
lanai5319573lan_ai_
lanais6316793lan_ais
lancing103314123lan_cing
landing92819323lan_ding
landler84113203landler
landlines1039763landlines
landman1038923landman
landmen1038553landmen
landslid1085303landslid
landslip1184263landslip
lanely93914483lanel_y
langley1147453langley
languid936623languid
lankily1437123lankily
lankly13439623lankl_y
lanose6313593lano_se
lanosity1146353lanosity
lantern7310013lantern
lapin75222923la__pin
lattin64316223la_ttin
layin84720333la__yin
lazuli1535363lazuli_
lazulis1634903lazulis
levulin1044663levulin
lianoid837533liano_id
linin58025523lin__in
login66025003l__ogin
loin46838723l__o_in
longline938763longline
lupulin945003lupulin
luteolin844533luteolin
magnolia1144793magnolia
manakin131810643manakin
mandoline1248413mandoline
mandolins1248433mandolins
mangling122312623mangling
manikin132110243manikin
mantling112012613mantling
marlin84220913ma_rlin
maudlin1037163maudlin
nandin7313033nan_din
nankin1039673nan_kin
paneling111013633paneling
pangolins1247373pangolins
paroling113316213paroling
parvolin1376933parvolin
paulin8312983pa_ulin
picolin11310883picolin
plantain1047903plantain
quinolin1744593quinolin
rankling132610113rankling
ratlin64116523ra_tlin
ravelin102211023ravelin
sandling102214413sandling
santolina946263santolina
santonin849703santonin
saponin9310263saponin
taborin92210453taborin
tangling101712543tangling
tannin62613933tan_nin
vanillin1145913vanillin
violin9311983_violin
wangling132310993wangling
xanthin1747043xanthin

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.406440125.6
2DLD Change Limit1340271526.69020033.9
3Display Results1521520.0602533.3
 (SQL Overall)1786911527.15624970.8
 
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.