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

286 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
yucca1246744(None) 
yuca95716721yu_ca
yuccas13426551yuccas
yucch15417431yucch
bacca111012182bacca
buccal1248242buccal
mecca1139932mecca
musca9311762musca
nucha10229792nucha
pucka133412802pucka
succah1336642succah
wicca1247252wicca
yecch15558092yecch
yucas106013912yucas
yuch125818532yu_ch
yuck136423532yu_ck
yucks144717192yucks
yucky175411692yucky
yuga85615422yu_ga
yurta86014252yurta
abaca95118043abaca
acta69524803_acta
aecia73819283aecia
areca75618633areca
aucuba1045493aucuba
aura45836253au_ra
baccae12119703baccae
barca91319433barca
bocce114313113bocce
bocci113512713bocci
boccia12338793boccia
bubba84311803bubba
buck125129903bu_ck
bucko134614023bucko
buckra1436753buckra
bucks134824293bucks
bulla74620563bulla
buna64730723bu_na
bunch125118603bunch
bunco94616083bunco
bunya103810093bunya
bura66139533bu_ra
burka114617693burka
burqa165013093burqa
bursa74921523bursa
butch125416543butch
caca85528083_caca
caeca93915133caeca
ceca84820783_ceca
chica125818263chica
circa9311403circa
coca88030643_coca
coccal9310223coccal
cocci82812673cocci
cocoa98517883cocoa
culch124512833culch
culpa93610963culpa
cuppa11398523cuppa
curch124415413curch
curia74523773curia
cutch125116193cutch
dacha114812573dacha
dicta84915633dicta
ducal84816423ducal
ducat86225903ducat
duce76933503du_ce
duces86327473duces
duchy144310873duchy
duci76422623du_ci
duck115929173du_ck
ducks124823213ducks
ducky154216113ducky
duct75735463du_ct
ductal938993ductal
ducts85319893ducts
dulia61014983dulia
duma75524453du_ma
dumka12438833dumka
dunce86319263dunce
dunch115316263dunch
dura55232113du_ra
durra65315793durra
dutch114713823dutch
erica7316543erica
facia103218463facia
felucca1442123felucca
finca104714503finca
fuci95720313fu_ci
fuck134924633fu_ck
fucks144419253fucks
fucus105515893fucus
fulcra1135213fulcra
guaco85012163guaco
guava938583guava
guck114922533gu_ck
gucks123917303gucks
gulch113810603gulch
gumma105313103gumma
gutta64613383gutta
hubcap1553993hubcap
huck135927633hu_ck
hucks144322173hucks
huic94818053huic_
hula74923753hu_la
hunch136416213hunch
hutch135414093hutch
huzza1646093huzza
juba134916983ju_ba
juco134716203ju_co
jucos144111713jucos
juga126417323ju_ga
juice14311323juice
juicy1738283juicy
junco144612203junco
junta123713673junta
jura116024893ju_ra
kuna85120703ku_na
kurta95113913kurta
loca65527683_loca
luce65132573lu_ce
luces75528433luces
lucid84314573lucid
luck105329823lu_ck
lucks115723563lucks
lucky145515013lucky
lucre76415523lucre
luffa11409023luffa
luma65527523lu_ma
luna46229853lu_na
lunch104917243lunch
lurch104814633lurch
lutea54819073lutea
lycea10418943lycea
lycra10317973lycra
meccas1239493meccas
mica86428253_mica
micra96214973micra
mocha1249923mocha
much115224033mu_ch
mucho125013443mucho
mucid104115253mucid
mucin93116823mucin
muck125727853mu_ck
mucks134622643mucks
mucky165015253mucky
mucor94011943mucor
mucosa10166273mucosa
mucro94513723mucro
mucus94015743mucus
mudcap1335133mudcap
mudcat11311203mudcat
mudra83912433mudra
mulch124012973mulch
mulct93820083mulct
mulla74317113mulla
munch124917103munch
mura65633293mu_ra
murra74519083murra
muscae10410673muscae
muscat10314653muscat
mutch125016173mutch
myrica1336823myrica
nubia7311233nubia
nuchae11218513nuchae
nuchal11218873nuchal
oca56731733__oca
orca65522773_orca
ouch95724633ou_ch
ounce77019933ounce
paca85132243_paca
pacha126518063pacha
pica85831493_pica
plica9613373plica
puce85127883pu_ce
puces94924633puces
puck124927943pu_ck
pucks134322103pucks
puja135714923pu_ja
pukka10457133pukka
pula65129373pu_la
puma85424123pu_ma
puna65331653pu_na
punch125118423punch
punka114515483punka
pupa85422813pu_pa
purda82914693purda
pyuria1136953pyuria
qua124821973qu__a
quack203812503quack
quick204311063quick
quota145111963quota
recce9514563recce
recta74220263recta
ruana5312423ruana
ruche104216763ruche
ruck104728333ru_ck
rucks114422053rucks
ruga56121233ru_ga
rumba93612513rumba
sacra74516993sacra
scuba94211593scuba
scuta75815753scuta
secco9312423secco
siccan1037593siccan
soca66330053_soca
spica94717943spica
stucco1044253stucco
suba64926603su_ba
succahs1435323succahs
succor1036623succor
succuba1343443succuba
such96424813su_ch
suck106131733su_ck
sucks114523073sucks
sucky144415503sucky
sucre75019103sucre
sulcal8311273sulcal
sulci7615053sulci
sulfa8313923sulfa
sumac99514883sumac
summa94713313summa
sunna55016063sunna
supra73614253supra
sura45740293su_ra
surra55521343surra
sutra54217933sutra
sutta54015333sutta
tecta74215523tecta
theca103311453theca
tuba65422363tu_ba
tuck104626573tu_ck
tucks114721123tucks
tufa75016613tu_fa
tuna45127843tu_na
tunica8379813tunica
ulna46317323_ulna
ulva75412693_ulva
uncap9312283_uncap
unci65019463_unci
uncia75015163uncia
unco66021403_unco
urea46528053_urea
ursa44116903_ursa
uta37425583_u_ta
uvea74712653_uvea
vacua10510463vacua
vinca105315163vinca
vulva11448803vulva
wiccan1335033wiccan
wiccas1336543wiccas
ya510251503y___a
yacht13417393yacht
yack135425973y_ack
yacks144419813yacks
yautia937253yautia
yclad11246383y_clad
yea66445753y__ea
yecchs16414953yecchs
yech127220533y_ech
yechs136112583yechs
yechy16519083yechy
yenta83917043yenta
yerba101010763yerba
yince105214253yince
yock135924613y_ock
yocks144418373yocks
yoga87418053y_oga
yuan76120013yu_an
yuans84613323yuans
yucked164013563yucked
yugas95012063yugas
yuk106725603yu__k
yukky14425213yukky
yuks116418023yu_ks
yulan8411493yulan
yule75725143yu_le
yules84521583yules
yum86132823yu__m
yummy15429153yummy
yup86031703yu__p
yupon10469483yupon
yuppy15487913yuppy
yups96121603yu_ps
yurt76435043yu_rt
yurts87216533yurts
yutz167519883yu_tz

Search took 5 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 Filter178691836670.1061685764.2
2DLD Change Limit836672863.98620990.2
3Display Results2862860.0763763.2
 (SQL Overall)1786912864.16842872.1
 
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.