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

197 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
headline1212961(None) 
deadline10139051deadline
headlined14135131headlined
headliner13135391headliner
headlines13119011headlines
beadlike15137252beadlike
breadline1246272breadline
deadlined12125322deadlined
deadlines11138502deadlines
hardline12310272hardline
heading122919112head_ing
headland1345612headland
headliners14144332headliners
headlong1334122headlong
headpin1336002headpin_
headpins1436102headpins
headwind1643872headwind
healing113922962hea_ling
hemline12311072he_mline
herdlike1636112herdlike
hyaline132310722hya_line
redline84218832re_dline
acauline1046903acauline
aedine73218393ae_d_ine
aline57243153__a_line
beading113221863bead_ing
beadle93314683beadl__e
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
bedlike14369533be_dlike
beeline93314723be_eline
beltline1036943beltline
berline93716853be_rline
beryline1337083beryline
breadlines1345733breadlines
carline93923613_carline
cauline92215603_cauline
cradling122411453cradling
deadlier1036863deadlier
deadlift1345633deadlift
deadliness12115893deadliness
dealing94323233dea_ling
decline103716613de_cline
dragline1036843dragline
eagling91113603_eagling
eanling81416673_eanling
fadlike15318483_fadlike
feline94820143fe__line
flatline11298923flatline
goadlike1435883goadlike
gradine93317033grad_ine
grapline1138723grapline
hading113922943h_ad_ing
hailing113820693h_ailing
hairline1137873hairline
halide103417993h_a_lide
haling104229783h_a_ling
halite93624233h_a_lite
handlike1639153handlike
handling132312713handling
haplite12310703h_aplite
harmine122816193h_armine
hatlike143311713h_atlike
hauling113714433h_auling
headache1744703headache
headband1544843headband
headend12398363head_end
headfish1845443headfish
headgate1346483headgate
headhunt1544693headhunt
headier113212953head_ier
headily1478623head_ily
headiness132510363head_iness
headings133510493head_ings
headlamp1642853headlamp
headlands1444903headlands
headless12289863headless
headlight1744323headlight
headlining1553773headlining
headlock1844813headlock
headman13229633headman_
headmen13259513headmen_
headnote1245023headnote
headphone18124733headphone
headpiece1742803headpiece
headrace1446663headrace
headsmen1465983headsmen
headstone1365473headstone
headwinds1743153headwinds
heaping133015853hea_ping
hearing113324163hea_ring
hearsing1239383hearsing
hearting12513123hearting
heathlike1944323heathlike
heating114024323hea_ting
heaving144114763hea_ving
heckling18257163heckling
heddle114211163heddl__e
hedging13348953he_dging
heeding123515063heed_ing
heeling113618513he_eling
heiling113616363he_iling
helicline1444693helicline
helling114623223he_lling
hematine131614673hematine
hemlines13310623he_mlines
hemplike1936123hemplike
henlike1448693he_nlike
heralding1435773heralding
herblike1735883herblike
herding122915123herd_ing
heroine103517483he_roine
hexamine2046873hexamine
hipline12311423h_ipline
hondling132210013hondling
hoodlike1636563hoodlike
hotline10712353h_otline
huddling14227293huddling
hurdling13288013hurdling
hyalin122210043hya_lin_
hyalines14169333hya_lines
hyalins13229273hya_lins
hyalite13229473hya_lite
jawline17137063_jawline
kaoline11310143_kaoline
ladling92813393_ladling
landline9311443landline
leading93419553lead_ing
leaflike1534713leaflike
maline84529083_ma_line
marline93320953_marline
mealie82519813mea_li_e
medaling121912263medaling
meddling13257933meddling
metalline1158733metalline
midline102315103_midline
neckline1496363neckline
needling10248753needling
opaline9412483opa_line
peaklike13115373peaklike
pealike131211273pea_like
pealing104123203pea_ling
pearling11912013pearling
pearlite1039443pearlite
pedaling122412133pedaling
peddling13217973peddling
pemoline12310273pemoline
petaline10314883petaline
praline93019743pra_line
ralline73518413_ralline
ratline74517803_ratline
readding11411363readding
reading93327213read_ing
readying13410223readying
realise73021813rea_lise
realize162717083rea_lize
recline94020493re_cline
reddling112911813reddling
redlined103811233re_dlined
redliner93510473re_dliner
redlines93916083re_dlines
reedlike1336213reedlike
reedling102414273reedling
reguline939503reguline
reline65434353re__line
saline65132703_sa_line
sealing83528563sea_ling
seallike12108323seallike
seamlike14127183seamlike
seaplane1049163seaplane
seedlike1335993seedlike
seedling102610953seedling
sepaline10311343sepaline
setline7313923se_tline
sheaflike1942973sheaflike
shealing123415463shea_ling
shearling1336923shearling
shedlike1635833she_dlike
tagline82412453_tagline
tealike111111083tea_like
teazling1856573teazling
threadlike1841943threadlike
toadlike1336143toadlike
tramline10311383tramline
trapline10411863trapline
treadling1137503treadling
valine94623093_va_line
vealing114217423vea_ling
weakling16106763weakling
weanling12118643weanling
weedlike1634393weedlike
wheedling1733073wheedling
yealing112716383yea_ling
yeanling12107063yeanling
yearling1297883yearling

Search took 9 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 Limit1461621978.37617450.1
3Display Results1971970.0762592.1
 (SQL Overall)1786911978.60820758.7
 
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.