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

144 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
tramlines113984(None) 
tramline10311381tramline_
traplines11310371traplines
draglines1145992draglines
graplines1237352graplines
pralines102217722pra_lines
ratlines83815292_ratlines
streamlines1343642streamlines
taglines92210832t_aglines
trampolines1543902trampolines
trapline10411862trapline_
trotlines939102trotlines
tyramines1447212tyram_ines
alines65735223__a_lines
amines84727983__am_ines
ammines11312673__ammines
atrazines1846683atra_zines
bramblings1742613bramblings
breadlines1345733breadlines
bromines122514253brom_ines
carlines103521653_carlines
carmines123617873carm_ines
corallines1246553corallines
deadlines11138503deadlines
diamines11311643diam_ines
dragline1036843dragline_
drumlins1144993drumlin_s
enamines101112133enam_ines
ermines9416673er_m_ines
etamines101611813etam_ines
examines17128793exam_ines
famines123216263_fam_ines
flamines13311643flam_ines
flatlines12268433flatlines
framings14338133fram_ings
gamines103618463_gam_ines
gradines103615253gra_dines
grapline1138723grapline_
graplins1148263graplin_s
graylings1433883graylings
gremlins1136053gremlin_s
gumlines11238573_gumlines
harmines132715143harm_ines
headlines13119013headlines
hemlines13310623_hemlines
hyalines14169333hya_lines
jawlines18126363_jawlines
kaolines1239293_kaolines
kremlins1444483kremlin_s
malines93625603_ma_lines
marlines103818713_marlines
opalines10311423opa_lines
praline93019743pra_line_
primines123013703prim_ines
prolines102619693pr_olines
promines123018803prom_ines
railings93412153_railings
rallies73823343_ralli_es
ralline73518413_ralline_
ramies84630463_ram_i_es
ramilies10311833_ramilies
rampikes1635393_rampikes
rapines95120863_ra_pines
ratines75328583_ra_tines
ratline74517803_ratline_
ratlins73615583_ratlin_s
ravines104220233_ra_vines
reclines103718543_reclines
redlines93916083_redlines
relines75331323_r_elines
romaines10512523_romaines
salines74029413_sa_lines
stramonies1246653stramonies
strandlines1244963strandlines
streamline1244213streamline_
streamlined1452253streamlined
streamliner1352173streamliner
streamliners1451623streamliners
tacrines10310563t_acrines
tagline82412453t_agline_
tailings93211673t_ailings
talipes9611603t_a_lipes
tallies73624603t_alli_es
tallises82713263t_allises
tameins9311423t_amein_s
tamises92715973t_am_ises
tammies113814683t_ammi_es
tapelines1138463tapelines
taurines8310553t_aurines
thiamines1446383thiam_ines
thymines1635613thym_ines
timelines1148443timelines
toplines102412563t_oplines
tourmalines1343483tourmalines
towlines112610343t_owlines
tracings112910413tra_cings
trackings16247543trackings
trailing92916093trailin_g
trained84117203tra__ined
trainee72817793tra__inee
trainees82712063tra__inees
trainer73316793tra__iner
trainers83114643tra__iners
trainings10246723trainings
trains64725343tra__in_s
trameling1249053tramelin_g
tramless1037503traml_ess
tramming13279343trammin_g
trampier12318243trampi_er
trampiest13227903trampi_est
tramping132711273trampin_g
tramples122610203tram_ples
trampling1436973tramplin_g
trampoline1444533trampoline_
trampoliner1552313trampoliner
trampoliners1651443trampoliners
trannies8415013tranni_es
traplike1437653traplike_
trappings14265753trappings
trashiness1346443trashiness
travoises1245863travoises
trawling122710783trawlin_g
trawlnet1146583trawl_net
trawlnets1242843trawl_nets
trellises947023trellises
tremolites1256053tremolites
trephines1448483trephines
triazines1847543triazines
triflings13235973triflings
trimmings14254453trimmings
trines64132563tr___ines
triplanes1148803triplanes
triplites1148283triplites
troilites948433troilites
trollies8310233trolli_es
trollings10286693trollings
trombones1345363trombones
tropines102214923tr_opines
trotline8310023trotline_
trucklines1644293trucklines
tumplines1346023tumplines
tyramine1347303tyram_ine_
uralites82112723ura_lites
valines104520213_va_lines

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 Limit1486411447.14020818.1
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.62623431.8
 
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.