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

406 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
topline9231318(None) 
toplines102412561toplines
towline102911541towline
bowline123613112bowline
compline14313552compline
hipline12311422hipline
hoplite12311072hoplite
hotline10712352hotline
moline84422032mo_line
online6315842_online
opaline9412482_opaline
opine77422462_op_ine
poplin10413482poplin_
poplins11313152poplins
potline91015232potline
spline86020532_spline
tagline82412452tagline
tapeline10310362tapeline
toelike11149822toelike
toiling83219022toiling
tolane64316582to_lane
toling73926122to_ling
tolling83418562tolling
tontine72316142tontine
tooling82918312tooling
topazine1944982topazine
toping94122992top_ing
topping123514622topping
toppling13197352toppling
topside1037732topside
towlines112610342towlines
towplane1345312towplane
toxine133114122to_xine
toylike14157242toylike
trapline10411862trapline
tropine93116652trop_ine
trotline8310022trotline
tumpline1237112tumpline
airline7315033airline
aline57243153__aline
alpine84417373alp_ine
aniline7418473aniline
aplite8316393_aplite
apolune945283apolune
atropine10410113atrop_ine
beeline93314723beeline
berline93716853berline
biplane1139033biplane
boiling103819673boiling
bolide9515563bo_lide
bolling103820883bolling
bopping143512033bopping
bovine11712433bo_vine
bowlike16349473bowlike
bowlines133211623bowlines
bowling133916493bowling
boxlike20267073boxlike
byline11311643_byline
caplin103216303caplin_
caplins113515993caplins
caprine11314233caprine
carline93923613carline
cauline92215603cauline
choline122915383choline
chopine143512263chop_ine
cline76428533__cline
coaling103722823coaling
cocaine111315173cocaine
codeine103815033codeine
codlin94516443codlin_
codling114418953codling
codlins104116243codlins
coiling103723453coiling
colin76231693co_lin_
colins85229043co_lins
collide103214783collide
collie83621993colli_e
collins93419833collins
colone85425003co_lone
combine133014723combine
complice1639333complice
complin13312073complin_
complines15312833complines
complins14313103complins
confine12315583confine
coniine9316803coniine
conine84528553co_nine
coolie83821603cooli_e
cooling103422573cooling
coping113927663cop_ing
coppice1537483coppice
copping143918593copping
coprince1447093coprince
copying153411983copying
corvine122113643corvine
cosine83823513co_sine
coupling13310783coupling
cowling134017413cowling
cuplike1537213cuplike
cutline92914543cutline
decline103716613decline
deplane10311413deplane
doglike13207453doglike
doling84923133do_ling
dolling93817373dolling
domaine10610503domaine
domine92918253do_mine
doolie73916833dooli_e
dopamine1346173dopamine
doping103919463dop_ing
dourine8311453dourine
emplane11410013emplane
enplane939723enplane
eosine64519413eo_sine
feline94820143_feline
foaling113515843foaling
foiling113317653foiling
fooling113117373fooling
fopping153511133fopping
fouling113315373fouling
fowling143713113fowling
foxlike21226223foxlike
goalie7413163goali_e
goaling93515333goaling
goblin939503goblin_
goblins1039243goblins
godlike1387563godlike
godling103513403godling
gosling93312403gosling
grapline1138723grapline
gumline102810113gumline
guyline11258173guyline
haplite12310703haplite
hemline12311073hemline
hiplike1637603hiplike
hiplines13310593hiplines
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
holing104025073ho_ling
hoolie93217783hooli_e
hooplike1736773hooplike
hoping123719743hop_ing
hoplites13310543hoplites
hopping154115273hopping
hoppling16206763hoppling
hotlines11811643hotlines
hotlink1476763hotlink
howling143413163howling
hyaline132310723hyaline
incline9314643incline
iodine74618653io_dine
iolite63221983io_lite
isocline1047293isocline
isoline7314013isoline
jawline17137063jawline
kaoline11310143kaoline
koine9516483ko__ine
koppie14277883koppi_e
line46965573___line
liplike1337283liplike
lobeline1039963lobeline
lolling83415773lolling
longline938763longline
loping93921413lop_ing
lopping123815223lopping
lowlife1335143lowlife
lupine84013533lup_ine
maline84529083_maline
maplike15299273maplike
marline93320953marline
midline102315103midline
milline92519113milline
moiling103417663moiling
mollie83517103molli_e
moping114017103mop_ing
mopping143411473mopping
moraine9314573moraine
morphine1548703morphine
moulin8313283moulin_
moulins9312703moulins
myeline1238253myeline
nonlife1038553nonlife
noplace1137393noplace
oblige937653_oblige
offline1345783offline
ogling83211883_ogling
oiling74925313_oiling
oleine6313793_oleine
olive84817153_o_live
oodlins83210513oodlins
oolite63319603_oolite
opalines10311423_opalines
ophite11410563_ophite
opined95113853_op_ined
opines84820703_op_ines
oping86322413_op_ing
opsin7613473_opsin_
opsins8411713_opsins
optime1079353_optime
opting94514403_opting
orpine83914483_orpine
oscine8311563_oscine
outline72321333outline
ovine86316643_o_vine
oxlike17307473_oxlike
peopling1338353peopling
pepsine11310603pepsine
pine67755713__p_ine
pipeline12149503pipeline
plane74929143__plane
plie65127393__pli_e
plink115219123__plink
plotline1037643plotline
podlike14108553podlike
police102918563po_lice
poling93526503po_ling
polite83625073po_lite
polling102920383polling
pontine92419053pontine
pooling103219093pooling
popelike16177853popelike
poplitei1245483poplitei
popping113715413popping
poppling12227323poppling
popsie103013053popsi_e
porcine11312843porcine
potlike13910123potlike
potlines10714213potlines
poutine93316823poutine
praline93019743praline
proline92321593proline
propine113020213prop_ine
ptomaine1245533ptomaine
purline93516533purline
ralline73518413ralline
rapine85023083rap_ine
ratline74517803ratline
recline94020493recline
redline84218833redline
reline65434353_reline
repine85627813rep_ine
rodlike1288263rodlike
roiling83220453roiling
rolling83620413rolling
romaine9512123romaine
roofline1136193roofline
ropelike14157853ropelike
roping94023023rop_ing
routine72615903routine
saline65132703_saline
sapling103217863sapling
sepaline10311343sepaline
setline7313923setline
skyline1436793skyline
soaplike1436903soaplike
soiling83422323soiling
soling74226823so_ling
sonlike112110713sonlike
sopite84917713sop_ite
sopping123917203sopping
sordine82515233sordine
souplike1436333souplike
sozine15712353so_zine
spine76534423_sp_ine
splice104915103_splice
splined105013113_splined
splines94718893_splines
splint85223283_splint
stapling112813153stapling
steplike1436733steplike
stoolie739723stooli_e
stooling93113133stooling
stoping103716623stop_ing
stopping133611413stopping
stoppling1474963stoppling
subline9316893subline
supine84216693sup_ine
tabling103216033tabling
tacrine9311293tacrine
taglike12278913taglike
taglines92210833taglines
tailing82923103tailing
tapelike1437493tapelike
tapelines1138463tapelines
taping94222393tap_ing
tapping123317133tapping
taurine7311363taurine
tealike111111083tealike
telling83321083telling
terrine72517573terrine
theine94814923t_heine
thine85026863t__hine
tholing112812333tholing
thymine1536643thymine
tiling73426553t_iling
tilling83522783tilling
tillite7313563tillite
timeline1039243timeline
tine45855133t___ine
tinlike11248803tinlike
tipping122814973tipping
tippling13196703tippling
tirling83315733tirling
titling83715793titling
toadlike1336143toadlike
tocsin8311003tocsin_
tocsins939963tocsins
toddling11187003toddling
toeing74418473to_eing
toeplate1047613toeplate
togging103512743togging
toggling11206483toggling
toile54626493to__ile
toiting83217093toiting
toking114420723to_king
tolan55124013to_lan_
tolanes74216313to_lanes
tolans64319273to_lans
tole46052903to_l__e
tolidine948193tolidine
tollage82610163tollage
tollmen935733tollmen
toluene736463toluene
toluide835263toluide
tombing123310533tombing
tomblike1645143tomblike
tomming12359243tomming
tone46953743to___ne
tonging93314513tonging
toning74025793to_ning
tonne54921433to__nne
tontines82114733tontines
toolings9248473toolings
toonie63617993tooni_e
tooting83019423tooting
tootling9279523tootling
tope65946383top___e
topee76029953top__ee
tophe106718973top__he
tophi105215303tophi__
topi67830393top_i__
topic95721503top_i_c
topics104714583top_ics
topis76025833top_i_s
topkick1443143topkick
topless92511123topless
topoi76018353topoi__
toppings13286423toppings
topple104411323top_ple
topsider1144503topsider
topsides1137203topsides
topspin1145113topspin_
topspins1244863topspins
topstone1046883topstone
tortile7313193tortile
tossing83612563tossing
totaling9610303totaling
totalise8312503totalise
totalize17311523totalize
toting74123793to_ting
totting82816843totting
touchline1444473touchline
touring82915193touring
tousing82916993tousing
tousling938793tousling
touting84118453touting
touzling1835503touzling
toweling122910373toweling
towie85821873to_wi_e
towing103823193to_wing
townie93312303towni_e
towplanes1444683towplanes
toxin124716713to_xin_
toxines142912263to_xines
toxins133314283to_xins
toying105017303to_ying
tramline10311383tramline
traplike1437653traplike
traplines11310373traplines
trephine1338933trephine
trine54734603t__rine
triplane1039113triplane
tripling112712553tripling
triplite1039103triplite
troilite849543troilite
trolling93212493trolling
tropin83316753trop_in_
tropines102214923trop_ines
tropins93116303trop_ins
trotlines939103trotlines
tublike1337083tublike
tumplines1346023tumplines
tupping123411663tupping
turbine9310303turbine
turdine8310283turdine
twine85822363t__wine
typing124110583typ_ing
uplink12388713_uplink
valine94623093_valine
voling103918023vo_ling
volplane1344313volplane
vulpine1235903vulpine
woolie93514483wooli_e
yodling123610253yodling
yowling143610223yowling

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274066.73619897.1
3Display Results4064060.1402900.0
 (SQL Overall)1786914067.01625469.1
 
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.