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

102 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
blackleg173423(None) 
blacklegs1843911blacklegs
backlog1635772b_acklog
blacked163613372black_ed
blacken15439792black_en
blacker154513512black_er
blacking174213602blacking
blacklead1863902blacklead
blackly1835252blackl_y
jackleg2135042_jackleg
backed155725723b_ack_ed
backer144525533b_ack_er
backing165523443b_acking
backless162910633b_ackless
backlit15911903b_acklit
backlogs1746633b_acklogs
backset15314193b_ackset
black134719073black___
blackboy2143163blackboy
blackcap2043073blackcap
blackened1845273blackened
blackener1754973blackener
blackens16388103blackens
blackest16269303blackest
blackfin1953903blackfin
blackflies2143733blackflies
blackfly2243013blackfly
blackgum1942513blackgum
blackhead2184303blackhead
blackings18316763blackings
blackish1976713blackish
blackland1844653blackland
blackleads1993383blackleads
blacklist1746123blacklist
blackness1735663blackness
blackout1647413blackout
blacks144914953black__s
blacktop1842973blacktop
blanked144011223blank_ed
blanker134612023blank_er
blanket134313093blank_et
blanking154411933blanking
blankly1634263blankl_y
blockage1744103blockage
blocked16449983block_ed
blocker15419923block_er
blockier1666133blockier
blocking174510573blocking
bracelet12310693bracelet
bracken15409813brack_en
bracket154117233brack_et
bractlet1239283bractlet
brickle15279933brickle_
brickles162810283brickles
buckle144815193b_uckle_
buckled164411883b_uckled
buckler154112033b_uckler
buckles153416093b_uckles
cackle143416923_cackle_
cackled164613303_cackled
cackler153812573_cackler
cackles153717203_cackles
clacked164113603clack_ed
clacker153813773clack_er
clacking173313493clacking
crackle153611253crackle_
crackled17428863crackled
crackles164111273crackles
flacked173711583flack_ed
flacking184311793flacking
grackle14338893grackle_
grackles15309183grackles
hackle154916813_hackle_
hackled173312493_hackled
hackler163512353_hackler
hackles162917063_hackles
jacklegs2233963_jacklegs
lacked135324653_lack_ed
lacker125325623_lack_er
lackey154813353_lack_ey
lacking143821543_lacking
mackle143716433_mackle_
mackled164111923_mackled
mackles154415753_mackles
placket15412873plack_et
rackle123917293_rackle_
shackle16409543shackle_
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
slacked143815453slack_ed
slacken13399933slack_en
slacker133915293slack_er
slacking153914133slacking
slackly1635263slackl_y
spackle15369573spackle_
spackled17297803spackled
spackles16319953spackles
tackle123815733_tackle_
tackled143913193_tackled
tackler134013323_tackler
tackles133816523_tackles

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.436409841.7
2DLD Change Limit1461621027.00020880.3
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.48223882.8
 
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.