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

193 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
tramline1031138(None) 
tramlines1139821tramlines
trapline10411861trapline
dragline1036842dragline
grapline1138722grapline
praline93019742pra_line
ralline73518412_ralline
ratline74517802_ratline
streamline1244212streamline
tagline82412452t_agline
trailing92916092trailing
trameling1249052trameling
tramming13279342tramming
tramping132711272tramping
trampling1436962trampling
trampoline1444522trampoline
traplike1437652traplike
traplines11310352traplines
trawling122710782trawling
trotline8310022trotline
tyramine1347302tyram_ine
acauline1046903acauline
aline57243153__a_line
amine75835373__am_ine
ammine10314483__ammine
armlike1348553ar_mlike
atrazine1748403atra_zine
beamlike16115843beamlike
brailing113514793brailing
brambling1635543brambling
brawlie12198153brawli_e
brawling143210043brawling
breadline1246273breadline
bromine112915243brom_ine
carline93923613_carline
carmine112918483carm_ine
cauline92215603_cauline
clamlike1635163clamlike
coralline1147943coralline
craaling112711353craaling
crablike1636023crablike
cradling122411453cradling
cramming15339433cramming
cramping153411853cramping
crawling143110513crawling
crimine112413473crim_ine
deadline10139053deadline
diamine10311973diam_ine
draglines1145993draglines
dramming14347563dramming
drawling13318673drawling
dreamlike1642753dreamlike
drumlike1543793drumlike
drumlin1044423drumlin_
drumlins1144993drumlins
enamine91214293enam_ine
ermine8416923er_m_ine
etamine91313063etam_ine
examine161510033exam_ine
famine114318193_fam_ine
flatline11298923flatline
foamlike1735143foamlike
framing133014793fram_ing
gamine94620153_gam_ine
gradine93317033gra_dine
graplin1058443graplin_
graplines1237353graplines
graplins1148263graplins
gratine84719193gra_tine
grayling1338003grayling
gremlin1035563gremlin_
gremlins1136043gremlins
gumline102810113_gumline
hardline12310273hardline
harmine122816193harm_ine
headline12129613headline
hemline12311073_hemline
hyaline132310723hya_line
jamlike20126923_jamlike
jawline17137063_jawline
kaoline11310143_kaoline
kraaling13186663kraaling
kremlin1344213kremlin_
kremlins1444483kremlins
maline84529083_ma_line
marline93320953_marline
opaline9412483opa_line
pralines102217723pra_lines
primine113214823prim_ine
proline92321593pr_oline
promine112819443prom_ine
railing83325643_railing
rambling131810773_rambling
ramie75027823_ram_i_e
ramilie9310283_ramilie
ramming123115063_ramming
rampike1536603_rampike
ramping123316873_ramping
rapine85023083_ra_pine
ratine65131823_ra_tine
ratlike113912353_ratlike
ratlin64116523_ratlin_
ratlines83815293_ratlines
ratlins73615583_ratlins
ravine95522223_ra_vine
raylike14269253_raylike
recline94020493_recline
redline84218833_redline
reline65434353_r_eline
romaine9512123_romaine
saline65132703_sa_line
seamlike14127183seamlike
strandline1145353strandline
streamlined1452253streamlined
streamliner1352173streamliner
streamlines1343643streamlines
tabling103216033t_abling
tacrine9311293t_acrine
taglike12278913t_aglike
taglines92210823t_aglines
tailing82923103t_ailing
tamein8313083t_amein_
tameins9311413t_ameins
taming94023433t_am_ing
tammie104212683t_ammi_e
tamping122815813t_amping
tapeline10310363tapeline
taurine7311363t_aurine
tealike111111083tea_like
teaming103917593team_ing
teazling1856573teazling
thiamine1346743thiam_ine
thralling13256833thralling
thymine1536643thym_ine
timeline1039243timeline
toadlike1336143toadlike
topline92313183t_opline
tourmaline1243503tourmaline
towline102911543t_owline
trachling1537823trachling
tracing103720153tra_cing
tracking153715463tracking
tractile10311073tractile
tractive13310043tractive
trading93517973tra_ding
traiking132511973traiking
trailside1044513trailside
train56529113tra__in_
trained84117203tra__ined
trainee72817793tra__inee
trainer73316793tra__iner
training93015863training
trains64725343tra__ins
tramelling1346373tramelling
tramless1037503tramless
trammeling1544023trammeling
trampier12318233trampier
trampish1535643trampish
trample11299703tram_ple
trampoliner1552313trampoliner
trampolines1543873trampolines
trancing112812023trancing
trapping132911393trapping
trashing122613223trashing
traveling1349053traveling
travoise1145603travoise
trawlnet1146583trawl_net
treadling1137503treadling
trebling1139873trebling
treelike1237003treelike
trembling1435183trembling
tremolite1156893tremolite
trephine1338933trephine
triazine1738503triazine
trifling122411503trifling
trilling92815963trilling
trimming13318653trimming
trine54734603tr___ine
triplane1039113triplane
tripling112712553tripling
triplite1039103triplite
troilite849543troilite
trolling93212493trolling
trombone1245353trombone
tromping13319593tromping
tropine93116653tr_opine
trotlines939103trotlines
truckline1544913truckline
trumping13308733trumping
tumpline1237113tumpline
tyramines1447193tyram_ines
uralite71714103ura_lite
valine94623093_va_line

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621939.29615723.1
3Display Results1931930.0802412.5
 (SQL Overall)1786911939.53218746.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.