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

243 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
bolds8582528(None) 
balds85524641balds
bods76244711bo_ds
bolas74733761bolas
bold75432811bold_
boles75448601boles
bolls75531311bolls
bolos75531371bolos
bolts76232111bolts
bolus79125541bolus
bonds86126841bonds
colds85726971colds
folds95221691folds
golds75421311golds
holds94623241holds
molds85324831molds
olds55926571_olds
wolds95420181wolds
aholds10469482aholds
bads77048862b_ads
balas76937212balas
bald76432902bald_
baldy115518932baldy
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
bands85233422bands
bards87139642bards
bauds85821042bauds
bawds116115492bawds
beads85429502beads
beds75937782b_eds
beholds1336422beholds
bells76432162bells
bels66142492bel_s
belts75931162belts
bends85628972bends
bids75838452b_ids
bields94110002bields
biles75542142biles
bilks115117892bilks
bills75632862bills
binds86627472binds
birds85421332birds
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blonds95213342blonds
bloods94614842bloods
blots75626172blots
blows105423832blows
boards94616932boards
boars75229602boars
boas66150832bo_as
boats75635152boats
bobs86340652bo_bs
bocks134526572bocks
bod67055542bo_d_
bode75838752bo_de
bodes84935102bodes
body107425672bo_dy
boffs134915502boffs
bogles95020832bogles
bogs75742752bo_gs
bogus85616472bogus
bohos105618252bohos
boils75427192boils
bola66035562bol_a
bolar75123472bolar
bolder94820932bolder
boldest102613062boldest
boldly12399422boldly
bole66448692bol_e
bolide9515562bolide
bolides10515072bolides
boll65634752bol_l
bolo65535952bol_o
bolt66254172bol_t
bombs115818822bombs
bond75334362bond_
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boobs96221992boobs
boody115420402boody
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boots75837972boots
bops86037982bo_ps
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
botas75328782botas
bots66453952bo_ts
botts75224862botts
boules84925972boules
bounds94415802bounds
bouts75131312bouts
bovids1287972bovids
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boylas113011722boylas
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
brads85528292brads
broads94515152broads
broods95416382broods
buds75235172b_uds
builds9378492builds
bulbs96016932bulbs
bulks115920612bulks
bulls75629572bulls
bunds85523542bunds
burds84626062burds
clods85320862clods
cods76848102co_ds
coeds85920162coeds
colas75436772colas
cold77338772cold_
coles76055062coles
cols66553082col_s
colts76633292colts
cords86030622cords
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
elds56324852_elds
fold86528942fold_
folks126017122folks
fonds95824822fonds
foods95924162foods
fords95328182fords
gelds75118342gelds
gilds75417522gilds
goads77022852goads
gods65438042go_ds
gold65430162gold_
golfs95616102golfs
goods75124482goods
gowds105814042gowds
hods87239862ho_ds
hold86235062hold_
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
hoods95124082hoods
joles125230832joles
jolts125018882jolts
kobolds1474342kobolds
kolas94822232kolas
kolos94921212kolos
loads65323372loads
loids66220702loids
lolls512121732lolls
lords64923502lords
melds84822382melds
milds86422052milds
mods77945052mo_ds
molas75132092molas
mold76034332mold_
moldy115014652moldy
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
moods85224622moods
moulds94910992moulds
nods55838222no_ds
nolos54423352nolos
oboles83815832oboles
obols73715862obol_s
obolus8378812obolus
odds68919922_odds
ods47546212_o_ds
old47033462_old_
oldy85316842_oldy
oles46453472_oles
ouds56430102_ouds
plods85719292plods
pods76540152po_ds
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
ponds85323402ponds
poods85124752poods
roads66523622roads
rods56442062ro_ds
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
roods65125282roods
scolds95011232scolds
silds65520522silds
sods54940212so_ds
sold54837412sold_
soldi65717202soldi
soldo67116562soldo
soles55547922soles
solids74116402solids
solos54830792solos
sols45448162sol_s
solus54726982solus
sords64527802sords
toads65621072toads
tods56141842to_ds
tolas54532772tolas
told56132202told_
toles55147132toles
tolls54728432tolls
tolus55024482tolus
velds95615582velds
voids95414672voids
voles86234042voles
volts85421292volts
welds94719162welds
wilds94818202wilds
woads94818442woads
woalds10427582woalds
wold85429072wold_
wolfs116214162wolfs
woods95723032woods
words95425072words
worlds10568732worlds
yods86531182yo_ds
yolks125412772yolks

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538002431.65632487.9
3Display Results2432430.0633857.1
 (SQL Overall)1786912432.01588680.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.