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

250 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
balkily1626669(None) 
balmily14216461balmily
bulkily16227121bulkily
baggily1436042baggily
baldly12479832bal_dly
balkier134111982balkier
balking143717352balking
balky145418242balk__y
bally105530102bal__ly
bawdily1635802bawdily
flakily1736292flakily
gawkily1834092gawkily
lankily1437122lankily
milkily16216552milkily
pawkily1934202pawkily
saltily10310542saltily
silkily14236962silkily
stalkily1534822stalkily
sulkily14218112sulkily
tackily1637502tackily
wackily1936052wackily
aerily93017013_aerily
airily93014823_airily
alkali10127563_alkali
alkie95520033_alki_e
alkies104518093_alkies
alkine104916803_alkine
alkoxy2033343_alkoxy
alky115920343_alk__y
alkyl12518043_alkyl_
alkyls13465723_alkyls
ally76935643_al__ly
artily92814713_artily
backfill1965063backfill
backing165523443backing
backlit15911903backlit
badly114918763ba__dly
bail65042803ba__il_
bailey115015673ba__iley
bails75933523ba__ils
bairnly1234503bairnly
bakery155911003ba_kery
baking135626623ba_king
balcony1435853balcony
baldies105317703baldies
balding114015063balding
baldish1339503baldish
baldy115518933bal__dy
baling94829693bal_ing
balk105132223balk___
balked135219413balk_ed
balker124519163balk_er
balkers134915723balkers
balkiest144112453balkiest
balkline1437973balkline
balks114926293balk__s
ball66043323bal__l_
ballies93725743ballies
balling104424763balling
balls76236413bal__ls
ballsy11508873bal_lsy
balmier113811513balmier
balmy125217473bal__my
baloney1237483baloney
banally1249223banally
bankerly1744333bankerly
banking144621353banking
bankit123617043banki_t
bankits133410153bankits
barely114716793ba_rely
barfly14339653ba_rfly
barkier133814483barkier
barking144724183barking
barky145721613bark__y
basally1237963basally
basely114412313ba_sely
basify1437513ba_sify
basil75122273ba_sil_
basils85717473ba_sils
basking144718613basking
bassly114610073ba_ssly
bastile9313913bastile
baulkier1433533baulkier
baulking1536003baulking
baulky15446313baulk__y
beadily1378843beadily
beamily1477393beamily
beefily1535613beefily
belly104625493bel__ly
bilking144413553bilking
billy105525363bil__ly
blackfly2243013blackfly
blackly1835253blackly
blandly1336043blandly
blankly1634263blankly
blimy125212823b_l_imy
bluely113310083b_luely
bodily12310993b_odily
boldly12399423bol_dly
bonnily1236873bonnily
boozily2135623boozily
bossily1237563bossily
boxily1877843b_oxily
brainily1337313brainily
brassily1336623brassily
brawnily1644083brawnily
bulbil10389573bulbil_
bulbils11338333bulbils
bulkier134111513bulkier
bulking143815123bulking
bulky146215573bulk__y
bully105124813bul__ly
bumpily1665653bumpily
burlily1237713burlily
bushily15268893bushily
busily112211503b_usily
cagily12411563ca_gily
calcify1735873calcify
calkin123515493calki_n
calking144617783calking
calkins133814873calkins
calmly1337613cal_mly
campily1638273campily
cannily1239263cannily
cattily123210853cattily
cockily1838493cockily
crankily1755623crankily
daffily1735133daffily
daily95922333da__ily
dally95324743dal__ly
dandily12279633dandily
dankly14419463dank_ly
darkly145411073dark_ly
daylily1434983daylily
duskily15236743duskily
easily9313023ea_sily
fallibly1644393fallibly
falsely1336013falsely
falsify1643613falsify
falsity1335903falsity
family143311703fa_mily
fancily1538253fancily
fattily13379463fattily
faultily1474523faultily
filmily1535733filmily
flukily1735213flukily
folksily1843443folksily
funkily1736513funkily
gaily95020973ga__ily
gallfly1433523gallfly
gally95026173gal__ly
gamily123712183ga_mily
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
glazily2035383glazily
gluily10308293_gluily
hackly18298733hack_ly
hammily1736063hammily
handily143610873handily
happily1745763happily
hardily143310273hardily
hastily133010663hastily
hazily2179063ha_zily
hokily16409093_hokily
holily123612953hol_ily
huskily17236333huskily
ickily1535753_ickily
jazzily2533373jazzily
jerkily2134623jerkily
jokily20306533_jokily
jollily1745773jollily
joltily1746323joltily
kinkily1335223kinkily
lacily11612763la_cily
lankly13439623lank_ly
lazily1859713la_zily
leakily1436473leakily
lily76730183__l_ily
luckily16297083luckily
malkin122913153malki_n
malkins133311803malkins
mangily1339753mangily
manlily1238743manlily
mazily20610393ma_zily
mirkily16266403mirkily
muckily18277743muckily
murkily16287113murkily
muskily16289043muskily
nastily103011033nastily
nattily103610323nattily
oilily93111723oil_ily
packly17228333pack_ly
palely11311933pal_ely
pallidly1444063pallidly
pally105727123pal__ly
paltrily1345413paltrily
perkily1637813perkily
peskily1635083peskily
pockily1846233pockily
pokily15309063_pokily
pulpily1436103pulpily
quakily2336693quakily
racily11715173ra_cily
rainily10310433rainily
rally84725903ral__ly
rankly133910453rank_ly
riskily1436413riskily
salably121610743salably
salify12311373sal_ify
sally85129713sal__ly
salsify1334703salsify
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
shakily1736903shakily
sillily10209783sillily
slily85820033_sl_ily
smokily1635373smokily
snakily1436913snakily
snarkily1534583snarkily
sparkily1735023sparkily
spikily1635873spikily
swankily1833833swankily
tackify1934493tackify
talkie103914443talki_e
talkier114011843talkier
talkies113415733talkies
talking123815823talking
talky126215683talk__y
tally84526863tal__ly
tardily11269583tardily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tawnily1335443tawnily
uglily1036193ugl_ily
vakil1259793va_kil_
vakils1337593va_kils
validly1435573validly
walking154013303walking
walkway2043373walkway
wally114625093wal__ly
warily122915093wa_rily
waspily1535513waspily
wavily15219483wa_vily
waxily19218413wa_xily
wilily123310763wil_ily
zanily18310183za_nily

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.453394461.4
2DLD Change Limit1340272508.81315207.9
3Display Results2502500.0932688.2
 (SQL Overall)1786912509.35919093.0
 
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.