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

210 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
buccal124824(None) 
bacca111012182bacca_
baccae12119702baccae
bubal94218212bu_bal
buccally1744622buccally
burial84117622burial
bursal84414822bursal
coccal9310222coccal
ducal84816422du_cal
ductal938992ductal
nuchal11218872nuchal
succah1336642succah
sulcal8311272sulcal
yucca12467442yucca_
yuccas13426552yuccas
abuttal954553abuttal
aecial84817313aecial
apical10913903apical
audial7312993audial
aural54428963au_ral
baal67033113b__aal
baccara1347143baccara
baccate131011263baccate
bacula103112673bacula
bal56662723b___al
banal75925993b_anal
barbal104016663barbal
barca91319433barca_
barcas101016603barcas
basal75722283b_asal
becalm1239203b_ecalm
becap114315053b_ecap
bechalk1845803bechalk
becrawl1444583becrawl
benzal1739643benzal
bharal1138893bharal
biaxal1536093biaxal
bifocal1445373bifocal
binal75323823b_inal
bluecap1343113bluecap
bobcat12411253bobcat
bocce114313113bocc_e
bocces123912023bocces
bocci113512713bocc_i
boccia12338793boccia
boccias13307193boccias
boccie123311453boccie
boccis123911133boccis
boral75831703b_oral
boreal84817213boreal
boxcar1734753boxcar
breccial1444693breccial
bridal9511453bridal
bromal10313653bromal
brumal1049503brumal
brutal859383brutal
bubale104014623bu_bale
bubals103513843bu_bals
bubba84311793bubba_
bubbas94110703bubbas
buck125129903bu_c_k
bucked155121063bucked
bucker145420463bucker
bucket144620733bucket
buckle144815193buckle
bucko134614023bu_cko
buckos143710893buckos
buckra1436753buckra
buckram1746113buckram
buckras1537343buckras
bucks134824293bu_cks
bucksaw1844373bucksaw
bucktail1653913bucktail
buffalo1553723buffalo
buhl95518223bu__hl
bulbar1039583bulbar
bulbel104510683bulbel
bulbil10389573bulbil
bulbul10348073bulbul
bull65634873bu__ll
bulla74620563bulla_
bullae83416163bullae
bummalo1353793bummalo
buna64730723bu_na_
bunas75126573bu_nas
bunch125118603bunc_h
bunchy16437463bunchy
bunco94616083bunc_o
buncos104011593buncos
bunya103810093bunya_
bunyas11359433bunyas
bura66139533bu_ra_
buran75225303bu_ran
buras74736293bu_ras
bureau8712523bureau
burghal1335073burghal
burials93612083burials
burka114617693burka_
burkas124513803burkas
burl64937183bu__rl
burlap1098353burlap
burqa165013093burqa_
burqas174410903burqas
bursa74921523bursa_
bursae84515603bursae
bursar85413253bursar
bursas85318273bursas
busbar1038453busbar
bushel114513943bushel
busman10310253busman
butch125416543butc_h
buttals938503buttals
butyl1089103bu_tyl
butyral1245713butyral
byssal1134993byssal
caecal103713733caecal
cecal94619113_cecal
cercal10314123cercal
coal66939253__coal
crucial1157893crucial
cubical1338463cubical
cuneal8611513cuneal
curial84019153curial
curtal83914543curtal
cuspal1037883cuspal
decal85523233_decal
dual55928173du__al
ducat86225903du_cat
duncical1345213duncical
dural64923893du_ral
epical10413393epical
facial113615633facial
faecal11359813faecal
faucal11339963faucal
faucial1257323faucial
fecal105119213_fecal
fecial114714623fecial
fiscal1139333fiscal
focal104917673_focal
fugal95613033fu_gal
fungal10388733fungal
hubcap1553993hubcap
jacal14313703_jacal
jackal1937613jackal
jugal135612403ju_gal
jumbal1758463jumbal
jural125120483ju_ral
laical8312323laical
local74820273_local
luteal64411483luteal
mecca1139933mecca_
meccas1239493meccas
mescal104113483mescal
mezcal19367853mezcal
mucosal11155843mucosal
mudcap1335133mudcap
mudcat11311203mudcat
mughal1236263mughal
mural75225103mu_ral
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
musical1139553musical
mutual838503mutual
nucha10229793nucha_
nuchae11218513nuchae
nuchals12216933nuchals
nucleal946693nucleal
octal71214723_octal
outcall9310123outcall
pascal10812373pascal
pical95524373_pical
plical10411683plical
pucka133412803pucka_
pulpal10408453pulpal
pupal97616873pu_pal
quezal2435143quezal
racial83419243racial
rascal8511123rascal
recoal84117973recoal
rectal84418133rectal
rictal83113173rictal
rugal65916093ru_gal
rural55821173ru_ral
sacral83414413sacral
siccan1037593siccan
social8813333social
succahs1435323succahs
succor1036623succor
sural55931263su_ral
tectal83713253tectal
thecal113310303thecal
tical76021493_tical
tincal83913353tincal
tubal75517203tu_bal
tussal6288323tussal
uncap9312283_uncap
uncial83715223uncial
ureal56722683_ureal
urial54823023_urial
usual5310183_usual
uveal84411073_uveal
vocal104715643_vocal
vulval12417663vulval
wicca1247253wicca_
wiccan1335033wiccan
wiccas1336543wiccas
yuca95716723yu_ca_
yucas106013913yu_cas
yucch15417433yucc_h

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.1401276364.3
2DLD Change Limit1127162106.19018209.4
3Display Results2102100.0762763.2
 (SQL Overall)1786912106.40627894.3
 
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.