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

145 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
lanolins831053(None) 
lanolin7310641lanolin_
lanoline8311951lanoline
lanolines939981lanolines
anilins7416792_anilins
kaolins1139362ka_olins
landline9311442landline
landlines1039762landlines
mandolins1248432mandolins
pangolins1247372pangolins
ablins8316193_a_blins
aiblins9311473_aiblins
aiolis6316843_aioli_s
alanins7315803alan__ins
aloins65022203_alo_ins
aneling82719503_aneling
angling92816043_angling
anglings10228273_anglings
anilin6417793_anilin_
aniline7418473_aniline
anilines8415143_anilines
ankling122912063_ankling
anoint6423633_ano_int
anoints7311063_ano_ints
anoles64827433_anol_es
anomies93316993_anomies
anopias92412483_anopias
anoxias14259113_anoxias
antlions839193_antlions
bantling112612003bantling
bantlings12216603bantlings
cajoling18318423cajoling
canakins142010463canakins
canaling112016413canaling
candling122313873candling
canikins14219163canikins
cannolis1037863cannoli_s
canoeing11310213canoeing
canolas9313993canol_as
canons85522063cano__ns
canopies12311853canopies
capelins12311133capelins
caplins113515993ca_plins
carlins93921913ca_rlins
caroling113317003caroling
carotins102315583carotins
catlins93818843ca_tlins
cipolins1238033cipolins
colins85229043__colins
dandling112511733dandling
dangling112611233dangling
dunlins849553dun_lins
eanling81416673ean_ling
eanlings9128473ean_lings
fanons96115213fano__ns
francolins1543873francolins
franklins1694763franklins
gangling112411403gangling
ganglions1144063ganglions
ganoids939333gano_ids
gantline9410903gantline
gantlines1039333gantlines
gaoling93314653ga_oling
gasoline938523gasoline
gasolines1047483gasolines
glonoins955843glono_ins
handling132312713handling
handlings14237343handlings
inulins7311493_inulins
jacobins1944193jacobins
jangling17249623jangling
javelins18277733javelins
kaolin1039583ka_olin_
kaoline11310143ka_oline
kaolines1239293ka_olines
labeling11311643labeling
laboring112110143laboring
ladling92813393la_dling
ladykins1643603ladykins
lagoons839253lago_ons
lallans74113533la_llans
lalling83519623la_lling
lambkins1664983lambkins
laminins1039133laminins
lanais6316793lan_ai_s
lancing103314123lan_cing
landing92819323lan_ding
landings103110073lan_dings
landlers94312833landlers
landless94011173landless
landslips1284013landslips
langleys1245103langleys
lanosity1146353lanosity
lanterns838303lanterns
lapins84520683la__pins
lashins103915153la_shins
lattins74115483la_ttins
layins93817653la__yins
lazulis1634903lazuli_s
levulins1144803levulins
linins65922143lin__ins
logins77820643l__ogins
loins56728423l__o_ins
longline938763longline
longlines1047983longlines
lupulins1044653lupulins
luteolins944113luteolins
magnolias1244723magnolias
manakins14209763manakins
mandolin1148583mandolin_
mandoline1248413mandoline
mandolines1347103mandolines
mangling122312623mangling
manikins14189723manikins
mantling112012613mantling
mantlings12207233mantlings
marlins93420473ma_rlins
nandins8312003nan_dins
nankins1159053nan_kins
paneling111013623paneling
panelings12107453panelings
pangolin1147773pangolin_
panoplies1346003panoplies
paroling113316213paroling
parvolins1486693parvolins
paulins9312613pa_ulins
picolins1239853picolins
plantains1147493plantains
quinolins1844793quinolins
rankling132610113rankling
ratlins73615583ra_tlins
ravelins113011603ravelins
sandling102214413sandling
sandlings11238093sandlings
santolina946263santolina
santolinas1043753santolinas
santonins948453santonins
saponins1039453saponins
taborins103310223taborins
tangling101712543tangling
tannins72813223tan_nins
vanillins1245543vanillins
violins10311453_violins
wangling132310993wangling
xanthins1846943xanthins

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.420425454.8
2DLD Change Limit1461621456.56322270.6
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.04625360.6
 
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.