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

164 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
trotline831002(None) 
trotlines939101trotlines
frontline1245052frontline
frostline1245882frostline
hotline10712352_hotline
plotline1037642plotline
potline91015232_potline
proline92321592pro_line
ratline74517802_ratline
tootling9279522tootling
topline92313182t_opline
towline102911542t_owline
tramline10311382tramline
trapline10411862trapline
troilite849542troilite
trolling93212492trolling
tropine93116652tro_pine
trothing122410842trothing
trotting92510912trotting
atropine10410113atro_pine
beltline1036943beltline
bowline123613113_bowline
broiling113112013broiling
bromine112915243bro_mine
buntline10198063buntline
bustline10208843bustline
choline122915383cho_line
croceine1248033croceine
crocine11314153cro_cine
cutline92914543_cutline
dragline1036843dragline
drolling103510763drolling
drooling102610423drooling
erotize16311663erot_ize
flatline11298923flatline
footlike1537253footlike
footling12239923footling
froglike1634363froglike
frontlines1345193frontlines
frostlines1345193frostlines
frothing15208533frothing
gantline9410903gantline
grapline1138723grapline
gratine84719193grat_ine
growling1348163growling
hotlines11811643_hotlines
hotlink1476763_hotlink
ironlike1235713ironlike
isocline1047293isocline
isoline7314013iso_line
kaoline11310143kao_line
knotlike1144003knotlike
moline84422033_mo_line
online6315843__online
outline72321333_outline
plotlines1146823plotlines
potlike13910123_potlike
potlines10714213_potlines
praline93019743pr_aline
procaine12312273procaine
prolines102619693pro_lines
promine112819443pro_mine
propine113020213pro_pine
protamine131310913protamine
proteide11239723proteide
protein92414733protein_
proteins102114283proteins
prowling1449993prowling
ralline73518413_ralline
ratine65131823_rat_ine
ratlike113912353_ratlike
ratlin64116523_ratlin_
ratlines83815293_ratlines
ratlins73615583_ratlins
recline94020493_recline
redline84218833_redline
reline65434353_r_eline
retine66237333_ret_ine
rodlike1288263_rodlike
roiling83220453_roiling
rolling83620413_rolling
romaine9512123_romaine
roofline1136193roofline
rootlike1236613rootlike
rootling9269953rootling
rotting82919683_rotting
routine72615903_routine
serotine8313573serot_ine
setline7313923_setline
strolling10238793strolling
tagline82412453t_agline
tapeline10310363tapeline
tattling9259473tattling
tentlike1236903tentlike
tholing112812333tho_ling
throttling1442793throttling
timeline1039243timeline
titling83715793t_itling
toelike11149823t_oelike
toiling83219023t_oiling
tolane64316583t_o_lane
toling73926123t_o_ling
tolling83418563t_olling
tontine72316143t_ontine
tooling82918313t_ooling
toothing12278863toothing
toothlike1643723toothlike
tooting83019423toot_ing
tootle62613813tootl__e
tootsie737133tootsi_e
toplines102412563t_oplines
tortile7313193tort_ile
tortoise847093tortoise
totaling9610303t_otaling
totalise8312503t_otalise
totalize17311523t_otalize
toting74123793t_ot_ing
totting82816843t_otting
towlines112610343t_owlines
toxine133114123t_o_xine
toylike14157243t_oylike
trailing92916093trailing
tramlines1139843tramlines
traplike1437653traplike
traplines11310373traplines
trawling122710783trawling
trebling1139873trebling
treelike1237003treelike
trephine1338933trephine
triazine1738503triazine
tricotine1148253tricot_ine
trifling122411503trifling
trilling92815963trilling
trine54734603tr___ine
triplane1039113triplane
tripling112712553tripling
triplite1039103triplite
trithing122811773trithing
tritone73613883trit_one
troaking133310973troaking
trocking153612423trocking
troilism1047193troilism
troilites948433troilites
troking123514103tro_king
troland837543tro_land
trollied935893trollied
trollies8310233trollies
trollings10286693trollings
trollying1354053trollying
trombone1245373trombone
tromping13319603tromping
trone55131863tro___ne
trooping112710283trooping
tropin83316753tro_pin_
tropines102214923tro_pines
tropins93116313tro_pins
troubling1234943troubling
trouping11249503trouping
troweling1376363troweling
trowing113413703tro_wing
truckline1544913truckline
tumpline1237113tumpline
turtling9238833turtling
tyrosine1147043tyro_sine

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621646.70321805.5
3Display Results1641640.0762157.9
 (SQL Overall)1786911647.24924650.4
 
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.