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

199 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
trapline1041186(None) 
grapline1138721grapline
tramline10311381tramline
traplike1437651traplike
traplines11310371traplines
dragline1036842dragline
graplin1058442graplin_
graplines1237352graplines
graplins1148262graplins
praline93019742pra_line
ralline73518412_ralline
rapine85023082_rap_ine
ratline74517802_ratline
tagline82412452t_agline
tapeline10310362t_apeline
topline92313182t_opline
trailing92916092trailing
tramlines1139842tramlines
trampling1436972trampling
trampoline1444532trampoline
trapping132911392trapping
trawling122710782trawling
trephine1338932trephine
triplane1039112triplane
tripling112712552tripling
triplite1039102triplite
tropine93116652trop_ine
trotline8310022trotline
tumpline1237112tumpline
acauline1046903acauline
aline57243153__a_line
alpine84417373__alpine
aplite8316393__aplite
atrazine1748403atra_zine
atropine10410113atrop_ine
brailing113514793brailing
brawlie12198153brawli_e
brawling143210043brawling
breadline1246273breadline
caplin103216303_caplin_
caplins113515993_caplins
caprine11314233_caprine
carline93923613_carline
cauline92215603_cauline
compline14313553compline
coralline1147943coralline
craaling112711353craaling
crablike1636023crablike
cradling122411453cradling
crapelike1744933crapelike
craping124018713crap_ing
crappie13298983crappi_e
crapping153911453crapping
crawling143110513crawling
deadline10139053deadline
draglines1145993draglines
draping114213353drap_ing
drawling13318673drawling
elaphine1346113elaphine
elapine9310673elap_ine
flatline11298923flatline
frapping16348103frapping
gradine93317033gra_dine
grapelike1644663grapelike
grapevine1543243grapevine
graphing1538533graphing
graphite1447153graphite
grappling1544993grappling
gratine84719193gra_tine
grayling1338003grayling
haplite12310703_haplite
hardline12310273hardline
headline12129613headline
hipline12311423_hipline
hyaline132310723hya_line
jawline17137063_jawline
kaoline11310143_kaoline
kraaling13186663kraaling
maline84529083_ma_line
maplike15299273_maplike
marline93320953_marline
opaline9412483opa_line
orpine83914483or_p_ine
pralines102217723pra_lines
proline92321593pr_oline
propine113020213prop_ine
railing83325643_railing
raphide13138073_raphide
rapines95120863_rap_ines
raping94829853_rap_ing
rapini84714683_rap_ini
rapping123619103_rapping
rappini11347573_rappini
ratine65131823_ra_tine
ratlike113912353_ratlike
ratlin64116523_ratlin_
ratlines83815293_ratlines
ratlins73615583_ratlins
ravine95522223_ra_vine
raylike14269253_raylike
recline94020493_recline
redline84218833_redline
reline65434353_r_eline
repine85627813_rep_ine
saline65132703_sa_line
sapling103217863_sapling
seaplane1049163seaplane
sepaline10311343sepaline
soaplike1436903soaplike
spline86020533__spline
stapling112813153stapling
strandline1145363strandline
strapping1436993strapping
streamline1244213streamline
stripling1257783stripling
tabling103216033t_abling
tacrine9311293t_acrine
taglike12278913t_aglike
taglines92210833t_aglines
tailing82923103t_ailing
tapelike1437493t_apelike
tapelines1138463t_apelines
taping94222393t_ap_ing
tapping123317133t_apping
taurine7311363t_aurine
tealike111111083tea_like
teazling1856573teazling
thralling13256833thralling
timeline1039243timeline
tippling13196703tippling
toadlike1336143toadlike
topazine1944983topazine
toplines102412563t_oplines
toppling13197353toppling
towline102911543t_owline
towplane1345313towplane
trachling1537823trachling
tracing103720153tra_cing
tracking153715463tracking
tractile10311073tractile
tractive13310043tractive
trading93517973tra_ding
traiking132511973traiking
trailside1044523trailside
train56529113tra__in_
trained84117203tra__ined
trainee72817793tra__inee
trainer73316793tra__iner
training93015863training
trains64725343tra__ins
traipsing1235073traipsing
trameling1249053trameling
tramming13279343tramming
tramping132711273tramping
trample11299703trampl__e
trampoliner1552313trampoliner
trampolines1543903trampolines
trancing112812023trancing
trapan82412973trap_an_
trapanned1243653trapanned
trapans92812463trap_ans
trapesing1247263trapesing
trapeze1836253trap_eze
trappings14265753trappings
trappose1245813trappose
trashing122613223trashing
traveling1349053traveling
travoise1145603travoise
trawlnet1146583trawl_net
treadling1137503treadling
trebling1139873trebling
treelike1237003treelike
trephined1544903trephined
trephines1448483trephines
triazine1738503triazine
trifling122411503trifling
trilling92815963trilling
trine54734603tr___ine
triplanes1148803triplanes
triple84215923tripl__e
triplites1148283triplites
tripping133210923tripping
triptane1047563triptane
tripwire1343603tripwire
troilite849543troilite
trolling93212493trolling
tropin83316753trop_in_
tropines102214923trop_ines
tropins93116313trop_ins
trotlines939103trotlines
truckline1544913truckline
trypsin1245113trypsin_
trypsins1344903trypsins
tumplines1346023tumplines
tyramine1347303tyra_mine
uralite71714103ura_lite
valine94623093_va_line
warplane1345983warplane
wrapping16297623wrapping

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.423422437.4
2DLD Change Limit1461621997.40619735.6
3Display Results1991990.0762618.4
 (SQL Overall)1786911997.90522604.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.