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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

268 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
balk10513222(None) 
back125535761back
bal56662721bal_
bald76432901bald
bale66353841bale
balks114926291balks
balky145418241balky
ball66043321ball
balm85534201balm
bals66354041bals
bank105835751bank
bark106242151bark
bask105131421bask
baulk114914331baulk
bilk105824421bilk
bulk105426151bulk
calk105527661calk
talk86230091talk
walk115625611walk
aal39058672aal_
aals49941142aals
aback134816172aback
able66340532able
ably99725132ably
al210674042_al_
ala312463602_ala
alb57342652_alb
ale36572342_ale
alky115920342_alky
all36148232_all
alp56641132_alp
als36663022_als
alt36467962_alt
ark77044962_ark
ask77130702_ask
auk76234142_auk
ba49962342ba__
baa510650422ba_a
baal67033112baal
baals76122702baals
baas66844672baas
baba88828352baba
babe86835822babe
babka137812912babka
babu85829232babu
baby116723682baby
bach116131392bach
backs135729622backs
bad67763152ba_d
bade75140882bade
badly114918762badly
bads77048862bads
baff124632272baff
bag67059222ba_g
bags76645502bags
bah87755352ba_h
baht96740012baht
bail65042802bail
bails75933522bails
bait66556002bait
bake105637512bake
balas76937212balas
balds85524642balds
baldy115518932baldy
baled85436442baled
baler75635272baler
bales76250082bales
balked135219412balked
balker124519162balker
balls76236412balls
bally105530102bally
balms95723922balms
balmy125217472balmy
balsa77920412balsa
bam78560142ba_m
bams87044452bams
ban58366842ba_n
band76740912band
bane65250432bane
bang74837002bang
bani65334962bani
banks115527902banks
bans66555142bans
bap76455842ba_p
baps86040842baps
bar58070552ba_r
barb85240062barb
bard75648862bard
bare65460522bare
barf95844412barf
barks115735812barks
barky145721612barky
barm86739602barm
barn66444642barn
bars66564092bars
bas58681752ba_s
base64847022base
bash915240162bash
basks115621762basks
bass66146782bass
bast66362412bast
bat510988952ba_t
bate66552422bate
bath95940082bath
batik11614732batik
bats66962332bats
batt65053872batt
baud74928422baud
baulks12429372baulks
baulky15446312baulky
bawd105520842bawd
bawl95326062bawl
bawls105719322bawls
bay89661642ba_y
bays97143912bays
beak106534382beak
beck126226572beck
bel57148462bel_
bell66237182bell
bels66142492bels
belt65754032belt
berk105929842berk
biali73419072biali
bialy105119322bialy
bile66147182bile
bilks115117892bilks
bill67239942bill
birk106326862birk
bisk106523352bisk
blab86629132blab
black134719072black
blae66134642blae
blah98625062blah
blam86131702blam
blank115418552blank
blat66550952blat
blaw97026722blaw
bock126032512bock
bola66035562bola
bold75432812bold
bole66448692bole
boll65634752boll
bolo65535952bolo
bolt66254172bolt
bonk105531712bonk
book106836332book
bork106933822bork
bosk105825732bosk
brank115222282brank
buck125129902buck
bulb85626692bulb
bulks115920612bulks
bulky146215572bulky
bull65634872bull
bunk105731352bunk
busk105429222busk
bytalk1533472bytalk
calf96339562calf
calks115421602calks
call66838672call
calm85032362calm
calo64936442calo
calx135722792calx
cark105539272cark
cask105626432cask
caulk115315452caulk
chalk144814602chalk
dak86340692da_k
dal47554952dal_
dale55643982dale
dals57145122dals
dank95828242dank
dark95133212dark
dawk126117282dawk
elk76726122_elk
fall75535312fall
falx147120782falx
flak116026172flak
folk116021542folk
gal46055512gal_
gala55635162gala
gale56347322gale
gall56335992gall
gals57946502gals
gawk126716692gawk
hack135134542hack
haik115526982haik
hale76052832hale
half106238452half
hall75741162hall
halm95834972halm
halo76437322halo
halt76056302halt
hank115134142hank
hark115237392hark
hawk145521152hawk
holk116027942holk
hulk115321612hulk
ilk78325302_ilk
jack175224862jack
jauk155816092jauk
kale86533752kale
lack105837682lack
lall45531312lall
lank84734452lank
lark85733862lark
mack125733652mack
male66052302male
mall64639372mall
malm85129982malm
malt66254812malt
mark105138062mark
mask105227362mask
milk105028472milk
nala46930392nala
nark85230062nark
oak76238652oa_k
pack125535442pack
paik105726802paik
pal56761672pal_
pale66055012pale
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
park105237492park
rack106234882rack
rale45050562rale
rank85135532rank
sack105337312sack
sal36462882sal_
sale44959702sale
sall44544682sall
salp64534092salp
sals46851672sals
salt45758522salt
sank85236832sank
sark84938972sark
silk85529322silk
stalk94518002stalk
sulk85326652sulk
tack106536292tack
tala45938052tala
talc66226812talc
tale46154162tale
tali46837162tali
talks94322692talks
talky126215682talky
tall47240212tall
taluk94812872taluk
tank85134022tank
task85326652task
vale74937342vale
wack135330912wack
wale74546432wale
walks126218502walks
wall76236102wall
waly105830902waly
wank115632512wank
wark115737772wark
wauk115220592wauk
yack135425972yack
yak107038562ya_k
yald86920612yald
yank115423672yank
yelk115320002yelk
yolk116218992yolk

Search took 2 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 Filter178691298720.296603685.8
2DLD Change Limit298722681.00029872.0
3Display Results2682680.0634254.0
 (SQL Overall)1786912681.359131487.1
 
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.