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

186 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
blankly163426(None) 
blackly1835251blackly
blandly1336041blandly
lankly13439621_lankly
blackfly2243012blackfly
blank115418552blank__
blanked144011222blanked
blanker134612022blanker
blanket134313092blanket
blanks124112892blank_s
bleakly1634662bleakly
blindly1335742blindly
bluntly1235222bluntly
clanky15469072clank_y
crankly16358122crankly
dankly14419462_dankly
frankly17315632frankly
lanely93914482_lanely
lankily1437122_lankily
lanky125517482_lank_y
rankly133910452_rankly
slackly1635262slackly
slantly10399322slantly
alanyl955483alanyl_
alanyls1084353alanyls
ankle95220253__ankle
badly114918763b_a_dly
baldly12479833b_aldly
balkily16266693balkily
balky145418243b_alk_y
bally105530103b_a_lly
balmily14216463balmily
banal75925993b_anal_
banally1249223b_anally
bandy114824183b_an_dy
bangle94018953b_angle
bank105835753b_ank__
banked135021443b_anked
banker124222733b_anker
bankerly1744333b_ankerly
bankit123617043b_ankit
banks115527903b_ank_s
banty106624003b_an_ty
barely114716793b_arely
barfly14339653b_arfly
barky145721613b_ark_y
basely114412313b_asely
bassly114610073b_assly
baulky15446313b_aulky
beadily1378843beadily
beaky146118023bea_k_y
beamily1477393beamily
beanery1237563beanery
beastly1277563beastly
bialy105119323bia__ly
blabby1234813bla_bby
black134719073black__
blackboy2143163blackboy
blacked163613373blacked
blacken15439793blacken
blacker154513513blacker
blackleg1734233blackleg
blacks144914953black_s
blamably1744903blamably
blanch133410853blan_ch
bland85320453blan__d
blander103715163blander
blankest14439063blankest
blankets14356503blankets
blanking154411933blanking
blarney12174763blarney
blasty115611053bla_sty
blatantly1442853blatantly
blazingly2444473blazingly
blearily1365953blearily
blenny1156203blen_ny
blink115720143blink__
blinked144010013blinked
blinker134110213blinker
blinks124613573blink_s
blocky17388353block_y
blowfly1843243blowfly
bluely113310083bl_uely
bluffly1833433bluffly
bonnily1236873bonnily
brainily1337313brainily
braky145015813bra_k_y
brambly16296253brambly
branchy17357913branchy
brandy124712063bran_dy
brank115222283brank__
branks124817383brank_s
branny115111833bran_ny
brashly15427613brashly
bravely15428233bravely
brawly144312353bra_wly
brawnily1644083brawnily
briskly16165403briskly
clank114719523clank__
clanked143812253clanked
clanks124615183clank_s
cleanly1236323clean_ly
clerkly1643573clerkly
clunky15447893clunk_y
crackly18397703crackly
crankily1755623crankily
crankle133610063crankle
cranky153910633crank_y
crinkly16387523crinkly
dangly114212263_dangly
darkly145411073_darkly
dinkly144311083_dinkly
flakey164410513fla_key
flakily1736293flakily
flaky155715583fla_k_y
flank124618093flank__
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flanks133913403flank_s
flatly123110213fla_tly
flunkey17405793flunkey
flunky16408093flunk_y
gangly113911583_gangly
gladly11497933gla_dly
glazily2035383glazily
grandly1238743grandly
hackly18298733_hackly
hanky155418293_hank_y
inanely1037943inanely
jangly174310603_jangly
lacily11612763_lacily
lackey154813353_lackey
laky116725823_la_k_y
lamely114013223_lamely
langley1147453_langley
lank84734453_lank__
lanker104123003_lanker
larky125218873_lark_y
lastly93310873_lastly
lately93413843_lately
laxly15610103_la_xly
lazily1859713_lazily
leanly93811503lean_ly
linky127622383_link_y
lonely92912473_lonely
longly10279603_longly
manly105022953_man_ly
meanly115412043mean_ly
oblately1343923oblately
oblongly1442483oblongly
packly17228333_packly
pinkly155012243_pinkly
plainly1236473plainly
plank115221143plank__
planked143512283planked
planks124116753plank_s
planula935773planula
pliantly1345783pliantly
plunky15377953plunk_y
rankle103414883_rankle
riantly1037613riantly
sanely93114613_sanely
scantly12419553scantly
skanky12476963skank_y
slangily1235383slangily
slangy105411393slan_gy
slank95822773slank__
slanty95114843slan_ty
sleekly14325193sleekly
slickly1635853slickly
slinkily1534853slinkily
slinky13399103slink_y
spangly1336473spangly
sparkly16348133sparkly
starkly14277033starkly
swankily1833833swankily
swanky16447973swank_y
tangly104413913_tangly
tinkly134811153_tinkly
twanky16445773twank_y
twinkly1733913twinkly
wanly115118023_wan_ly
weakly1636483wea_kly
wrinkly17295753wrinkly
zanily18310183_zanily

Search took 10 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.830215290.4
2DLD Change Limit1340271868.67015458.7
3Display Results1861860.0632952.4
 (SQL Overall)1786911869.56318685.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.