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

125 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
baselines113860(None) 
baseline10310751baseline_
baseliner1144741baseliner
baseliners1243861baseliners
vaselines1246711vaselines
bakelites1545992bakelites
balklines1536742balklines
beelines103312802b_eelines
bluelines1145832bluelines
bustlines11207352bustlines
datelines1088852datelines
gasolines1047482gasolines
tapelines1138462tapelines
vaseline1138612vaseline_
adenines9310193_adenines
airlines8312793_airlines
alexines15258503_alexines
alines65735223_a__lines
anilines8415143_anilines
anserines9411293anserines
babblings13194373babblings
baculine1238983baculine_
bailies94120203ba_ili_es
bakelite1447253bakelite_
bakeries14312203bakeri_es
balefires1444813balefires
balkline1437973balkline_
ballies93725743ba_lli_es
banalizes201210093banalizes
bantlings12216603bantlings
barflies1338313barfli_es
basaltes10367683basal_tes
basaltine1144713basaltine_
baseless1099563basel_ess
basements1348263basements
baseness10910943base__ness
baseplates14114403baseplates
bashings144311243bas_hings
basifies13310493basifi_es
basilicas1343733basilicas
basilisks1543103basilisks
basined10310003bas__ined
basinet9318933bas__inet
basinets1039063bas__inets
basins85722763bas__in_s
bassinet10312843bas_sinet
bassinets1146323bas_sinets
bastiles10313353bas_tiles
bastilles1147363bastilles
bastings114214693bas_tings
beastliness1343333beastliness
beeline93314723b_eeline_
beelined11277713b_eelined
belies84631053b__eli_es
beltlines1135963beltlines
berlines102315453b_erlines
beslimes1246953bes_limes
blueline1036873blueline_
blueliner1142993blueliner
blueliners1242503blueliners
bowlines133211623b_owlines
brasilins1146243brasilin_s
buntlines11207153buntlines
bustline10208843bustline_
bylines1239243b__ylines
cagelings1335413cagelings
capelins12311133capelin_s
carlines103521673ca_rlines
casefies1339213casefi_es
caseins93115053case_in_s
casernes103810753case_rnes
cassines103116613cas_sines
coastlines12125333coastlines
dateline9810353dateline_
datelined1194713datelined
eserines8413743_eserines
fascines13310143fas_cines
felines104718073__felines
fishlines15246843fishlines
gantlines1039333gantlines
gaselier946963gaseli_er
gaseliers1044933gaseliers
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
panelings12107463panelings
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
valines104520213va__lines
vaselike1536993vaselike_
waistlines1343893waistlines
waterlines1348953waterlines
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 Limit1486411256.78021923.5
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.24924650.4
 
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.