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

131 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
blarneys1318319(None) 
barneys12569561b_arneys
blarney12174761blarney_
baloneys1334662baloneys
barleys125011842b_arleys
barney115314452b_arney_
blares85021632blar_e_s
blarneyed1542152blarneyed
carneys124310542_carneys
badness1039573b_adness
baileys12388933b_aileys
baldness1137043baldness
baloney1237483baloney_
banes74945583b_a_ne_s
banners94018713b_anners
bannets94013843b_annets
barbels114514433b_arbels
barbers114317503b_arbers
barbes104526233b_arbe_s
barbets114915843b_arbets
bardes95026933b_arde_s
bareness10912813b_areness
bares75457133b_ar_e_s
bargees105415873b_argees
barges94528253b_arge_s
barkers134318513b_arkers
barless94317003b_arless
barley115116763b_arley_
barned95623583b_arne_d
barns76335143b_arn__s
barny105821733b_arn_y_
baroness101210063b_aroness
baronets101410903b_aronets
barrels94514363b_arrels
barrens94414323b_arrens
barres84427543b_arre_s
barrets94917103b_arrets
barters94223033b_arters
baryes116218503b_arye_s
bearers94619593bear_ers
biasness1035813biasness
blabbers11308153blabbers
blackens16388103blackens
blackness1735663blackness
bladders12397803bladders
bladers104214683bla_ders
blades95221253bla_de_s
blains84516373blain__s
blamers115314213bla_mers
blames105121863bla_me_s
blandness1235973blandness
blankets14356503blankets
blankness1544673blankness
blanks124112893bla_n_ks
blare75826233blar_e__
blared95018243blar_e_d
blarneying1641943blarneying
blasters104116143blasters
blathers134713793blathers
blatters104414093blatters
blazers184811683bla_zers
blazes174817353bla_ze_s
blazoners2043863blazoners
bleakness1543593bleakness
bleariness1246053bleariness
blueness1038213blueness
blueys11419523bl__ueys
blurters10348373blurters
boarders11408623boarders
boloneys1334503boloneys
boranes93720403borane_s
bournes93615023bourne_s
branners104010923branners
burleys12479673b_urleys
burners94115673b_urners
burnets93813263b_urnets
carnets93918403_carnets
carney115315703_carney_
charleys1695633charleys
charnels13328173charnels
clarets94111103clar_ets
claries93422203clarie_s
clarinets1137683clarinets
claroes93113733claroe_s
clearness1135633clearness
darkeys15356533_darkeys
darnels83710433_darnels
darners83815773_darners
dearness939973dearness
earners74016453_earners
farness102912203_farness
flanes94522423fla_ne_s
flannels1134843flannels
flares94521703flar_e_s
flatness1138153flatness
garners83815983_garners
garnets84115403_garnets
garveys14124463_garveys
gladness1036153gladness
glares75518863glar_e_s
glariness1038553glariness
gurneys11406463_gurneys
harness102413933_harness
jarveys20123413_jarveys
journeys1843203journeys
lackeys16458263_lackeys
lanes54946793_la_ne_s
lanners73618333_lanners
larders83516943_larders
larees65323113_lar_ees
lares54852633_lar_e_s
larges74824233_large_s
largess8408913_largess
larkers113014513_larkers
laxness1436043_laxness
learners8398153learners
looneys10487013_looneys
malarkeys1841963malarkeys
nearness838313nearness
parleys125212373_parleys
planers94517943pla_ners
planes85028083pla_ne_s
planets93914083pla_nets
planners10399933planners
sawneys13274643_sawneys
slaveys13415203sla_veys
tawneys13324773_tawneys
tourneys1134013tourneys
warners103315563_warners
yarners104312203_yarners
yearners11346373yearners

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.406440125.6
2DLD Change Limit1461621317.14020470.9
3Display Results1311310.0502620.0
 (SQL Overall)1786911317.59623524.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.