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

325 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
balboa1038996(None) 
balboas113710071balboas
bilboa10367841bilboa
alba68328332_alb_a
baba88828342ba_b_a
babka137812912ba_bka
baboo94319502ba_boo
balata8614672balata
ballon84117492ballon
ballot84624092ballot
balsa77920412bal_sa
bamboo12310012bamboo
batboy1387532batboy
bilbo95513602bilbo_
bilboas11438722bilboas
bilbos105011192bilbos
halloa94918122halloa
aba512850953_a_b_a
abba810522643_a_bba
abbot9318453_abbot
abloom1039783abloom
abo59045963_a_bo_
aboma91114603_a_boma
abos67734413_a_bos
ala312463603_al__a
alb57342653_alb__
albas75925393_albas
albata839333_albata
albs68628573_alb_s
album92312653_album
aldol61212333_aldol
alfa77624273_al_fa
alga57927603_al_ga
algor6513053_algor
aliya83713483_aliya
allod64418373_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
alma66333023_al_ma
aloe45540193_al_oe
aloha8513613_aloha
aloof83521573_aloof
alow75328593_al_ow
alpha1049653_alpha
also46423443_also_
alto47831263_alto_
altos55822953_altos
alula5317093_alula
ambo88225133_ambo_
ambos95321243_ambos
anoa45634473_a_noa
arbor74818113_arbor
baa510650423ba___a
babas96325733ba_bas
babble94017113babble
babe86835813ba_b_e
babel95821693ba_bel
babes95834113ba_bes
babkas146010143ba_bkas
babool103012153babool
baboon103613913baboon
baboos103517013baboos
babu85829223ba_b_u
babul96317713ba_bul
babus95620333ba_bus
baby116723673ba_b_y
bacca111012183ba_cca
bacon95620593ba_con
bacula103112673bacula
bailor83412603bailor
baiza164813223ba_iza
baklava1643103baklava
baklawa1643403baklawa
bal56662723bal___
balas76937213bal_as
balatas9311833balatas
balcony1435853balcony
bald76432903bal__d
balded105417513balded
balder95318863balder
baldly12479833baldly
balds85524643bal_ds
baldy115518933bal_dy
bale66353843bal__e
baled85436443bal_ed
baleen8613053baleen
baler75635273bal_er
balers85626933balers
bales76250083bal_es
baling94829693baling
balk105132223bal__k
balked135219413balked
balker124519163balker
balks114926293bal_ks
balky145418243bal_ky
ball66043323bal__l
ballad94315323ballad
balled94926893balled
baller83825203baller
ballet84733973ballet
ballons93916953ballons
balloon93711433balloon
ballots94116033ballots
balls76236413bal_ls
ballsy11508873ballsy
bally105530103bal_ly
balm85534203bal__m
balmoral1244633balmoral
balms95723923bal_ms
balmy125217473bal_my
balneal936573balneal
bals66354043bal__s
balsam105612233balsam
balsas86417523balsas
bamboos1348753bamboos
banana83213413banana
banco94019393banco_
bancos104713893bancos
banda85223103ba_nda
bandbox1943763bandbox
bandog1038723bandog
bandora1038813bandora
banjo143812443banjo_
banjos15378893banjos
baobab946403baobab
barb85240063barb__
barbal104016663barbal
barbe95328283barb_e
barbed115121313barbed
barbel104317073barbel
barber104419323barber
barbes104526233barbes
barbet104427883barbet
barbie105018353barbie
barbs95928193barb_s
barbut104617003barbut
barca91319433ba_rca
bareboat1249943bareboat
barhop13319643barhop
barlow112911423barlow
baron78131243ba_ron
barrow114512763barrow
baryon111211613baryon
baryta114310293baryta
basion84315853basion
basso76017283basso_
bassos85313703bassos
batboys1465833batboys
bathos116215633bathos
baton75822423ba_ton
baubee103215993baubee
bauble103813213bauble
bawbee132714233bawbee
bayou10512363ba_you
bazoo163815673ba_zoo
bazooka2242623bazooka
bazoos173212623bazoos
bebop11410793b_ebop
belabor1136293belabor
belga8313233bel_ga
bellboy1445123bellboy
bellow114213353bellow
belon73924113bel_on
below104617193bel_ow
beluga936233beluga
bilboes114410233bilboes
bilby124912343bilb_y
billon83713823billon
billow114111223billow
bimbo114811863bimbo_
bimbos124610513bimbos
blab86629133blab__
blabby1234813blabby
blabs95619633blab_s
blaubok1542243blaubok
blazon1736763blazon
bloat75229923b_l_oat
blob86027093b_l_ob
blobs95620033b_lobs
bloc85023273b_l_oc
blog75723823b_l_og
blood85319523b_lood
bloom95918973b_loom
bloop96116153b_loop
blot65842323b_l_ot
blow95827193b_l_ow
boa56954033___boa
bola66035563bol__a
bollox1548743bollox
bolo65535953bol_o_
bolos75531373bol_os
bolson8410683bolson
bonbon10310073bonbon
booboo1039463booboo
boubou1038423boubou
bubba84311793b_ubba
bubo85621903b_ubo_
bulb85626693bulb__
bulbar1039583bulbar
bulbed114312773bulbed
bulbel104510683bulbel
bulbil10389573bulbil
bulbous1138293bulbous
bulbs96016933bulb_s
bulbul10348073bulbul
bulla74620563bul_la
bumboat1349023bumboat
burbot10815653burbot
busboy13307443busboy
cabob114616803ca_bob
calesa8412473calesa
calla74827073cal_la
callboy1465833callboy
callow114714663callow
calo64936443cal_o_
calos74431903cal_os
cambia124913143cambia
carbo94923843carbo_
carbon104919043carbon
carbora11310703carbora
carbos105122263carbos
carboy134914183carboy
catboat11412243catboat
coalbox1844103coalbox
dagoba1074943dagoba
dalton7311273dalton
elbow10117703_elbow
falbala1235873falbala
falcon11310293falcon
fallow124713853fallow
faltboat1346233faltboat
gala55635163gal__a
galabia1038313galabia
galea64722933gal_ea
galena74911093galena
galiot72322583galiot
gallon73715813gallon
gallop93311383gallop
galoot72719153galoot
galop84716213gal_op
gamba106018513gamb_a
gambia115912233gambia
gambol1138223gambol
halala94715093halala
hallo85127553hallo_
halloas104318463halloas
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halma108219253hal_ma
halo76437323hal_o_
halon86124863hal_on
halos85230253hal_os
halva115414433hal_va
harbor11410723harbor
hatbox1835133hatbox
hilloa94713033hilloa
holloa94914823holloa
hulloa95011183hulloa
jabot14321513ja_bot
jalop144212603jal_op
jerboa1535633jerboa
kabob134113923ka_bob
kalmia1238893kalmia
kalpa114512193kal_pa
labia75219003la_bia
labor75117313la_bor
labra75415463la_bra
lambda1146113lambda
mailbox1853563mailbox
mallow114014743mallow
maltha1137503maltha
maltol8310843maltol
mamba116317513mamb_a
mambo115215733mambo_
mambos125414493mambos
nabob93913733na_bob
nala46930393nal__a
palabra1137183palabra
palapa10310673palapa
palea75028663pal_ea
pallia83015593pallia
pallor8313673pallor
palooka1344503palooka
rambla103510933rambla
rasbora945943rasbora
sabot7931773sa_bot
sabra75317853sa_bra
sailboat1047683sailboat
salina64221123salina
saliva93110743saliva
sallow94315753sallow
salmon84614183salmon
salol55222143sal_ol
salon55228553sal_on
saloon64418023saloon
saloop84212583saloop
salpa75018353sal_pa
salsa56718923sal_sa
saltbox1643743saltbox
salvia93310753salvia
salvo84415643salvo_
salvor94711093salvor
salvos94613383salvos
samba95618773samb_a
sambo95118013sambo_
sambos104315193sambos
tabla73318363ta_bla
taboo73418093ta_boo
tabor75518393ta_bor
tala45938053tal__a
talion6317713talion
tallboy1265133tallboy
tallol63612223tallol
tallow93714203tallow
talon55824113tal_on
talooka1143493talooka
taluka10426773taluka
valor83614893val_or
valuta938743valuta
walla85321033wal_la
wallop113310293wallop
wallow123913513wallow

Search took 7 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127163255.78019501.0
3Display Results3253250.1102954.5
 (SQL Overall)1786913256.01629702.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.