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

117 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
tapelines113846(None) 
tapeline10310361tapeline_
baselines1138602baselines
capelins12311132capelin_s
datelines1088852datelines
pipelines13178352pipelines
taglines92210832ta_glines
tapelike1437492tapelike_
timelines1148442timelines
toplines102412562top_lines
traplines11310372trap_lines
vaselines1246712vaselines
adenines9310193_adenines
airlines8312793_airlines
alexines15258503_alexines
alines65735223_a__lines
anilines8415143_anilines
apelike13310533_apelike_
aperies9423203_aperi_es
aplites9314933_ap_lites
apolunes1045293_apolunes
applies11311213_appli_es
athelings1345113athelings
bakelites1545993bakelites
balklines1536743balklines
baseline10310753baseline_
baseliner1144743baseliner
baseliners1243863baseliners
beelines103312803_beelines
bluelines1145833bluelines
cagelings1335413cagelings
capelans1238013capelan_s
capelin11510973capelin__
caplins113515993cap_lin_s
carlines103521643ca_rlines
dateline9810353dateline_
datelined1194713datelined
felines104718073__felines
gantlines1039333gantlines
gasolines1047483gasolines
grapevines1642903grapevines
graplines1237353grap_lines
hairlines1237133hairlines
haplites1339993hap_lites
hiplines13310593hip_lines
japeries17311463japeri_es
javelinas19353583javelinas
javelined2043323javelined
javelins18277733javelin_s
jawlines18126363ja_wlines
kaolines1239293ka_olines
landlines1039763landlines
lanolines939983lanolines
lifelines12147053lifelines
lobelines1138563lobelines
madeleines1343613madeleines
mainlines1138513mainlines
malines93625603ma__lines
marlines103818713ma_rlines
myelines1337123_myelines
naperies10313903naperi_es
nephelines1544843nephelines
opalines10311423_opalines
panelings12107453panelings
paperiness1446133paperiness
pelites93821993__pelites
pipeline12149503pipeline_
pipelined14164853pipelined
piperines131610693piperines
rapines95120863rap__ines
ratlines83815293ra_tlines
ravelings13377383ravelings
ravelins113011603ravelin_s
relines75331323__relines
salines74029413sa__lines
saplings11269803sap_lings
saponines1148043saponines
shapeliness1663163shapeliness
sidelines10109683sidelines
splines94718893_sp_lines
stapelias1145103stapeli_as
stateliness1144233stateliness
taborines11238983taborines
tacklings16235853tacklings
tacrines10310563ta_crines
tagline82412453ta_gline_
tailings93211673ta_ilings
talipes9611603ta__lipes
tallies73624603ta_lli_es
tallises82713263ta_llises
tameins9311413tame_in_s
tangerines1147543tangerines
tapeless10218643tapel_ess
tapenades1245063tapenades
tapering112112503taperin_g
tapises92914013tap__ises
tappings13267713tap_pings
taurines8310553ta_urines
tepefies1346893tepefi_es
teredines1049453teredines
theelins1137643theelin_s
theines104013233t_he_ines
timeline1039243timeline_
timeliness1245303timeliness
topline92313183top_line_
towelings13234693towelings
towlines112610343t_owlines
tramlines1139843tramlines
trampolines1543903trampolines
trapline10411863trap_line_
trephines1448483trephines
trotlines939103trotlines
tumplines1346023tumplines
valines104520213va__lines
vaseline1138613vaseline_
waterlines1348953waterlines
zibelines2045733zibelines

Search took 10 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.420425454.8
2DLD Change Limit1486411178.51617454.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.98219894.3
 
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.