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 “vaselines” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
vaselines124671(None) 
baselines1138601baselines
vaseline1138611vaseline_
baseline10310752baseline_
baseliner1144752baseliner
baseliners1243872baseliners
datelines1088862datelines
gasolines1047482gasolines
tapelines1138462tapelines
valines104520212va__lines
vaselike1536992vaselike_
adenines9310193_adenines
airlines8312793_airlines
alexines15258503_alexines
alines65735223_a__lines
anilines8415143_anilines
anserines9411293anserines
bakelites1545993bakelites
balklines1536743balklines
beelines103312803_beelines
bluelines1145833bluelines
bustlines11207353bustlines
cagelings1335413cagelings
capelins12311133capelin_s
carlines103521673ca_rlines
casefies1339213casefi_es
caseins93115053case_in_s
casernes103810753case_rnes
cassines103116613cas_sines
coastlines12125333coastlines
dateline9810363dateline_
datelined1194723datelined
eserines8413743_eserines
fascines13310143fas_cines
felines104718073__felines
fishlines15246843fishlines
gantlines1039333gantlines
gaselier946973gaseli_er
gaseliers1044943gaseliers
gasolenes1045833gasolenes
gasoline938523gasoline_
hairlines1237133hairlines
isolines8312303_isolines
jasmines1736623jas_mines
javelinas19353583javelinas
javelined2043323javelined
javelins18277733javelin_s
jawlines18126363ja_wlines
kaolines1239293ka_olines
landlines1039763landlines
lanolines939983lanolines
lifelines12147053lifelines
lobelines1138563lobelines
madeleines1343613madeleines
mainlines1138523mainlines
malines93625613ma__lines
marlines103818743ma_rlines
masculines1445513masculines
myelines1337123_myelines
nasalises948113nasalises
nasalizes1847233nasalizes
panelings12107473panelings
passerines1246163passerines
pipelines13178353pipelines
ratlines83815293ra_tlines
ravelings13377383ravelings
ravelins113011603ravelin_s
relines75331323__relines
salines74029413__salines
seines65029903__se_ines
serines74229543__serines
setlines8312743__setlines
sidelines10109683sidelines
splines94718893__splines
taglines92210833ta_glines
tapeline10310363tapeline_
timelines1148443timelines
vaccines1536503va_ccines
vahines133410523va__hines
valentines1344953valentines
valine94623093va__line_
valises103516273va__lises
velites103417303v__elites
venines103516613v__enines
viselike1536923viselike_
vitellines1394743vitellines
vowelizes2443933vowelizes
waistlines1343893waistlines
waterlines1348963waterlines
zibelines2045733zibelines

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 Filter1786911486410.423422437.4
2DLD Change Limit148641906.73322076.5
3Display Results90900.0461956.5
 (SQL Overall)178691907.20224811.3
 
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.