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

299 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
baccae1211970(None) 
bacca111012181bacca_
baccate131011261baccate
baccara1347142baccara
baccated15148372baccated
barca91319432barca_
barcas101016602barcas
bocce114313112bocc_e
boccie123311452boccie
buccal1248242buccal
faciae112913412faciae
saccade12107032saccade
saccate111311762saccate
abaca95118043abaca_
abacas104414723abacas
accede1138303_accede
accrue1035823_accrue
accuse103411033_accuse
ace59656833_a_c_e
ache96829823_a_che
ackee115825373_ackee
acme86924323_a_cme
acne66625873_a_cne
acre67330773_a_cre
acta69524803_acta_
acuate8315633_acuate
acute74720363_acute
alae45643753_a_lae
alcade91111513_alcade
algae65319623_algae
ansae55720973_ansae
antae56828293_antae
apace94718383_apace
aquae142212713_aquae
arcade91013643_arcade
arcane81216743_arcane
areae55229743_areae
aurae54128113_aurae
baa510650423ba__a_
baaed85218163ba__aed
baal67033113ba__al
baas66844673ba__as
baba88828353ba_ba_
babas96325733ba_bas
babble94017113babble
babe86835823ba__be
babiche1644573babiche
babka137812913babka_
babkas146010143babkas
bacalao1146613bacalao
baccaras1446913baccaras
baccarat1447933baccarat
bacchant1747803bacchant
bacchante1844653bacchante
bacchic1545813bacchic
bacchii1644533bacchii
bach116131393ba_c_h
bached145519893bached
baches135426943baches
back125535763ba_c_k
backache21126063backache
backcast1887673backcast
backchat2147113backchat
backdate1748223backdate
backed155725723backed
backer144525523backer
backhoe1847153backhoe
backs135729623ba_cks
backsaw1836203backsaw
backset15314193backset
backup1646613backup
bacon95620593ba_con
bacons104917583bacons
bacula103112673bacula
baddie104114033baddie
bade75140883ba__de
badge94819693ba_dge
badman113813843badman
baffle14399873baffle
baggage1235633baggage
baggie102912193baggie
bagman114613813bagman
bailee84526013bailee
bailie83818363bailie
baiza164813223baiza_
baizas173810823baizas
baize164717393ba_ize
bake105637513ba__ke
balas76937213ba_las
bale66353843ba__le
ballad94315323ballad
ballade104012563ballade
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banal75925993ba_nal
banco94019393banc_o
bancos104713893bancos
banda85223113banda_
bandage11311023bandage
bandas95120543bandas
bane65250433ba__ne
bangle94018963bangle
banian8315383banian
banjax2234763banjax
bantam10314063bantam
banyan1139483banyan
banzai1737653banzai
baobab946403baobab
barbal104016663barbal
barbate11314543barbate
barbe95328283ba_rbe
barbie105018353barbie
barchan1469133barchan
barde85330773ba_rde
bare65460523ba__re
barege94713543barege
barge85631023ba_rge
bargee94624443bargee
barite84224813barite
barman103519703barman
barmie103816393barmie
barque17239553barque
barrage10710843barrage
barre75929543ba_rre
barware12610703barware
barye105021493ba_rye
baryte115312883baryte
basal75722283ba_sal
bascule1136573bascule
base64847023ba__se
bashaw14349303bashaw
basque17259083basque
baste74829983ba_ste
batch124620103batc_h
batched154114243batched
batcher144414853batcher
batches144019613batches
bate66552423ba__te
bateau8810563bateau
bathe105822883ba_the
batman105214063batman
battle85217863battle
battue84311003battue
baubee103215993baubee
bauble103813213bauble
bawbee132714233bawbee
bawtie113812143bawtie
bayman133712703bayman
bazaar17306403bazaar
bazar163816003ba_zar
bearcat11611913bearcat
became123213163became
becap114315053b_ecap
become123312593become
bice86235563b_ic_e
bicycle1643993bicycle
biface1358103biface
blackcap2043073blackcap
blae66134643b__lae
bobcat12411253bobcat
bocces123912023bocces
bocci113512713bocc_i
boccia12338793boccia
boccias13307193boccias
boccies133311513boccies
boccis123911133boccis
boche124216953b_oche
boscage1276533boscage
boucle103712783boucle
boxcar1734753boxcar
brace95629273brac_e
brae65639113b__rae
brocade1238533brocade
broche133612103broche
buckle144815193buckle
bullae83416163bullae
bursae84515603bursae
caca85528083ca_ca_
cacao95420003ca_cao
cacas95627983ca_cas
cache125122483ca_che
cackle143416923cackle
caeca93915133caeca_
caecal103713733caecal
calcar10312753calcar
cancan10314103cancan
carcase11312743carcase
cascade12118603cascade
coccal9310223coccal
dace76934923da_c_e
dacha114812573dacha_
dachas124113253dachas
dacite91115883dacite
dance85223133danc_e
daycare1355093daycare
facade1238803facade
face96140123fa_c_e
facete115014833facete
facia103218463facia_
facial113615633facial
facias113415803facias
facile112514883facile
faculae123210353faculae
faecal11359813faecal
falcate12311623falcate
farce104925323farc_e
farcie114816473farcie
fasciae1247523fasciae
faucal11339963faucal
faunae95210373faunae
galeae74717453galeae
gauche1238563gauche
hackee154921833hackee
hackie154615623hackie
hackle154916813hackle
hance105424153hanc_e
jacal14313703ja_cal
jackal1937613jackal
lace66848473la_c_e
lactam10310943lactam
lactase937963lactase
lactate9312703lactate
lacunae9116803lacunae
lacune8169673lacune
laical8312323laical
lamiae84817453lamiae
lance75126723lanc_e
larvae938843larvae
lascar868573lascar
laurae64011663laurae
macaco1247853macaco
macaw12311763ma_caw
macchie1647193macchie
mace87345793ma_c_e
mache125925303ma_che
mackle143716433mackle
macle96127003ma_cle
macrame1338713macrame
maculae113412863maculae
macule104115273macule
madcap1336333madcap
mammae94613213mammae
manche133515103manche
mecca1139933mecca_
meccas1239493meccas
muscae10410673muscae
nachas114914193nachas
nacre75715363na_cre
nance74721843nanc_e
nuchae11218513nuchae
oatcake1345363oatcake
paca85132243pa_ca_
pacas96029403pa_cas
pace86345773pa_c_e
pacha126518063pacha_
pachas135017143pachas
package16128013package
palace104516923palace
paleae84820293paleae
pancake1536673pancake
parae76335703pa_rae
pascal10812373pascal
plicae10410953plicae
race66746263ra_c_e
raceme1039733raceme
racial83419243racial
rackle123917293rackle
rance75028513ranc_e
raphae114311733raphae
rascal8511123rascal
recce9514563recc_e
saccades13137253saccades
saccule1136743saccule
sacque17107113sacque
sacra74516993sacra_
sacral83414413sacral
saice75424053saic_e
salpae84614273salpae
sauce75121653sauc_e
siccan1037593siccan
soccage1236283soccage
spicae104313703spicae
succah1336643succah
tace65342513ta_c_e
tache106222373ta_che
tackle123815733tackle
thecae11299653thecae
toccate1138773toccate
unciae83215313unciae
vacate11314553vacate
vaccine1437323vaccine
vacua10510463vacua_
wacke145918623wa_cke
wicca1247253wicca_
wiccan1335033wiccan
wiccas1336543wiccas
yucca12467443yucca_
yuccas13426553yuccas

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.373479064.3
2DLD Change Limit1127162995.67319868.9
3Display Results2992990.0933215.1
 (SQL Overall)1786912996.13929107.5
 
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.