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

275 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
bolas7473376(None) 
balas76937211balas
boas66150831bo_as
bola66035561bola_
bolar75123471bolar
bolds85825281bolds
boles75448601boles
bolls75531311bolls
bolos75531371bolos
bolts76232111bolts
bolus79125541bolus
boras75938301boras
botas75328781botas
boylas113011721boylas
colas75436771colas
kolas94822231kolas
molas75132091molas
tolas54532771tolas
abomas101113582abomas
alas46358122_alas
anlas55626932anlas
atlas55821582atlas
baals76122702baals
baas66844672b_aas
babas96325732babas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
balsa77920412balsa
balsas86417522balsas
bas58681752b__as
belay105021522belay
belays114313852belays
belgas9311712belgas
bells76432162bells
bels66142492bel_s
belts75931162belts
bemas96424282bemas
betas75528762betas
bias64738172b_ias
biles75542142biles
bilks115117892bilks
bills75632862bills
bimas95521742bimas
biogas94310912biogas
biotas84313922biotas
blab86629132b_lab
blabs95619632b_labs
blae66134642b_lae
blah98625062b_lah
blahs105616512b_lahs
blam86131702b_lam
blams95023852b_lams
blase75524232b_lase
blast76532572b_last
blat66550952b_lat
blats75132502b_lats
blaw97026722b_law
blaws105620462b_laws
bloat75229922bloat
bloats85215762bloats
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blots75626172blots
blows105423832blows
boa56954032bo_a_
boar66134292bo_ar
boars75229602boars
boast75935702bo_ast
boat66360312bo_at
boats75635152boats
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244722bo_ds
boffs134915502boffs
bogan87519002bogan
bogans95714812bogans
bogles95020832bogles
bogs75742752bo_gs
bogus85616472bogus
boheas114013212boheas
bohos105618252bohos
boils75427192boils
bolases93315002bolases
bold75432812bol_d
bole66448692bol_e
boll65634752bol_l
bolo65535952bol_o
bolt66254172bol_t
bombs115818822bombs
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boots75837972boots
bops86037982bo_ps
bora66141632bora_
boral75831702boral
borals86721912borals
borax145918722borax
boreas85421732boreas
bores76448252bores
borks115727702borks
borts76735452borts
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
bota66236502bota_
bots66453952bo_ts
botts75224862botts
boules84925972boules
bouts75131312bouts
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boyar106013762boyar
boyars115611982boyars
boyla102912362boyla_
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
bras65746452b_ras
bulbs96016932bulbs
bulks115920612bulks
bulls75629572bulls
bunas75126572bunas
buras74736302buras
bylaw13408602bylaw
bylaws14415832bylaws
cholas114818002cholas
coalas87418962coalas
coals76129602coals
cocas95926572cocas
codas84724242codas
cola66541392cola_
colds85726972colds
coles76055062coles
cols66553082col_s
colts76633292colts
colzas174010512colzas
comas95833002comas
doblas93812292doblas
doles67843752doles
dolls66126922dolls
dolmas95213042dolmas
dols56943052dol_s
dolts65626312dolts
donas65926472donas
dopas85019062dopas
doulas75114992doulas
foals85721692foals
folds95221692folds
folks126017122folks
galas65731642galas
goals65521292goals
goas55239942go_as
golds75421312golds
golfs95616102golfs
holds94623242holds
holes84748652holes
holks124720562holks
hollas94616902hollas
holms105117802holms
hols76946292hol_s
holts85627912holts
horas86333102horas
hoyas115016162hoyas
hulas84920882hulas
hylas114815902hylas
iotas54821112iotas
joles125230832joles
jolts125018882jolts
jotas125717442jotas
koalas104011662koalas
koas85635102ko_as
kola85124972kola_
kolos94921212kolos
koras95927112koras
las37281472__las
lolls512121732lolls
lotas55926302lotas
moas65545342mo_as
mola66035632mola_
molal75120342molal
molar75223092molar
molars85517322molars
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
monas74732152monas
moolas83615592moolas
moras76438782moras
moxas145014402moxas
nalas55528362nalas
nolos54423352nolos
nomas74726412nomas
nonas55126652nonas
novas85215362novas
obas65730932_obas
obias76116862obias
oblast8613662oblast
oboles83815832oboles
obols73715862obol_s
obolus8378812obolus
ocas66729632_ocas
odas57230262_odas
okas85225392_okas
olds55926582_olds
oles46453472_oles
ollas54218282ollas
polar75623452polar
polars84419352polars
poles75351002poles
polis74731162polis
polkas1239102polkas
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rotas54827722rotas
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
sola45541862sola_
solan55328152solan
solans64122492solans
solar55927342solar
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
somas76030372somas
soras55041012soras
soyas84520912soyas
talas55935892talas
toeas55726422toeas
togas67823002togas
tola45236332tola_
tolan55124012tolan
tolans64319272tolans
tolar55524112tolar
tolars64817942tolars
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toras55540372toras
violas93713522violas
volar86917412volar
voles86234042voles
volts85421292volts
volvas12447992volvas
wolds95420182wolds
wolfs116214162wolfs
yogas96615602yogas
yolks125412772yolks
zoeas145815612zoeas

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 Filter178691538000.313570897.8
2DLD Change Limit538002751.51335558.5
3Display Results2752750.0803437.5
 (SQL Overall)1786912751.90693751.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.