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 “barnacle” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
barnacle124594(None) 
barnacled1444001barnacled
barnacles1355331barnacles
bannable1278352bannable
barrable1249252barrable
bernicle1245442bernicle
binnacle12325632binnacle
burnable1237262burnable
manacle11310282ma_nacle
vernacle1345582vernacle
arable81821003_ar_able
article9310923_article
backache21126063backache
bailable1238583bailable
balance11510263balanc_e
banal75925993ba_na_l_
banally1249223ba_nally
bangle94018963ba_n_gle
bankable1677913bankable
barbal104016663barba_l_
barbate11314543barba_te
barbecue14194703barbecue
barbicel14144963barbicel
barbule1137943bar_bule
barcarole1343773barcarole
barnlike1437183barnlike
baronage1147073barona_ge
barouche1544173barouche
barrack1538253barrac_k
barracked1844753barracked
barracker1744653barracker
barracks1636883barracks
barrage10710853barra_ge
barware12610703barwa_re
bearable121512363bear_able
berdache1644033berdache
bernicles1345403bernicles
binnacles13244583binnacles
binocle1136493b_inocle
boardable1444893boardable
brace95629273b_r_ac_e
burnables1344003burnables
caracole12310363car_acole
carnage10311743carna_ge
carnal83919213carna_l_
carnally1339523carnally
carpale113414353carpa_le
cartable121314093cartable
caruncle1244713caruncle
cenacle1139123_cenacle
coracle112011723cor_acle
cornicle1258783cornicle
damnable1347593damnable
earache1239333ear_ache
farfalle1445063farfalle
farmable1538203farmable
furnace1235943furnac_e
gainable1138933gainable
ganache1346223ga_nache
learnable1145563learnable
manacled1336453ma_nacled
manacles1239523ma_nacles
miracle1138843mir_acle
oracle84313293_or_acle
panache1458433pa_nache
panicle11129983pa_nicle
parable111819783par_able
parsable12311693parsable
particle1239543particle
pawnable1535983pawnable
pinnacle12416963pinnacle
sanicle91210263sa_nicle
tabernacle1452053tabernacle
tannable1039383tannable
tarnal63716503tarna_l_
tarnally1138273tarnally
treacle939973_treacle
turnable1037853turnable
variable13310063variable
vernacles1445073vernacles
vernicle1346433vernicle

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 Limit146162817.45319611.2
3Display Results81810.0332454.5
 (SQL Overall)178691817.90922593.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.